<P>Hi all.</P>
<P> </P>
<P>I am running postgresql 9.1.9 and pgpool 3.1.6 under CentOS 6.4.</P>
<P> </P>
<P>I tried to set up online recovery as per pgpool-II user manual, section "Online recovery with rsync".</P>
<P> </P>
<P>For this purpose I am using the pgpool_recovery script that's under the sample folder and available on github @:</P>
<P><A href="https://github.com/iakio/pgpool-II/blob/master/sample/pgpool_recovery">https://github.com/iakio/pgpool-II/blob/master/sample/pgpool_recovery</A></P>
<P> </P>
<P>The problem I have is that on the server being recovered postgresql won't start and log the following under pg_log:</P>
<P> </P>
<P>LOG: database system was shut down at 2013-07-31 18:02:12 BST<BR>LOG: WAL file is from different database system<BR>DETAIL: WAL file database system identifier is 5894553353380019103, pg_control database system identifier is 5894200307068334067.<BR>LOG: invalid primary checkpoint record<BR>LOG: invalid secondary checkpoint record<BR>PANIC: could not locate a valid checkpoint record<BR>LOG: startup process (PID 1549) was terminated by signal 6: Aborted</P>
<P> </P>
<P>I guess that the folders being rsync'ed by the pgpool_recovery script are not comprehensive?</P>
<P><BR>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.</P>
<P> </P>
<P>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?</P>
<P> </P>
<P>Thank you.</P>
<P> </P>
<P>Kind Regards,</P>
<P> </P>
<P>Luigi</P>