From: Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Backup of shut down standby does not work?
Date: Thu, 13 Feb 2014 16:42:47 +0100
Message-ID: <52FCE7F7.5070801@uni-graz.at> (raw)
In-Reply-To: <3A292C84467D6F41BB43EE514A36E232ACC14B05@DOMACI22.intranet2.srce.hr>
References: <52FC8452.3090202@uni-graz.at>
<3A292C84467D6F41BB43EE514A36E232ACC14B05@DOMACI22.intranet2.srce.hr>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
Attachments:
signature.asc (application/pgp-signature, 290B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: juergen.fuchsberger@uni-graz.at
Subject: Re: Backup of shut down standby does not work?
In-Reply-To: <52FCE7F7.5070801@uni-graz.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox