Re: [ADMIN] Moving pg_xlog problem

On Tue, 2005-11-08 at 13:29 -0500, Tom Lane wrote: > Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > > Panoramix:/var/lib/postgresql/8.0/main# ls /opt/ -al > > total 56 > > drwxrwxrw- 14 root staff. >^ > > drwxr-xr-x 22 root root .. > > drwx-- 3 postgres postgres

Re: [ADMIN] Moving pg_xlog problem

On Tue, 8 Nov 2005, Joost Kraaijeveld wrote: Panoramix:/var/lib/postgresql/8.0/main# ls /opt/pg_xlog/ -al total 295284 drwx-- 3 postgres postgres . drwxrwxrw- 14 root staff.. -rw--- 1 postgres postgres 0001003300B4 -rw--- 1 postgres postgres 0001003

Re: [ADMIN] Moving pg_xlog problem

Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > Panoramix:/var/lib/postgresql/8.0/main# ls /opt/ -al > total 56 > drwxrwxrw- 14 root staff. ^ > drwxr-xr-x 22 root root .. > drwx-- 3 postgres postgres pg_xlog There's your problem --- postgres can't do lookups in /

Re: [ADMIN] Moving pg_xlog problem

Joost Kraaijeveld wrote: > lrwxrwxrwx 1 root root pg_xlog -> /opt/pg_xlog Maybe this one here? Try chown'ing it to postgres:postgres and see what happens -- ___ This e-mail may be privileged and/or confidential, and the sender does not waive any related ri

Re: [ADMIN] Moving pg_xlog problem

Hi Tom, On Tue, 2005-11-08 at 13:05 -0500, Tom Lane wrote: > Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > >>> PANIC: could not open file > >>> "/var/lib/postgresql/8.0/main/pg_xlog/0001.history": Permission > >>> denied > > >> So what happens if you do: > >> ls -l /var/lib/postgresql/8.0/

Re: [ADMIN] Moving pg_xlog problem

Joost Kraaijeveld <[EMAIL PROTECTED]> writes: >>> PANIC: could not open file >>> "/var/lib/postgresql/8.0/main/pg_xlog/0001.history": Permission >>> denied >> So what happens if you do: >> ls -l /var/lib/postgresql/8.0/main/pg_xlog/0001.history > There is not a file with that name. Not

Re: [ADMIN] Moving pg_xlog problem

Hi Jeff, On Tue, 2005-11-08 at 09:11 -0800, Jeff Frost wrote: > On Tue, 8 Nov 2005, Joost Kraaijeveld wrote: > > >> Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > >>> PANIC: could not open file > >>> "/var/lib/postgresql/8.0/main/pg_xlog/0001.history": Permission > >>> denied > > So what h

Re: [ADMIN] Moving pg_xlog problem

On Tue, 8 Nov 2005, Joost Kraaijeveld wrote: Joost Kraaijeveld <[EMAIL PROTECTED]> writes: PANIC: could not open file "/var/lib/postgresql/8.0/main/pg_xlog/0001.history": Permission denied So what happens if you do: ls -l /var/lib/postgresql/8.0/main/pg_xlog/0001.history Can you po

Re: [ADMIN] Moving pg_xlog problem

On Tue, 2005-11-08 at 10:59 -0500, Tom Lane wrote: > Seems *highly* unlikely, though I suppose you could ask the Debian > maintainer what he changed between -7 and -15. I have triple checked, I even let someone else do the same procedure but history repeats itself. It does not work. I have send the

Re: [ADMIN] Moving pg_xlog problem

"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes: > 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. Seems *highly* unlikely,

Re: [ADMIN] Moving pg_xlog problem

Hi Tom, > Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > > PANIC: could not open file > > "/var/lib/postgresql/8.0/main/pg_xlog/0001.history": Permission > > denied > > Read the error message! You have a permissions problem --- > most likely, > some directory in the path to the new xlog d

Re: [ADMIN] Moving pg_xlog problem

Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > PANIC: could not open file > "/var/lib/postgresql/8.0/main/pg_xlog/0001.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

Re: [ADMIN] Moving pg_xlog problem

Joost Kraaijeveld wrote: > On Mon, 2005-11-07 at 23:46 -0800, Jeff Frost wrote: >> So, what happens if you do this as the postgres user: >> ls -l /var/lib/postgresql/8.0/main/pg_xlog/ >> I'm going to guess the output indicates you have a directory inside >> pg_xlog called pg_xlog_orig. > Sorry, cop

Re: [ADMIN] Moving pg_xlog problem

On Mon, 2005-11-07 at 23:46 -0800, Jeff Frost wrote: > So, what happens if you do this as the postgres user: > > ls -l /var/lib/postgresql/8.0/main/pg_xlog/ > > I'm going to guess the output indicates you have a directory inside pg_xlog > called pg_xlog_orig. Sorry, copied and pasted the wrong p

Re: [ADMIN] Moving pg_xlog problem

So, what happens if you do this as the postgres user: ls -l /var/lib/postgresql/8.0/main/pg_xlog/ I'm going to guess the output indicates you have a directory inside pg_xlog called pg_xlog_orig. You probably just need to cd /opt/postgres/logs/wal/pg_xlog_orig as the postgres user and 'mv * .

[ADMIN] Moving pg_xlog problem

Hi, I am trying to move the pg_xlog directory to another disk by using a symbolic link. But I keep getting the following error message: Panoramix:/var/lib/postgresql/8.0/main# /etc/init.d/postgresql-8.0 start Starting PostgreSQL 8.0 database server: main(FAILED) The PostgreSQL server failed to s