[pgpool-general: 8631] Re: FW: PGPOOL SSL setup Issues

Bo Peng pengbo at sraoss.co.jp
Wed Mar 8 17:04:23 JST 2023


Hello,

>   1.  You got an error here "Address already in use".
> 
> You need to remove the remaining socket file and restart Pgpool-II again.
> 
> How can this be done?

Use the following command to check the process id and run "kill -9 <pid>".
    
   lsof -i:9999
    
If no processes running, remove the socket file in specified in "unix_socket_directories" if it exists.

> 
>   1.  When SSL is enabled using md5
> 
> Database is SSL enabled as per below(hostssl    all             all             0.0.0.0/0            md5 clientcert=1) :

You are using  certificate authentication in PostgreSQL.
The certificate authentication does not work between Pgpool-II and PostgreSQL.
I think you got messages such as "FATAL:  connection requires a valid client certificate" in PostgreSQL's logs.

See the limitations in "Certificate Authentication":

  https://www.pgpool.net/docs/latest/en/html/auth-methods.html#AUTH-CERT

  The certificate authentication works between only client and Pgpool-II. 
  The certificate authentication does not work between Pgpool-II and PostgreSQL. 
  For backend authentication you can use any other authentication method. 

Regards,

> -----Original Message-----
> From: Bo Peng <pengbo at sraoss.co.jp>
> Sent: Monday, March 6, 2023 12:49 PM
> To: Abhishek 1. Garg (Nokia) <abhishek.1.garg at nokia.com>
> Cc: pgpool-general at pgpool.net; Srikant Sharma (Nokia) <srikant.sharma at nokia.com>
> Subject: Re: FW: [pgpool-general: 8603] PGPOOL SSL setup Issues
> 
> 
> 
> 
> 
> CAUTION: This is an external email. Please be very careful when clicking links or opening attachments. See http://nok.it/ext for additional information.
> 
> 
> 
> 
> 
> 
> 
> Hello,
> 
> 
> 
> On Mon, 6 Mar 2023 05:14:52 +0000
> 
> "Abhishek 1. Garg (Nokia)" <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com>> wrote:
> 
> 
> 
> > Steps taken:
> 
> >
> 
> >
> 
> >
> 
> >   1.  SSL switched off on both Postgresql servers
> 
> >   2.  SSL switched off on both PGPOOL servers
> 
> >   3.  pg_hba.conf contains -->  host    all             all             0.0.0.0/0               trust
> 
> >   4.  pool_hba.conf contains --> host    all         all         0.0.0.0/0             trust
> 
> >
> 
> >
> 
> >
> 
> > Output received from one of the PGPOOL servers(10.182.200.242):
> 
> >
> 
> >
> 
> >
> 
> > root at sr-vm-abh-2:/var/log/pgpool_log# psql -h localhost -p 9999 -U pgpool postgres -c "show pool_nodes"
> 
> >
> 
> > node_id |   hostname   | port | status | pg_status | lb_weight |  role   | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
> 
> >
> 
> > ---------+--------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
> 
> >
> 
> > 0       | 192.168.0.31 | 5432 | up     | up        | 0.500000  | primary | primary | 0          | false             | 0                 |                   |                        | 2023-03-06 09:55:58
> 
> >
> 
> > 1       | 192.168.0.38 | 5432 | up     | up        | 0.500000  | standby | standby | 0          | true              | 0                 | streaming         | async                  | 2023-03-06 09:55:58
> 
> >
> 
> > (2 rows)
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> > In other PGPOOL server I got error :
> 
> >
> 
> >
> 
> >
> 
> > 2023-03-06 10:03:13.616: watchdog pid 278560: LOG:  new IPC connection received
> 
> >
> 
> > 2023-03-06 10:03:13.616: watchdog pid 278560: LOG:  received the get data request from local pgpool-II on IPC interface
> 
> >
> 
> > 2023-03-06 10:03:13.616: watchdog pid 278560: LOG:  get data request from local pgpool-II node received on IPC interface is forwarded to leader watchdog node "10.182.200.242:9999 Linux sr-vm-abh-2"
> 
> >
> 
> > 2023-03-06 10:03:13.616: watchdog pid 278560: DETAIL:  waiting for the reply...
> 
> >
> 
> > 2023-03-06 10:03:13.617: main pid 278556: LOG:  leader watchdog node "10.182.200.242:9999 Linux sr-vm-abh-2" returned status for 2 backend nodes
> 
> >
> 
> > 2023-03-06 10:03:13.617: watchdog pid 278560: LOG:  new IPC connection received
> 
> >
> 
> > 2023-03-06 10:03:13.617: main pid 278556: LOG:  backend:0 is set to UP status
> 
> >
> 
> > 2023-03-06 10:03:13.617: main pid 278556: DETAIL:  backend:0 is UP on cluster leader "10.182.200.242:9999 Linux sr-vm-abh-2"
> 
> >
> 
> > 2023-03-06 10:03:13.617: main pid 278556: LOG:  backend:1 is set to UP status
> 
> >
> 
> > 2023-03-06 10:03:13.617: main pid 278556: DETAIL:  backend:1 is UP on cluster leader "10.182.200.242:9999 Linux sr-vm-abh-2"
> 
> >
> 
> > 2023-03-06 10:03:13.617: main pid 278556: LOG:  Pgpool-II parent process received SIGUSR1
> 
> >
> 
> > 2023-03-06 10:03:13.617: main pid 278556: LOG:  Setting up socket for 0.0.0.0:9999
> 
> >
> 
> > 2023-03-06 10:03:13.618: main pid 278556: FATAL:  failed to create INET domain socket
> 
> >
> 
> > 2023-03-06 10:03:13.618: main pid 278556: DETAIL:  bind on socket failed with error "Address already in use"
> 
> 
> 
> You got an error here "Address already in use".
> 
> You need to remove the remaining socket file and restart Pgpool-II again.
> 
> 
> 
> Which version of pgpool and PostgreSQL are you using?
> 
> 
> 
> As you mentioned in your last email, you had a SSL connection issue.
> 
> Could you show the error messages of PostgreSQL when you have SSL connection issue?
> 
> And could you try if you could connect to PostgreSQL using psql from the server where pgpool is running?
> 
> 
> 
> Regards,
> 
> 
> 
> 
> 
> > -----Original Message-----
> 
> > From: Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp>>
> 
> > Sent: Wednesday, March 1, 2023 10:46 AM
> 
> > To: Abhishek 1. Garg (Nokia) <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com>>
> 
> > Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>; Srikant Sharma (Nokia) <srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com>>
> 
> > Subject: Re: FW: [pgpool-general: 8603] PGPOOL SSL setup Issues
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> > CAUTION: This is an external email. Please be very careful when clicking links or opening attachments. See http://nok.it/ext for additional information.
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> > Hello,
> 
> >
> 
> >
> 
> >
> 
> > It works, if you set:
> 
> >
> 
> >
> 
> >
> 
> >     hostssl all         all         0.0.0.0/0             trust
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> > It fails, if you set:
> 
> >
> 
> >
> 
> >
> 
> >     host all         all         0.0.0.0/0             trust
> 
> >
> 
> >
> 
> >
> 
> > Is it correct?
> 
> >
> 
> >
> 
> >
> 
> > In your log, it seems only node1 fails.
> 
> >
> 
> > If the setting of ssl connection is the cause, pgpool should have failed to connect both node0 and node1.
> 
> >
> 
> > Can you check the log of PostgreSQL node1 if any error occurs?
> 
> >
> 
> > When ssl is enabed, can you use psql to connect to PostgreSQL using "pgpool" user on the server where pgpool is runnung?
> 
> >
> 
> >
> 
> >
> 
> >     [pgpool server]$ psql -h 192.168.0.38 -p 5432 -U pgpool postgres
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> > If you turn off ssl, can pgpool connect to both PostgreSQL nodes, and both node0 and node1 are running?
> 
> >
> 
> > Could you run "show pool_nodes" command?
> 
> >
> 
> >
> 
> >
> 
> > On Wed, 1 Mar 2023 04:38:22 +0000
> 
> >
> 
> > "Abhishek 1. Garg (Nokia)" <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>> wrote:
> 
> >
> 
> >
> 
> >
> 
> > > Yes,
> 
> >
> 
> > > It works if ssl turned off in pg_hba.conf and pool_hba.conf
> 
> >
> 
> > >
> 
> >
> 
> > > -----Original Message-----
> 
> >
> 
> > > From: Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > Sent: Wednesday, March 1, 2023 10:05 AM
> 
> >
> 
> > > To: Abhishek 1. Garg (Nokia) <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>>
> 
> >
> 
> > > Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net%3cmailto:pgpool-general at pgpool.net>>; Srikant Sharma (Nokia)
> 
> >
> 
> > > <srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com%3cmailto:srikant.sharma at nokia.com>>>
> 
> >
> 
> > > Subject: Re: FW: [pgpool-general: 8603] PGPOOL SSL setup Issues
> 
> >
> 
> > >
> 
> >
> 
> > >
> 
> >
> 
> > > CAUTION: This is an external email. Please be very careful when clicking links or opening attachments. See http://nok.it/ext for additional information.
> 
> >
> 
> > >
> 
> >
> 
> > >
> 
> >
> 
> > >
> 
> >
> 
> > > hello,
> 
> >
> 
> > >
> 
> >
> 
> > > > As mentioned in earlier email, with ssl turned off, all the connectivity works fine.
> 
> >
> 
> > > >
> 
> >
> 
> > > > P.S. -     This setup works fine when pool_hba.conf is updated with below entries, result shown below
> 
> >
> 
> > > > hostssl all         all         0.0.0.0/0             trust
> 
> >
> 
> > >
> 
> >
> 
> > > Have you disable ssl on both side of PostgreSQL <-> Pgpool-II and Pgpool-II <-> client.
> 
> >
> 
> > >
> 
> >
> 
> > > You need to turn of ssl in pg_hba.conf and pool_hba.conf.
> 
> >
> 
> > >
> 
> >
> 
> > > On Wed, 1 Mar 2023 04:24:27 +0000
> 
> >
> 
> > > "Abhishek 1. Garg (Nokia)" <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>> wrote:
> 
> >
> 
> > >
> 
> >
> 
> > > > Hello,
> 
> >
> 
> > > > As mentioned in earlier email, with ssl turned off, all the connectivity works fine.
> 
> >
> 
> > > >
> 
> >
> 
> > > > -----Original Message-----
> 
> >
> 
> > > > From: Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > > Sent: Wednesday, March 1, 2023 7:14 AM
> 
> >
> 
> > > > To: Abhishek 1. Garg (Nokia) <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>>
> 
> >
> 
> > > > Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net%3cmailto:pgpool-general at pgpool.net>>; Srikant Sharma (Nokia)
> 
> >
> 
> > > > <srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com%3cmailto:srikant.sharma at nokia.com>>>
> 
> >
> 
> > > > Subject: Re: FW: [pgpool-general: 8603] PGPOOL SSL setup Issues
> 
> >
> 
> > > >
> 
> >
> 
> > > >
> 
> >
> 
> > > > CAUTION: This is an external email. Please be very careful when clicking links or opening attachments. See http://nok.it/ext for additional information.
> 
> >
> 
> > > >
> 
> >
> 
> > > >
> 
> >
> 
> > > >
> 
> >
> 
> > > > Hello,
> 
> >
> 
> > > >
> 
> >
> 
> > > > To figure out the cause if it is a SSL connection issue or network issue, could you check if the same error occurs if you turn off ssl connection in PostgreSQL.
> 
> >
> 
> > > >
> 
> >
> 
> > > > > Error:
> 
> >
> 
> > > > > 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node:
> 
> >
> 
> > > > > make_persistent_db_connection_noerror failed on node 1
> 
> >
> 
> > > >
> 
> >
> 
> > > > Normally pgpool connects to all the backend nodes to find the primary node.
> 
> >
> 
> > > > But in your log, it failes only when connecting to node1.
> 
> >
> 
> > > >
> 
> >
> 
> > > > Any configuration difference between node0 and node1?
> 
> >
> 
> > > >
> 
> >
> 
> > > >
> 
> >
> 
> > > > On Wed, 22 Feb 2023 08:06:12 +0000
> 
> >
> 
> > > > "Abhishek 1. Garg (Nokia)" <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>> wrote:
> 
> >
> 
> > > >
> 
> >
> 
> > > > > Unable to share certificates, so sending just .conf files.
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > -----Original Message-----
> 
> >
> 
> > > > > From: Abhishek 1. Garg (Nokia)
> 
> >
> 
> > > > > Sent: Wednesday, February 22, 2023 1:34 PM
> 
> >
> 
> > > > > To: Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > > > Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net%3cmailto:pgpool-general at pgpool.net>>; Srikant Sharma (Nokia)
> 
> >
> 
> > > > > <srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com%3cmailto:srikant.sharma at nokia.com>>>
> 
> >
> 
> > > > > Subject: RE: [pgpool-general: 8603] PGPOOL SSL setup Issues
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > Hello,
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > Please refer attached files. Our Postgres DB is ssl enabled so attaching certificates as well.
> 
> >
> 
> > > > > And we want to achieve PGPOOL with SSL connectivity to Postgres with SSL, using same certificates as attached.
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > Regards
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > -----Original Message-----
> 
> >
> 
> > > > > From: Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > > > Sent: Wednesday, February 22, 2023 7:47 AM
> 
> >
> 
> > > > > To: Abhishek 1. Garg (Nokia) <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>>
> 
> >
> 
> > > > > Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net%3cmailto:pgpool-general at pgpool.net>>; Srikant Sharma (Nokia)
> 
> >
> 
> > > > > <srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com%3cmailto:srikant.sharma at nokia.com>>>
> 
> >
> 
> > > > > Subject: Re: [pgpool-general: 8603] PGPOOL SSL setup Issues
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > [You don't often get email from pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>. Learn why
> 
> >
> 
> > > > > this is important at https://aka.ms/LearnAboutSenderIdentification
> 
> >
> 
> > > > > ]
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > CAUTION: This is an external email. Please be very careful when clicking links or opening attachments. See http://nok.it/ext for additional information.
> 
> >
> 
> > > > >
> 
> >
> 
> > > > >
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > Hello,
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > Thank you for sharing the configurations.
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > > > 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node:
> 
> >
> 
> > > > > > > make_persistent_db_connection_noerror failed on node 1
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > I think the pool_hba.conf doesn't cause the error above because it is the error between pgpool and postgresql.
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > Cloud you share your postgresql.conf and pg_hba.conf?
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > On Mon, 20 Feb 2023 04:19:53 +0000 "Abhishek 1. Garg (Nokia)"
> 
> >
> 
> > > > > <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>> wrote:
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > > Below are the details
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > root at sr-vm-abh-1:/etc/pgpool2# cat pool_passwd
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > pgpool:TEXTpgpool
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > postgres:TEXTpostgres
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > root at sr-vm-abh-1:/etc/pgpool2# pwd
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > /etc/pgpool2
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > root at sr-vm-abh-1:/etc/pgpool2#
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > -----Original Message-----
> 
> >
> 
> > > > > > From: Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > > > > Sent: Friday, February 17, 2023 5:53 PM
> 
> >
> 
> > > > > > To: Abhishek 1. Garg (Nokia) <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>>
> 
> >
> 
> > > > > > Cc: pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net%3cmailto:pgpool-general at pgpool.net>>; Srikant Sharma (Nokia)
> 
> >
> 
> > > > > > <srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com<mailto:srikant.sharma at nokia.com%3cmailto:srikant.sharma at nokia.com>>>
> 
> >
> 
> > > > > > Subject: Re: [pgpool-general: 8603] PGPOOL SSL setup Issues
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > [You don't often get email from
> 
> >
> 
> > > > > > pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>. Learn why this
> 
> >
> 
> > > > > > is important at https://aka.ms/LearnAboutSenderIdentification ]
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > Hi,
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > Error:
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node:
> 
> >
> 
> > > > > > > make_persistent_db_connection_noerror failed on node 1
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > Pgpool-II uses the user specified in "sr_check_user" to fine the primary node.
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > Because sr_check_password is empty, Pgpool-II will read the password from pool_passwd file.
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > Please check if you have set the password correctly in pool_passwd file?
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > -------------------------
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > sr_check_user = 'pgpool'
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > sr_check_password = ''
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > -------------------------
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > On Wed, 15 Feb 2023 09:12:52 +0000
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > "Abhishek 1. Garg (Nokia)" <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com%3cmailto:abhishek.1.garg at nokia.com>>>> wrote:
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > Hi Team,
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > We are facing challenges in our Sandbox environment where we are trying to configure 2 PGPOOL nodes with 2 PostgreSQL servers(with Standby Replication).
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > Refer attached conf file and logs.
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > Error:
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node:
> 
> >
> 
> > > > > > > make_persistent_db_connection_noerror failed on node 1
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > Can you please suggest?
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > P.S. -     This setup works fine when pool_hba.conf is updated with below entries, result shown below
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > hostssl all         all         0.0.0.0/0             trust
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > [cid:image001.png at 01D9414B.C5876E00]
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > Regards
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > > Abhishek Garg
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > --
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>>
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > SRA OSS LLC
> 
> >
> 
> > > > > >
> 
> >
> 
> > > > > > https://www.sraoss.co.jp/
> 
> >
> 
> > > > >
> 
> >
> 
> > > > >
> 
> >
> 
> > > > > --
> 
> >
> 
> > > > > Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > > > SRA OSS LLC
> 
> >
> 
> > > > > https://www.sraoss.co.jp/
> 
> >
> 
> > > >
> 
> >
> 
> > > >
> 
> >
> 
> > > > --
> 
> >
> 
> > > > Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > > SRA OSS LLC
> 
> >
> 
> > > > https://www.sraoss.co.jp/
> 
> >
> 
> > >
> 
> >
> 
> > >
> 
> >
> 
> > > --
> 
> >
> 
> > > Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > > SRA OSS LLC
> 
> >
> 
> > > https://www.sraoss.co.jp/
> 
> >
> 
> >
> 
> >
> 
> >
> 
> >
> 
> > --
> 
> >
> 
> > Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp%3cmailto:pengbo at sraoss.co.jp>>>
> 
> >
> 
> > SRA OSS LLC
> 
> >
> 
> > https://www.sraoss.co.jp/
> 
> 
> 
> 
> 
> --
> 
> Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp>>
> 
> SRA OSS LLC
> 
> https://www.sraoss.co.jp/


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/



More information about the pgpool-general mailing list