Re: 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 * .. ; 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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954