Re: Postgres database problem

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
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Julien Vadnais 2008-10-15 15:50:48 BUG #4481: Big text insert/update using functions failed
Previous Message Andrew Sullivan 2008-10-15 13:51:20 Re: BUG #4465: GROUP BY is not to SQL standard