Re: Postgres database problem

"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