| From: | Philippe Ferreira <phil(dot)f(at)worldonline(dot)fr> |
|---|---|
| To: | Filip Rembiałkowski <filip(dot)rembialkowski(at)eo(dot)pl> |
| Cc: | "pobox(at)verysmall(dot)org" <pobox(at)verysmall(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: upgrade PostgreSQL 8.x on production FreeBSD |
| Date: | 2006-02-24 16:01:50 |
| Message-ID: | 43FF2DEE.3000506@worldonline.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
If the downtime is a concern, you could use Slony-1 for the migration.
Philippe Ferreira.
>pobox(at)verysmall(dot)org napisał(a):
>
>
>>Could anybody point to an on-line resource about the steps involved with
>>upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum
>>downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 -
>>upgrade (ports) 4 - import 5- start db).
>>
>>
>>
>
>here you are:
>http://www.postgresql.org/docs/8.1/static/migration.html
>
>If both PostgreSQL versions can't coexist on one host, you can use
>another one, with possibly identical setup (HW/OS/etc) for the
>migration, and transfer (use tar + netcat for minimal downtime) the
>cluster afterwards.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-02-24 16:08:58 | Re: checksum error from windows to linux |
| Previous Message | Rich Doughty | 2006-02-24 15:58:38 | Re: How do I prevent binding to TCP/IP port outside of |