Re: Re: Moving a live production database to different server and postgres release - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Re: Moving a live production database to different server and postgres release
Date
Msg-id b3781e27f0a870b5da55de66dd75ef8c@biglumber.com
Whole thread Raw
In response to Re: Moving a live production database to different server and postgres release  (Ulas Albayrak <ulas.albayrak@gmail.com>)
List 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@turnstep.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-----



pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Re: Moving a live production database to different server and postgres release
Next
From: Sam Mason
Date:
Subject: Re: Partial indexes instead of partitions