[pgpool-general: 1979] pgpool-II online recovery via rsync: postgresql won't start after the recovery

armaeth at libero.it armaeth at libero.it
Fri Aug 2 04:08:32 JST 2013

Hi all.


I am running postgresql 9.1.9 and pgpool 3.1.6 under CentOS 6.4.


I tried to set up online recovery as per pgpool-II user manual, section "Online recovery with rsync".


For this purpose I am using the pgpool_recovery script that's under the sample folder and available on github @:



The problem I have is that on the server being recovered postgresql won't start and log the following under pg_log:


LOG: database system was shut down at 2013-07-31 18:02:12 BST
LOG: WAL file is from different database system
DETAIL: WAL file database system identifier is 5894553353380019103, pg_control database system identifier is 5894200307068334067.
LOG: invalid primary checkpoint record
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 1549) was terminated by signal 6: Aborted


I guess that the folders being rsync'ed by the pgpool_recovery script are not comprehensive?

I wa tempted to rsync the whole PG_DATA folder, but then I thought that there are a number of things that I don't want to overwrite, such as the logs under pg_log on the failed node.


Would anybody be able to make any recommendation on this and make the necessary changes to the official pgpool_recovery file in the code repository, please?


Thank you.


Kind Regards,


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130801/d35ae3bc/attachment.html>

More information about the pgpool-general mailing list