[pgpool-general: 3646] Re: Adding a New Server and Recovery

[Tatsuo Ishii]

You can copy from:
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/index.html

this:
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/basebackup.sh

The document was written for pgpool-II 3.3 but I think you can use the
same script for 3.4. If not, please let me know.

Also be sure to set following in pgpool.conf:

failover_command = '/usr/local/etc/failover.sh %d "%h" %p %D %m %M "%H" %P'

Of course you need to replace "/usr/local/etc/failover.sh" with the
actual place which you put the script.

In addition to this, the user which pgpool runs needs to have ssh
access the server where PostgreSQL is running on without
password. Please look into the doc above.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> So I figured out my problem, I am missing the pgpool_recovery script file. I am unable to locate the sample one as I installed from rpm's. 
> 
> Can someone provide me with the contents of this script for version 3.4.2? 
> 
> Thanks, 
> Mark 
> 
> ----- Original Message -----
> 
> From: "MARK" <mrprice1 at comcast.net> 
> To: "Tatsuo Ishii" <ishii at postgresql.org> 
> Sent: Monday, April 20, 2015 8:38:26 AM 
> Subject: Re: [pgpool-general: 3639] Adding a New Server and Recovery 
> 
> I have tried to setup online recovery, but I'm confused about what to enter for the following options. 
> 
> Recovery command to be excuted on the first stage 
> Recovery command to be excuted on the second stage 
> 
> I tried 'pgpool_recovery' but I get an error when I click the recovery button. 
> 
> 
> ----- Original Message -----
> 
> From: "Tatsuo Ishii" <ishii at postgresql.org> 
> To: mrprice1 at comcast.net 
> Cc: pgpool-general at pgpool.net 
> Sent: Sunday, April 19, 2015 9:47:56 PM 
> Subject: Re: [pgpool-general: 3639] Adding a New Server and Recovery 
> 
>> I am using pgpool-II 3.4 with the pgpoolAdmin tool. I've enabled replication and load balancing modes. I'm confused about the proper procedures for adding a new sever to the mix? 
>> 
>> I can add the server via the pgpoolAdmin page but how do I get it to sync up to the other databases? I'm confused on what my options are available for this and how to properly configure it? 
> 
> Have you setup "online recovery"? If so, you just type "recovery" 
> button of the newly added node. 
> 
> Best regards, 
> -- 
> Tatsuo Ishii 
> SRA OSS, Inc. Japan 
> English: http://www.sraoss.co.jp/index_en.php 
> Japanese:http://www.sraoss.co.jp 
> 
>