0

Apologies for the long post but i'm stumped on getting Pgpool to work for me.

Running Centos7 i have two instances of Postgres running on different ports in master replication mode.

I have successfully installed pgpool-II.

Starting pgpool i get the output :

[root@PLHSISRV035 pgpool-II-96]# pgpool -n
2018-02-07 16:21:54: pid 118373: LOG:  Setting up socket for 0.0.0.0:9999
2018-02-07 16:21:54: pid 118373: LOG:  Setting up socket for :::9999
2018-02-07 16:21:54: pid 118373: LOG:  find_primary_node_repeatedly: waiting     for finding a primary node
2018-02-07 16:21:54: pid 118373: LOG:  find_primary_node: checking backend no 0
2018-02-07 16:21:54: pid 118373: LOG:  find_primary_node: primary node id is 0
2018-02-07 16:21:54: pid 118373: LOG:  pgpool-II successfully started. version     3.7.1 (amefuriboshi)

So from here i should be able to connect using :

psql -l -p 9999 (default settings)

Instead i get the standard not running Postgres error:

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.9999"?

Can anyone help. ?

thanks,

0

Simple fix, was to include the database and user flags while connecting.

  • 1
    Please accept this answer so that your question is marked as resolved – a_horse_with_no_name Nov 29 '18 at 7:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.