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

[Tatsuo Ishii]

What did you exactly setup pgpool-II? Can you please show me
pgpool.conf and the first stage script and the second stage script? I
assume you are trying to setup native replication mode (not straming
replication) because the script you are showing is for native
replication mode.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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