Try google 'slony postgresql' Never used it myself but can translate slony as elephants in plural :)
On Wed, Oct 29, 2008 at 3:39 AM, Amos Shapira <[EMAIL PROTECTED]> wrote: > Hi, > > I'm moving very sensitive production servers to a new environment and > am looking at ways to copy their databases without down time. > > We have one MySQL database and one PostgresQL database. > > For MySQL I found the following instructions which were exactly what I > imagined I should use - i.e. turn on replication between the old and > the new databases then switch over. The only worry I had was that I > never used MySQL replication before so having specific instructions > (and an option to test them in our test environment) helps reduce the > stress levels (we use MySQL 5.0.45 which comes with CentOS 5): > > http://www.softwareprojects.com/resources/programming/t-how-to-move-copy-a-live-mysql-database-and-what-1257.html > > For PostgresQL, it's less of a problem because it's a mostly "read > only" database which only our stuff updates, so a simple dump/restore > is enough but I was curios whether there is a simple way to do the > same "one-off" replication as described in the above instructions for > MySQL. > > Is there? > > Thanks, > > --Amos > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > > -- Alexander Indenbaum ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
