Skip site navigation (1) Skip section navigation (2)

Postgres database problem

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 (view raw or flat)
Thread:
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

Responses

pgsql-bugs by date

Next:From: Andrew SullivanDate: 2008-10-15 13:51:20
Subject: Re: BUG #4465: GROUP BY is not to SQL standard
Previous:From: Tony MarstonDate: 2008-10-15 12:47:40
Subject: Re: BUG #4465: GROUP BY is not to SQL standard

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group