Search Postgresql Archives

Re: cluster replication over only http protocol

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux