[pgpool-general: 6809] Re: Getting started with pgpool

[Sjoerd de Vries]

> On 7 Jan 2020, at 02:08, Bo Peng <pengbo at sraoss.co.jp> wrote:
> 
> Hi,
> 
>> recovery node 1...ERROR:  recovery is checking if postmaster is started
>> DETAIL:  postmaster on hostname:"/tmp" database:"template1" user:"sjoerd" failed to start in 90 second
>> 
>> done.
> 
> You need to be able to SSH login to localhost without password.
> 

Much appreciated, this was the missing link indeed. Got it up and running now.

> On Thu, 2 Jan 2020 09:43:53 +0100
> Sjoerd de Vries <sdevries at iventmobile.nl> wrote:
> 
>> Happy new year,
>> 
>> 
>> I have been trying to get started with pgpool.
>> Using the getting started chapter at: https://www.pgpool.net/docs/latest/en/html/tutorial-replication.html <https://www.pgpool.net/docs/latest/en/html/tutorial-replication.html>
>> 
>> I am using centos 7 and did had to make a couple of changes to pgpool_setup.
>> Attached a log of the steps I went through.
>> 
>> Now I got stuck somewhere around line 1028 of pgpool_setup. 
>> It looks like the pcp_recovery_node is trying to connect to the data1 node? 
>> The data0 node is started at line 971, however I do not see the data1 being started.
>> Is this correct or am I making a mistake somewhere else?
>> 
>> 
>> Kind Regards,
>> Sjoerd
>> 
> 
> 
> -- 
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan