[PERFORM] Installation Steps to migrate to Postgres 8.3.1

2008-05-13 Thread Gauri Kanekar
Hi, We want to migrate from postgres 8.1.3 to postgres 8.3.1. Can anybody list out the installation steps to be followed for migration. Do we require to take care of something specially. Thanks in advance ~ Gauri

Re: [PERFORM] Installation Steps to migrate to Postgres 8.3.1

2008-05-13 Thread Claus Guttesen
We want to migrate from postgres 8.1.3 to postgres 8.3.1. Can anybody list out the installation steps to be followed for migration. Do we require to take care of something specially. Perform a pg_dump, do a restore and validate your sql-queries on a test-server. -- regards Claus When lenity

Re: [PERFORM] Installation Steps to migrate to Postgres 8.3.1

2008-05-13 Thread Scott Marlowe
On Mon, May 12, 2008 at 11:40 PM, Gauri Kanekar [EMAIL PROTECTED] wrote: Hi, We want to migrate from postgres 8.1.3 to postgres 8.3.1. Can anybody list out the installation steps to be followed for migration. Do we require to take care of something specially. First, I'd recommend updating

Re: [PERFORM] Installation Steps to migrate to Postgres 8.3.1

2008-05-13 Thread Knight, Doug
] Installation Steps to migrate to Postgres 8.3.1 On Mon, May 12, 2008 at 11:40 PM, Gauri Kanekar [EMAIL PROTECTED] wrote: Hi, We want to migrate from postgres 8.1.3 to postgres 8.3.1. Can anybody list out the installation steps to be followed for migration. Do we require to take care of something

Re: [PERFORM] Installation Steps to migrate to Postgres 8.3.1

2008-05-13 Thread Scott Marlowe
On Tue, May 13, 2008 at 6:00 AM, Knight, Doug [EMAIL PROTECTED] wrote: Hi, Along these lines, the usual upgrade path is a pg_dump/pg_restore set. However, what if your database is large ( 50GB), and you have to minimize your downtime (say less than an hour or two). Any suggestions on how to