On Wed, May 28, 2008 at 12:45 AM, Luke <[EMAIL PROTECTED]> wrote: > On Wed, 28 May 2008, [EMAIL PROTECTED] 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
