two databases in one

From: Soulabaille Samantha <samantha(dot)soulabaille(at)sihpic(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: two databases in one
Date: 2006-08-16 07:13:45
Message-ID: 44E2C5A9.4070505@sihpic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I'm working with a postgresql 7.4.7
I've got two databases with the same tables and schema on two different
servers.
I want to have only one database.
So i would like to insert in the first database the data of the second
database.
I don't know how to do this because almost of the tables contains serial.
It's for production databases, i can't make mistakes.

Can anyone help me? It's urgent.

Thanks

Attachment Content-Type Size
samantha.soulabaille.vcf text/x-vcard 213 bytes

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ben K. 2006-08-16 13:48:14 Re: two databases in one
Previous Message Kis János Tamás 2006-08-16 05:35:26 Re: psql: FATAL: Database "postgres" does not exist in the