| From: | Vivek Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Postgresql-General General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: upgrade PostgreSQL 8.x on production FreeBSD |
| Date: | 2006-02-23 15:46:54 |
| Message-ID: | 769AFC00-0D11-43A9-B5FB-D0D21F5ED843@khera.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Feb 23, 2006, at 9:21 AM, pobox(at)verysmall(dot)org wrote:
> 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).
Upgrade from what to what?
If you're upgrading from 8.0.x to 8.0.y then there is no dump/reload.
If youre going from < 8.1 to 8.1 then there is dump/reload OR you can
use some sort of replication such as slony to copy the data, then
have a few seconds of downtime while you turn off the older DB and
put the 8.1 in its place.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Oliva | 2006-02-23 16:08:07 | Re: ExclusiveLock without a relation in pg_locks |
| Previous Message | Vivek Khera | 2006-02-23 15:44:38 | Re: Is there a way to check which indexes are being used |