Re: [ADMIN] Merging two databases

2012-06-14 Thread Amador Alvarez
Hi, Obviously it will always depends on the constraints in your schema, but why do not dump the databases out and import it into a single one properly? Once you get the new database, it should be easy to catch up with the 2 databases before the switching (with statements like insert/update int

Re: [ADMIN] Merging two databases

2012-06-12 Thread Craig Ringer
On 06/12/2012 06:23 PM, Lukasz Brodziak wrote: Hi there, Is there a way of merging two databases in postgresql in the way of differential replication? The thing is that we have two DBs with same schemas and we want to merge the data within them into one single replica. Are there any tools/ways o

[ADMIN] Merging two databases

2012-06-12 Thread Lukasz Brodziak
Hi there, Is there a way of merging two databases in postgresql in the way of differential replication? The thing is that we have two DBs with same schemas and we want to merge the data within them into one single replica. Are there any tools/ways of doing this? Of course when the merged db is cre