| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Iñigo Martinez Lasala <imartinez(at)vectorsf(dot)com> |
| Cc: | Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Migrate postgres to newer hardware |
| Date: | 2010-04-05 12:29:57 |
| Message-ID: | 1270470597.19810.2.camel@bnicholson-desktop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 2010-04-02 at 09:58 +0200, Iñigo Martinez Lasala wrote:
> I've never worked with Bucardo and Londiste, so I cannot give you any
> hint about it.
> With slony it's not necessary to restore all database prior staring
> sync process. You only have to restore your schema but not data. Slony
> will keep them synced with source server.
>
> Anyway, if you plan to migrate to 8.4 there are some issues with
> slony. For 8.3 and higher, you will go with slony 2.X. For 8.2 with
> slony 1.X
> I'm not sure if Slony 1.x is compatible with Postgres >= 8.3, but I'm
> sure slony 2.x is not backwards compatible.
Slony 1.2.17 and higher is compatible with PG 8.4. I'd go with the
latest stable release though.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Crain | 2010-04-05 20:11:22 | Configuration questions |
| Previous Message | Fujii Masao | 2010-04-05 08:34:47 | Re: Backup from a hot standby |