Re: URGENT: Out of disk space pg_xlog - Mailing list 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