Re: Re: Moving a live production database to different server and postgres release

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Moving a live production database to different server and postgres release
Date: 2010-06-14 14:48:52
Message-ID: b3781e27f0a870b5da55de66dd75ef8c@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

...
> After your post I had a look at Slony-I, which, according to it web
> page, requires postgres 8.3 or later, so I guess that won't work. That
> leaves Bucardo: will it work on a Windows system?

The daemon itself cannot run on a Windows system, but it's perfectly fine
for any of the databases it is replicating to be Windows. So in this case
you'd just install Bucardo on the BSD machines, tell it about the Windows
box, setup the tables, kick it off in onetimecopy mode, then do the final
transfer once the initial copying is done.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201006141048
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkwWQUAACgkQvJuQZxSWSsjMiQCcDo9QJDdeZKziEBFBeR0yyb9M
ATkAoJO1dJkkeADnDcPLTtUkcGUF8tRF
=EF+J
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2010-06-14 14:49:28 Re: Partial indexes instead of partitions
Previous Message Raymond O'Donnell 2010-06-14 14:38:51 Re: Re: Moving a live production database to different server and postgres release