Re: [GENERAL] Database synchronisation over the internet...

>> I am also working on the self same thing. I am using ssh to authenticate
>> and encrpyt the connection. The master database uses pg_dump, since the
>> data is not too large, to create a file which is securely copied via scp
>> to the slave host. An ssh connection then logs into the slave,drops the
>> table and loads the data from the dump file which has been copied over.
>>
>> seems to work so far, but there must be more refinements I can add.

>
>use ssh to create a tunnel between server A and server B, then, from
>Server A, issue somethig like:
>
>psql -h ServerB -p 5432 -c "drop table <tablename>";
>pg_dump tablename | psql -h ServerB -p 5432 ...

So encryption will be with ssh. Thanks.

Then, considering both options, my question would be what happens if the
internet connection failed for some period of time? Will the second command
keep visitors waiting?
Are there any different kind of solutions? Where only changed data is synced?
Is such a solution likely to be slower than using dumps?

Cheers Wim.