PostgreSQL Migration of databases 7.2 to 7.4

From: "Mario Thomas" <mario(at)alamar(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL Migration of databases 7.2 to 7.4
Date: 2004-08-24 06:25:46
Message-ID: Zen-1BzUka-0003O3-W9@pythagoras.zen.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello All,

We have a server in our datacentre running PostgreSQL 7.2 with about 50
databases set up (for different customers). We have just commissioned a
much better specified server which is running PostgreSQL 7.4.

We need to migrate the databases from 7.2 to 7.4. The smallest database
contains about 200K of data whilst the largest database weighs in at
about 100Mb.

What's the best way to migrate the data? Would you suggest using the
pgdump tools? We've found them to be quite problematic in use and are
not entirely sure of the best command line switches to use.

We need to make sure the data and permissions get migrated, as the data
is being used for live web sites. So obviously speed of migration is
important as we will have a period of downtime to complete the
migrations.

Any suggestions/product ideas would be greatly appreciated.
Thanks in advance,

Mario

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Kennedy 2004-08-24 08:17:23 Re: psql and autocommit
Previous Message Mike Ezekiel 2004-08-24 02:18:28 Re: Looking for tool for Graphic Database Design