Re: Postgresql Replication

["Chris Travers" <..hidden..>]

On Wed, May 28, 2008 at 12:45 AM, Luke <..hidden..> wrote:
> 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).

Slony won't work with SL because of a lack of specified primary keys.
It is supported with LedgerSMB up to a point.

One option would just be to do a nightly dump/restore of the db using
tools like dropdb, createdb, psql, and pg_dump.....

Best Wishes,
Chris Travers
>
> Regards,
>
> Luke
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>