Re: How to merge 3 databases in one database quickly

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Nagib Abi Fadel <nagib_postgres(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to merge 3 databases in one database quickly
Date: 2003-06-07 19:11:15
Message-ID: 20030607191115.GN3124@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 04, 2003 at 12:52:00AM -0700, Nagib Abi Fadel wrote:
> I'm trying to merge 3 databases in one database using pg_dump.

> What i want to know is : IS THERE ANY OTHER WAY TO MERGE THE 3
> DATABASES QUICKLY WITHOUT GETTTING ERRORS ???

I think you can create a dump using -Fc or -Ft and then restore with
pg_restore using -d to specify on what database to restore.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Granting software the freedom to evolve guarantees only different results,
not better ones." (Zygo Blaxell)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2003-06-07 19:16:13 Re: update phenomenom
Previous Message Henrik Steffen 2003-06-07 18:18:17 Re: update phenomenom