Postgres Pro
Downloads
Home   >   mailing lists

Re: Setup pgpool-II with streaming replication - Mailing list pgsql-general

From Venkata B Nagothi
Subject Re: Setup pgpool-II with streaming replication
Date
Msg-id CAEyp7J932aTorhB9ADjCuFgxvrnHSr6XkVOvT7m5QONnKHVEXg@mail.gmail.com
Whole thread Raw
In response to Setup pgpool-II with streaming replication  (Ashish Chauhan <Ashish.Chauhan@support.com>)
Responses Re: Setup pgpool-II with streaming replication  (Ashish Chauhan <Ashish.Chauhan@support.com>)
List pgsql-general
Tree view


I gone through below articles but some or other way require DB server restart which is not possible in our case. Could you please provide some documentation or steps how to achive connection pooling without any downtime?


DB server restart ? Why do you think you need to restart the database ? that can be confirmed if you could help us know your planned architecture and the existing database configuration settings.

Yes, downtime is definitely needed as the Application needs to connect to the database using pgPool port instead of DB port which is something to do with the Application server.

Regards,
Venkata B N

Fujitsu Australia

pgsql-general by date:

Previous
From: "dandl"
Date:
Subject: Re: What limits Postgres performance when the whole database lives in cache?
Next
From: John R Pierce
Date:
Subject: Re: Setup pgpool-II with streaming replication