Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres database problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Postgres database problem
Date
Msg-id 20794.1224084410@sss.pgh.pa.us
Whole thread Raw
In response to Postgres database problem  ("Nitin Saxena" <nsaxena@systime.net>)
List pgsql-bugs
Tree view 
"Nitin Saxena" <nsaxena@systime.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

pgsql-bugs by date:

Previous
From: "Nitin Saxena"
Date:
Subject: Postgres database problem
Next
From: David Fetter
Date:
Subject: Re: BUG #4465: GROUP BY is not to SQL standard