[pgpool-general: 5963] wrong arguments for online recovery script
Benjamin Firl
bf at wisit.com
Thu Mar 1 22:57:52 JST 2018
Hallo,
our script for online recovery stage1 seems to get wrong arguments
sometimes and thus is failing.
We log the arguments, so on a successful run it prints something like
that on the master node:
recovery_1st_stage.sh
all args: /var/lib/postgresql/9.5/main 10.0.1.25
/var/lib/postgresql/9.5/main 5432
data: /var/lib/postgresql/9.5/main
recovery target: 10.0.1.25
recovery data: /var/lib/postgresql/9.5/main
If recovery fails, we get this:
recovery_1st_stage.sh
all args: /var/lib/postgresql/9.5/main localhost 5432
data: /var/lib/postgresql/9.5/main
recovery target: localhost
recovery data: 5432
unable to recover myself....exiting
2018-03-01 14:31:59 CET [10517-1] postgres at template1 ERROR:
pgpool_recovery failed
2018-03-01 14:31:59 CET [10517-2] postgres at template1 STATEMENT: SELECT
pgpool_recovery('recovery_1st_stage.sh', 'localhost', '', '5432')
This seems to happen, if the new node has a lower id than the master
node. But normally adding a new node with lower id should not be a
problem, am I correct?
We are using PostgreSQL 9.5.10 and pgpool-II version 3.7.2 (amefuriboshi).
Thanks for your help.
Kind regards
Benjamin Firl
--
+++++++++++++++++++++++++++++++++++++++++++++++++
+++ Jetzt neu Wissensmanagement für Netzwerke +++
+++ www.knodge.de +++
+++++++++++++++++++++++++++++++++++++++++++++++++
--
www.wisit.com
www.knodge.de
wisit media GmbH
Ehrenbergstr. 11
D-98693 Ilmenau
---------------------------------------------------------------------------
-
wisit media GmbH, Ehrenbergstr. 11, D-98693 Ilmenau
Registergericht Jena HRB 512472
Geschaeftsfuehrung: Dipl. Ing. Markus Duelli
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich
erhalten haben, informieren Sie bitte sofort den Absender und vernichten
Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe
dieser E-Mail ist nicht gestattet.
More information about the pgpool-general
mailing list