two databases in one - Mailing list 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