Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

2006-02-25 Thread [EMAIL PROTECTED]
Thank you all for the valuable advices. I'll try them on a test server and will come back. Thanks again! Iv ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

2006-02-24 Thread Filip Rembiałkowski
[EMAIL PROTECTED] 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

Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

2006-02-24 Thread Philippe Ferreira
Hi, If the downtime is a concern, you could use Slony-1 for the migration. Philippe Ferreira. [EMAIL PROTECTED] 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

[GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

2006-02-23 Thread [EMAIL PROTECTED]
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). Thanks, Iv Ray

Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

2006-02-23 Thread Vivek Khera
On Feb 23, 2006, at 9:21 AM, [EMAIL PROTECTED] 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

Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

2006-02-23 Thread Alban Hertroys
[EMAIL PROTECTED] 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). You want to make