Re: Moving pg_xlog problem

Hi Tom,

> Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl> writes:
> > PANIC:  could not open file
> > "/var/lib/postgresql/8.0/main/pg_xlog/00000001.history": Permission
> > denied
>
> Read the error message!  You have a permissions problem ---
> most likely,
> some directory in the path to the new xlog directory isn't readable by
> postgres.
No, that is not the case as far as I can see: I could do a "touch myfile" in all directories in the path to the pg_xlog
directory,as root and as postgres. I also could do "ls -al" in every directory in the path.  

I checked all this with another Debian box which has a slightly other PostgreSQL version and there it works as
advertised.So PostgreSQL 8.0.3-7 works with symlinked pg_xlog directory and PostgreSQL 8.0.3-15 does not. 

Can I downgrade to 8.0.3-7 without dump/restore?

TIA

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl