Mailing List Archive: Antw: Automatic Postgres recovery

>>> jarek <jarek@poczta.srv.pl> schrieb am 26.02.2015 um 09:36 in Nachricht
<1424939773.16039.61.camel@jlap3.macro.local>:
> Hello!
>
> I've replicated postgresql cluster with pacemaker and corosync.
>
> Testing instance of this cluster works on virtual machines, and
> sometimes after host restart, postgres remains unsychronized and I need
> to manually setup slave database with pg_basebacup. Fortunately such
> problem never happen to production cluster, but I can imagine, that in
> case of power failure similar scenario can happen to it also.

The obvious question is this: What do the logs say?

>
> Is there any way to configure it, so in case of serious slave failure,
> it will automatically perform recovery process with pg_basebackup ?
> best regards
> Jarek
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA@lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems

_______________________________________________
Linux-HA mailing list
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Hello!

Dnia 2015-02-26, czw o godzinie 12:56 +0100, Ulrich Windl pisze:

>
> The obvious question is this: What do the logs say?

2015-02-26 08:33:25 CET LOG: database system was interrupted; last
known up at 2014-12-13 23:00:06 CET
cp: cannot stat `/var/lib/postgresql/pg_archive/00000002.history': No
such file or directory
2015-02-26 08:33:25 CET LOG: entering standby mode
2015-02-26 08:33:26 CET LOG: restored log file
"0000000100000004000000D6" from archive
2015-02-26 08:33:26 CET LOG: invalid resource manager ID in primary
checkpoint record
2015-02-26 08:33:26 CET PANIC: could not locate a valid checkpoint
record
2015-02-26 08:33:26 CET LOG: startup process (PID 23454) was
terminated by signal 6: Aborted
2015-02-26 08:33:26 CET LOG: aborting startup due to startup process
failure
2015-02-26 08:46:10 CET LOG: database system was interrupted; last
known up at 2014-12-13 23:00:06 CET
cp: cannot stat `/var/lib/postgresql/pg_archive/00000002.history': No
such file or directory
2015-02-26 08:46:11 CET LOG: entering standby mode
2015-02-26 08:46:11 CET [local] FATAL: the database system is starting
up
2015-02-26 08:46:12 CET [local] FATAL: the database system is starting
up

best regards
Jarek
_______________________________________________
Linux-HA mailing list
Linux-HA@lists.linux-ha.org
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems