Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Luke
Would an SSH tunnel, which is port forwarding of only a single set of ports, be allowable? If not, then the SSL web option may be the best. (That one may have been posted on the SL list, not sure) Luke On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > Thanks for the reply! We do use Openvpn for

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
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

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
Thanks for the reply! We do use Openvpn for our offices but as this server is hosted so by company policy it is not allowed to have a VPN connection into to our network. Further, when it comes to the data layer we would like to have it be managed by our databases. I apologize that we still use SL,

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Charley Tiggs
Chris Travers wrote: > 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 approp

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Josh Berkus
Tim, > 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

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Chris Travers
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 firew

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Stroller
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 > inven

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Chris Travers
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

Re: [Ledger-smb-users] Postgresql Replication

2008-05-28 Thread Luke
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

[Ledger-smb-users] Postgresql Replication

2008-05-28 Thread lai
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