Missing a good db migration/db move tool

From: "Soeren Laursen" <sl(at)scrooge(dot)dk>
To: pgsql-admin(at)postgresql(dot)org
Subject: Missing a good db migration/db move tool
Date: 2003-10-17 09:13:09
Message-ID: 3F8FCEC5.8161.16C2DA@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have using postgresql for a while and is on the stage to move a few
databases to a new server (7.1.x to 7.3.x - linux/debian).

During test and the planing I have found no tool that can help me to
move the databases. pgAdminII fails, pg_dump have problems with
functions and unicode, EMS Postgresql Extract fails as well.

So is I the only one that could use a tool like that?

If not I would like to modify pg_dump/pg_restore to a new tool
(pg_move?) one could use in for migrating development databases and
productions databases as well.

Comment/suggestens are more that welcome, ("Why don't you use
http://www.xxx.yyy.zzz" are more than welcome ;-) ).

Regards,

Søren,

Browse pgsql-admin by date

  From Date Subject
Next Message Ganesan Kanavathy 2003-10-17 09:13:52 File system level backup
Previous Message Oli Sennhauser 2003-10-17 08:36:47 Solution: Second postmaster / second DB cluster