Timeline for Merging multiple databases as separate schemas in PostgreSQL
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 16, 2012 at 13:43 | history | migrated | from stackoverflow.com (revisions) | ||
| Dec 13, 2012 at 11:11 | comment | added | Junaid Malik |
@martin, @Wojtas Hi,Many thanks for your responses. Yes all the databases are on the same PostgreSQL server, and also have only one schema. I did the following steps. 1. pg_dump -h 192.168.64.183 -p 5432 -U user -i -F t -v -f "/home/user/DB1.public" -n 'public' DB1 2. pg_restore -d DBTARGET -F t -L /home/user/DB1.public -i -n publicee2 -S user -X disable-triggers Are these the correct steps?
|
|
| Dec 12, 2012 at 16:47 | history | answered | Ihor Romanchenko | CC BY-SA 3.0 |