Re: Postgresql Replication

[..hidden..]

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
> <..hidden..> wrote:
>>
>> On 28 May 2008, at 08:00, ..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. ...
>>
>> 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
>> ..hidden..
>> 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>