Re: cluster replication over only http protocol

On Wed, Aug 26, 2009 at 01:13:48AM +0200, Szabolcs MMMrton wrote:
> my situation is:
> - i have a running/working postgre databse
> - i have to make another database exactly the same as the first (for
> development purposes)
> - the two databases have only(!) http or https connection, nothing else !
>
> is there a method to set-up a cluster (replication) using only http
> protocols?

Are these two databases on different boxes? Not sure how much it
matters either way, just write a simple CGI script that does a pg_dump
of the master database. Have the other box download this and send it
through to its database to be synchronized every few hours. Is that
enough for development purposes? You could even pipe it through some
crypto code if you're worried about the data going missing.

--
Sam http://samason.me.uk/