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

[armaeth at libero.it]

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 @:

https://github.com/iakio/pgpool-II/blob/master/sample/pgpool_recovery

 

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,

 

Luigi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20130801/d35ae3bc/attachment.htm>