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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general