Re: Backup of shut down standby does not work?

On 02/13/2014 10:07 AM, Dubravko Sever wrote:
> Hi,
>
> Do you  have  recovery.conf and archive command  well  defined?. Because   restore command look for wall files
locatedon slave inside of `/var/postgres-wal/.  
>
> Dubravko
>
Yes, the config is correct. The only problem is the missing files in
/var/postgres-wal (which I expected not to be needed).

I think it should work without the recovery.conf too (since I expect the
backup to be consistent) , which results in this error:

2014-02-13 11:14:49 CET LOG:  incomplete startup packet
2014-02-13 11:14:49 CET LOG:  database system was shut down in recovery
at 2013-12-25 18:00:03 CET
2014-02-13 11:14:49 CET LOG:  could not open file
"pg_xlog/00000001000001E300000061" (log file 483, segment 97): No such
file or directory
2014-02-13 11:14:49 CET LOG:  invalid primary checkpoint record
2014-02-13 11:14:49 CET LOG:  could not open file
"pg_xlog/00000001000001E300000060" (log file 483, segment 96): No such
file or directory
2014-02-13 11:14:49 CET LOG:  invalid secondary checkpoint record
2014-02-13 11:14:49 CET PANIC:  could not locate a valid checkpoint record
2014-02-13 11:14:49 CET FATAL:  the database system is starting up
2014-02-13 11:14:50 CET FATAL:  the database system is starting up
2014-02-13 11:14:53 CET FATAL:  the database system is starting up
2014-02-13 11:14:53 CET FATAL:  the database system is starting up
2014-02-13 11:14:54 CET LOG:  startup process (PID 8277) was terminated
by signal 6: Aborted
2014-02-13 11:14:54 CET LOG:  aborting startup due to startup process
failure

Juergen.