| Lists: | pgsql-bugs |
|---|
| From: | "Nitin Saxena" <nsaxena(at)systime(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Postgres database problem |
| Date: | 2008-10-15 13:39:31 |
| Message-ID: | 1224077971.826631692@192.168.1.202 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Hi,
I am using postgresql 7.0
When i am connecting my database it is giving error
[root(at)imap /root]# su - postgres
bash-2.04$ psql GROUPSMS
NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission denied
NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission denied
psql: FATAL 1: cannot open relation pg_log
bash-2.04$ psql
psql: FATAL 1: Database "postgres" does not exist in the system catalog.
bash-2.04$ psql GROUPSMS
NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission denied
psql: pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
(2) When i am trying to connect via application it is giving error
[root(at)imap GroupSMS]# java SendGrpSmpp
Before Connection
W 15/10/08 18:51:34 EventLog : No log file configured
SMS JDK (tm) Version 2.2 Build $Date: 2002/05/10 10:55:06 $
Copyright (c) 2001 Noctor Consulting Limited. All rights reserved.
After Connection
Before Bind
After Bind
Polling at Wed Oct 15 18:51:34 IST 2008
Something unusual has occured to cause the driver to fail. Please report this exception: java
.sql.SQLException: NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission deni
ed
at org.postgresql.Driver.connect(Driver.java:125)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at SendGrpSmpp.readSMPPtable(SendGrpSmpp.java:213)
at SendGrpSmpp.run(SendGrpSmpp.java:93)
-------------------------Within Read Group-----------------------------
inside readFromTable
Something unusual has occured to cause the driver to fail. Please report this exception: java
.sql.SQLException: NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission deni
ed
at org.postgresql.Driver.connect(Driver.java:125)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at SendGrpSmpp.readFromTable(SendGrpSmpp.java:119)
at SendGrpSmpp.run(SendGrpSmpp.java:94)
Kindly provide solution ,as it is urgent
Regards:
Nitin Saxena
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Nitin Saxena" <nsaxena(at)systime(dot)net> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Postgres database problem |
| Date: | 2008-10-15 15:26:50 |
| Message-ID: | 20794.1224084410@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Nitin Saxena" <nsaxena(at)systime(dot)net> writes:
> I am using postgresql 7.0
You really, really, really need to update to some remotely-modern PG
version. 7.0 *will* eat your data someday.
> NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission denied
So, what's the permissions on /var/lib/pgsql/data/pg_log ?
(Hint: should be mode 600 owner postgres)
regards, tom lane
| From: | Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy> |
|---|---|
| To: | Nitin Saxena <nsaxena(at)systime(dot)net> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Postgres database problem |
| Date: | 2008-10-15 17:20:05 |
| Message-ID: | 48F62645.3050405@ort.edu.uy |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Nitin Saxena escribió:
> Hi,
>
> I am using postgresql 7.0
> When i am connecting my database it is giving error
> [root(at)imap /root]# su - postgres
> bash-2.04$ psql GROUPSMS
> NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission
> denied
> NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission
> denied
> psql: FATAL 1: cannot open relation pg_log
> bash-2.04$ psql
> psql: FATAL 1: Database "postgres" does not exist in the system catalog.
> bash-2.04$ psql GROUPSMS
> NOTICE: mdopen: couldn't open /var/lib/pgsql/data/pg_log: Permission
> denied
> psql: pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
>
> (2) When i am trying to connect via application it is giving error
>
> [root(at)imap GroupSMS]# java SendGrpSmpp
> Before Connection
> W 15/10/08 18:51:34 EventLog : No log file configured
> SMS JDK (tm) Version 2.2 Build $Date: 2002/05/10 10:55:06 $
> Copyright (c) 2001 Noctor Consulting Limited. All rights reserved.
> After Connection
> Before Bind
> After Bind
> Polling at Wed Oct 15 18:51:34 IST 2008
> Something unusual has occured to cause the driver to fail. Please
> report this exception: java
> .sql.SQLException: NOTICE: mdopen: couldn't open
> /var/lib/pgsql/data/pg_log: Permission deni
> ed
>
> at org.postgresql.Driver.connect(Driver.java:125)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at SendGrpSmpp.readSMPPtable(SendGrpSmpp.java:213)
> at SendGrpSmpp.run(SendGrpSmpp.java:93)
> -------------------------Within Read Group-----------------------------
> inside readFromTable
> Something unusual has occured to cause the driver to fail. Please
> report this exception: java
> .sql.SQLException: NOTICE: mdopen: couldn't open
> /var/lib/pgsql/data/pg_log: Permission deni
> ed
>
> at org.postgresql.Driver.connect(Driver.java:125)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at SendGrpSmpp.readFromTable(SendGrpSmpp.java:119)
> at SendGrpSmpp.run(SendGrpSmpp.java:94)
>
> Kindly provide solution ,as it is urgent
>
>
>
>
>
> Regards:
>
> Nitin Saxena
Hola , probá
chown -r postgres: /var/lib/pgsql/data
el "-r" es para que sea recursivo