From: Bruno Wolff III <bruno@wolff.to>
To: Mario Thomas <mario@alamar.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL Migration of databases 7.2 to 7.4
Date: Tue, 24 Aug 2004 12:42:08 -0500
Message-ID: <20040824174208.GA24597@wolff.to> (raw)
In-Reply-To: <Zen-1BzUka-0003O3-W9@pythagoras.zen.co.uk>
References: <Zen-1BzUka-0003O3-W9@pythagoras.zen.co.uk>
On Tue, Aug 24, 2004 at 07:25:46 +0100,
Mario Thomas <mario@alamar.net> wrote:
> 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.
If you use the pg_dump(all) client from 7.4 to dump the 7.2 database, you
will probably find that it works a lot better with handling dependencies
than the 7.2 pg_dump(all) client did.
>
> 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.
You might look at Slony I, though I think it only works on versions back
to 7.3. If it works back to 7.2, then it could be used to sync your new
system up, allowing for a very short cutover time.
>
> Any suggestions/product ideas would be greatly appreciated.
> Thanks in advance,
>
> Mario
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruno@wolff.to, mario@alamar.net
Subject: Re: PostgreSQL Migration of databases 7.2 to 7.4
In-Reply-To: <20040824174208.GA24597@wolff.to>
References: <Zen-1BzUka-0003O3-W9@pythagoras.zen.co.uk> <20040824174208.GA24597@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox