Re: Moving pg_xlog problem

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: Moving pg_xlog problem
Дата
Msg-id Pine.LNX.4.64.0511072341140.15563@discord.dyndns.org
обсуждение исходный текст
Ответ на Moving pg_xlog problem  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Ответы Re: Moving pg_xlog problem  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Список 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 по дате отправления:

Предыдущее
От: Joost Kraaijeveld
Дата:
Сообщение: Moving pg_xlog problem
Следующее
От: Joost Kraaijeveld
Дата:
Сообщение: Re: Moving pg_xlog problem