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 located on 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.