Hi Ashish,
could you please help me setting up the pgpool , i am currenlty into same
like u had asked to setup .
I have mater/slave 9.4 and i would need to setup pgpool so that app connects
to pgpool and diverts the connection to new master .
Could u please help me with ur thoughts?
Thanks,
Sub
: Ashish Chauhan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Setup pgpool-II with streaming replication
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
On Fri, Sep 9, 2016 at 3:14 AM, Ashish Chauhan
wrote:
> Thanks Venkata for your reply.
>
>
>
> Currently, we have two Postgres server with master-slave streaming
> replication. All application servers are directly pointing to master server
> only. I am planning to setup new server for PgPool, at
On 9/6/2016 2:10 PM, Ashish Chauhan wrote:
...Cannot afford downtime on db servers...
thats an impossible target in general unless you expect computer systems
to run perfectly forever without ever needing hardware or software
maintenance.there are strategies to /minimize/ downtime, such a
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
Hi,
We do have Postgres 9.4 streaming replication in Prod environment, currently we
are having issue with our DB connections and planning to implement PgPool-II
for database pooling with streaming replication.
Key Challenges:
* Cannot afford downtime on db servers.
* Add PgPo
