Re: Postgresql Replication

[Luke <..hidden..>]

On Wed, 28 May 2008, ..hidden.. wrote:

> hello all...our business has now the need to replicate our sl/postgres db
> from our main office in ca to ny as the ny system (public and outside of
> our firewall) has the need to generate non-critical read only invoice and
> inventory reports. our requirements are real simple and slony-i seems to
> be an overkill. we have also evaluated pgpool-ii but it was ruled out as
> it doesn't support x509 ssl connection (a must for business data). oralce
> and informix would have been nice as they both provide standby read-only
> databases that are very simple to manage. it is too bad that you cannot
> access a standby postgres database.

Why not use pgpool-ii over a simple p2p OpenVPN link between your two 
servers?  Or, if you don't like OpenVPN (what's not to like?), the tunnel 
option with port forwarding under SSH will do approximately the same 
thing, although OpenVPN is more automatic.

By the way: this is the LedgerSMB list, not the SQL-Ledger list (you 
specified "SL" above).

Regards,

Luke