PgPool or alternatives

From: Simon Windsor <simon(dot)windsor(at)cornfield(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: PgPool or alternatives
Date: 2017-01-21 19:38:59
Message-ID: bdfef4d9-c91b-d9d6-134c-ad7f80fd4732@cornfield.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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 applications and external customer applications.

For the record, internal and external applications make heavy use of
Temporary tables, that are session related. This requirement means I
cannot consider normal replication methods.

Is PgPool the only viable that will allow the system the data loaders to
feed [n] databases that will be functional identical?

Simon

--
Simon Windsor

Eml: simon(dot)windsor(at)cornfield(dot)me(dot)uk
Tel: 01454 617689
Mob: 0755 197 9733

“There is nothing in the world that some man cannot make a little worse and sell a little cheaper, and he who considers price only is that man's lawful prey.”

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2017-01-21 20:09:39 Re: PgPool or alternatives
Previous Message Karsten Hilbert 2017-01-21 19:19:05 Re: Doubts regarding postgres Security