| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| 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 16:01:28 |
| Message-ID: | Pine.LNX.4.44.0306071555300.2132-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Nagib Abi Fadel writes:
> I'm trying to merge 3 databases in one database using pg_dump.
>
> pg_dump db1 > database.txt
> pg_dump db2 >> database.txt
> pg_dump db3 >> database.txt
>
> then i restore:
> psql database < database.txt
>
> I had errors when trying to restore, i fixed some of them but still i get other kinds of error.
> What i want to know is : IS THERE ANY OTHER WAY TO MERGE THE 3 DATABASES QUICKLY WITHOUT GETTTING ERRORS ???
What you tried is the right way, but there might be problems if there are
objects with identical names in the three databases. Hard to tell if you
don't tell us what errors you saw.
--
Peter Eisentraut peter_e(at)gmx(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-06-07 16:01:42 | Re: Backups and restores. |
| Previous Message | Peter Eisentraut | 2003-06-07 16:01:05 | Re: timestamp |