| From: | Diego Augusto Molina <diegoaugustomolina(at)gmail(dot)com> |
|---|---|
| To: | Jerry LeVan <jerry(dot)levan(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How can I merge two tables? |
| Date: | 2011-09-02 03:54:07 |
| Message-ID: | CAGOxLdHJJPgxJFYg6AaAhi=rRRSG-tjL8fEJx5tRjm-r20vT3g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mmm... maybe if you can dump them as inserts you'll be able to restore
them in one DB only. Important: make the restore connection autocommit
(i.e. don't put the --single-transaction flag). That way individual
INSERTs will fail without affecting the other data if that INSERT
violates the PK. This is slow! specially with large data sets.
Once you've got the data in one DB, you can use some replication
system if you want to have that DB in all your machines. One of that
systems is Slony-I, though I haven't tried it.
--
Diego Augusto Molina
diegoaugustomolina(at)gmail(dot)com
ES: Por favor, evite adjuntar documentos de Microsoft Office. Serán
desestimados.
EN: Please, avoid attaching Microsoft Office documents. They shall be discarded.
LINK: http://www.gnu.org/philosophy/no-word-attachments.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ondrej Ivanič | 2011-09-02 04:05:28 | Re: How can I merge two tables? |
| Previous Message | Mike Christensen | 2011-09-02 03:52:57 | pgAdmin3 not working with Gnome3 |