[pgpool-general: 3070] Re: postmaster_connect_question

[jayknowsunix at gmail.com]

Also check the PostgreSQL logs on this machine. You'll probably see pg_hba.conf errors in it. That's the usual culprit in these cases.

Sent from my iPad

> On Jul 28, 2014, at 7:05 AM, oniesner <oniesner at micromata.de> wrote:
> 
> Hi list,
> 
> I am new too pgpool-II (v.3.3.3) and i managed to do some basic things (basebackup, recovery) on my two postgresql (9.1.3) servers.
> The 1st stage command is successfully called and the backup is transferred to the failed node.
> But after that i found the following in the pgpool logs and could not find how to solve this.
> I can connect (without password) to both machines in both directions.
> 
> If someone can give me a hint how to solve this, it would be very helpful
> 
> Thanks a lot
> 
> Oliver
> 
> 
> 2014-07-28 04:27:35 LOG:   pid 5068: 1st stage is done
> 2014-07-28 04:27:35 LOG:   pid 5068: check_postmaster_started: try to connect to postmaster on hostname:192.168.77.44 database:postgres user:postgres (retry 0 >times)
> 2014-07-28 04:27:35 LOG:   pid 5068: check_postmaster_started: failed to connect to postmaster on hostname:192.168.77.44 database:postgres user:postgres
> 2014-07-28 04:27:38 LOG:   pid 5068: check_postmaster_started: try to connect to postmaster on hostname:192.168.77.44 database:postgres user:postgres (retry 1 >times)
> 2014-07-28 04:27:38 LOG:   pid 5068: check_postmaster_started: failed to connect to postmaster on hostname:192.168.77.44 database:postgres user:postgres
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general