Hi.
I had to implement something similar some time ago. Basically, a group of
database servers (postgres) geographically distributed, with each one having a
group of servers in each datacenter, and each server preferring the nearest
database server, but allowing connections to a further one if
Simon Windsor schrieb am 21.01.2017 um 21:26:
I was wondering if there is another option that will allow me to
spool all ALTER|CREATE|DELETE|DROP|INSERT|UPDATE commands to all
nodes, and SELECTs to any of the connected nodes. The apllication can
actually handle separate READ|WRITE nodes from how
Hi
Thanks for the reply. We were not planning to use pgPools connection
pool mode, but its replication mode.
Our tests with pgPool allow us to install a backup db via pgPool to each
node, and tests loads overnight of 10+GB of inserts/updates/deletes all
work fine, with only a slight loss of
Simon,
* Simon Windsor (simon.wind...@cornfield.me.uk) wrote:
> My employer wants to move from an in house Oracle solution to a
> cloud based Postgres system. The system will involve a number of
> data loaders running 24x7 feeding several Postgres Databases that
> will be used by internal applicat
