Re: Moving pg_xlog problem

Hi Tom,

> Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl