Chris: Thank you for the response! As we really need the data near real time so we are probably going to head down the Slony-I direction. Thanks for the pointer on the primary key and it just darn on me when I read your email. However, it probably shouldn't be a show stoper as it should be alright to create a primary key on the tables that needed one by the way of composite primary key or just plain adding a primary key column. This is something that we will have to decide after doing some data analysis and not break the software.
Actually, with Slony-I multi masters replication we may be able to abandon php/perl/ssh customer and order tables update and just let the replication to take care of it. Regards, Tim > On Wed, May 28, 2008 at 10:16 AM, Stroller > <[EMAIL PROTECTED]> wrote: >> >> On 28 May 2008, at 08:00, [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. ... >> >> Looking at Chris' reply it appears to me that this could get >> complicated. >> >> Is it quite impossible to open HTTPS connections at the firewall to >> your Ledger-SMB server, and restrict access only to the IP address of >> your NY office? > > I think the initial request was for SQL-Ledger. That might work > though. It would probably be better to set up some sort of VPN > though. > > One simple option is a shell script like such: > > dropdb -h $EXTERNAL_HOST -U postgres $SL_DATASET > createdb -h $EXTERNAL_HOST -U postgres $SL_DATASET > pg_dump -h $INTERNAL_HOST -U postgres $SL_DATASET | psql -U postgres > -h $EXTERNAL_HOST $SL_DATASET > > Set the appropriate variables and set up a .pgpass file, run it at > midnight via cron. > > Hope this helps, > Chris Travers >> >> Stroller. >> >> ------------------------------------------------------------------------- >> 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 > ------------------------------------------------------------------------- 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
