PDA

View Full Version : Merging two databases



Izarrualde
09-20-2010, 03:19 PM
I've read how to do a backup and restore a database using pgadmin III
But I have not found any article on how to do to merge two separate databases.
I use Holdem Manager on two different machines, then I have built two databases which would merge into one.
How I can do this?

Izarrualde.

Patvs
09-20-2010, 11:38 PM
PostgreSQL doesn't support merging of databases.

Just import your archive folder from PC1 to PC2... (and vice versa) to keep both your databases in sync

Izarrualde
09-21-2010, 12:03 PM
on PC1 I have my database from around 2008, and PC2 in 2009 started a database like the one he had in PC1, now if I import all the hands of PC1 to PC2 have HUGE hands that would be duplicated. Does this bring me a problem?

Patvs
09-21-2010, 04:43 PM
Duplicate hands won't be reimported, so it doesn't matter if you run a import from folder and some (or all) hands were already imported before