Re: Moving pg_xlog problem - Mailing list pgsql-admin

From Jeff Frost
Subject Re: Moving pg_xlog problem
Date
Msg-id Pine.LNX.4.64.0511072341140.15563@discord.dyndns.org
Whole thread Raw
In response to Moving pg_xlog problem  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: Moving pg_xlog problem
List pgsql-admin
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 * .. ; cd .. ; rmdir pg_xlog_orig' to resolve your
problem.

On Tue, 8 Nov 2005, Joost Kraaijeveld wrote:

> As postgres
> cd /var/lib/postgres/8.0/main
> mv pg_xlog/ pg_xlog_orig
> mkdir /opt/postgres/logs/wal
> ln -s /opt/postgres/logs/wal pg_xlog
> cp -r pg_xlog_orig/ pg_xlog
>
> As root:
> /etc/init.d/postgresql-8.0 start
>
>
>
> What did I do wrong, and even more important, what should I do?
>
> TIA
>
>

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Moving pg_xlog problem
Next
From: Joost Kraaijeveld
Date:
Subject: Re: Moving pg_xlog problem