two databases in one

Поиск
Список
Период
Сортировка
От Soulabaille Samantha
Тема two databases in one
Дата
Msg-id 44E2C5A9.4070505@sihpic.fr
обсуждение исходный текст
Ответы Re: two databases in one  ("Ben K." <bkim@coe.tamu.edu>)
Re: two databases in one  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: two databases in one  (Guido Neitzer <guido.neitzer@pharmaline.de>)
Список 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





Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Kis János Tamás
Дата:
Сообщение: Re: psql: FATAL: Database "postgres" does not exist in the
Следующее
От: "Ben K."
Дата:
Сообщение: Re: two databases in one