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.
Attachment:
signature.asc
Description: OpenPGP digital signature
