Re: URGENT: Out of disk space pg_xlog

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: URGENT: Out of disk space pg_xlog
Дата
Msg-id 1166806531.29099.6.camel@localhost.localdomain
обсуждение исходный текст
Ответ на URGENT: Out of disk space pg_xlog  ("Jeremy Haile" <jhaile@fastmail.fm>)
Список pgsql-performance
> 2006-12-22 10:50:09 LOG:  database system was not properly shut down;
> automatic recovery in progress
> 2006-12-22 10:50:09 LOG:  redo starts at 2E/8729A6E8
>
>
> This has been running for 20 minutes.  What can I do?  Please help!

1. Turn off postgresql.
2. Make tar backup of entire thing
3. Move pg_xlog somehwere that has space
4. ln postgresql to new pg_xlog directory
5. Start postgresql
6. Look for errors
7. Report back

Sincerely.

Joshua D. Drake

>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jeremy Haile"
Дата:
Сообщение: Re: URGENT: Out of disk space pg_xlog
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: URGENT: Out of disk space pg_xlog