Am 15.06.2017 um 11:57 schrieb Martin Goodson:
The issues I think I would have with pgbouncer at the application
level is ...
1) What if an application server is down when pgbouncer tries to
update where the database IP is pointing to? When it is brought back
into service could that
On 15/06/2017 05:27, Andreas Kretschmer wrote:
Am 15.06.2017 um 01:18 schrieb Martin Goodson:
I'm just wondering how people may have implemented this. Do people
setup pgbouncer nodes on the database servers themselves, on
application servers, in the middle tier between the application and
Am 15.06.2017 um 08:26 schrieb Rory Campbell-Lange:
On 15/06/17, Andreas Kretschmer (andr...@a-kretschmer.de) wrote:
Am 15.06.2017 um 01:18 schrieb Martin Goodson:
...Do people setup pgbouncer nodes on the database servers
themselves, on application servers, in the middle tier between the
On 15/06/17, Andreas Kretschmer (andr...@a-kretschmer.de) wrote:
>
> Am 15.06.2017 um 01:18 schrieb Martin Goodson:
> >
> >...Do people setup pgbouncer nodes on the database servers
> >themselves, on application servers, in the middle tier between the
> >application and database, and so forth, or
On 15/06/17, Martin Goodson (kaema...@googlemail.com) wrote:
> On 14/06/2017 19:54, Rory Campbell-Lange wrote:
> >On 14/06/17, Martin Goodson (kaema...@googlemail.com) wrote:
> >>The new master's repmgr promote script will execute commands to pause
> >>pgbouncer, reconfigure pgbouncer to point to
Am 15.06.2017 um 01:18 schrieb Martin Goodson:
I'm just wondering how people may have implemented this. Do people
setup pgbouncer nodes on the database servers themselves, on
application servers, in the middle tier between the application and
database, and so forth, or some combination of
On 14/06/2017 19:54, Rory Campbell-Lange wrote:
On 14/06/17, Martin Goodson (kaema...@googlemail.com) wrote:
The new master's repmgr promote script will execute commands to pause
pgbouncer, reconfigure pgbouncer to point to the new database address, and
then resume.
You could just move the
On 14/06/17, Martin Goodson (kaema...@googlemail.com) wrote:
> The new master's repmgr promote script will execute commands to pause
> pgbouncer, reconfigure pgbouncer to point to the new database address, and
> then resume.
You could just move the service ip address at the new postgresql master
Hello.
Currently we're running all our PostgreSQL databases on ESX Stretch
Clusters, but our company is looking at moving away from those to a
private cloud solution.
I'm informed that, going forward, new servers provisioned for us to
install PostgreSQL databases on will be entirely