From: | Jorge Alberto Fuentes Casillas <buen_sama(at)yahoo(dot)com(dot)mx> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | DB Transfer |
Date: | 2010-09-23 17:22:05 |
Message-ID: | 996022.3996.qm@web112402.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello everyone... again. Some of you know what i want to do by the name of
the subject, however i will explain it again along with the suggestions that
some of you have kindly told me:
I have my postgres DB server with 2 databases, which are simmilar from each
other but differents at the same time, what i am doing is to migrate from
Tinyerp db server to Openerp db server, the tables from each one are (too)
similar but different.
Postgresql 8.2 server
DB1
DB2
So what i want is to transfer the data from DB1 to DB2, table per table, i can't
do a restoration to DB2 from a DB1 backup since the rows from each DB are
slightly different. Well, some of you have told me that i could use the dblink
module to make the DBs communicate to each other, and be able to do something
like:
INSERT INTO db2.table_2 (table2_row1,table2_row2,table2_row3,...,...,...,)
FROM dblink db1.table_1 (table1_row1,table1_row2,table1_row3,...,...,...,)
or something like above but using, of course, the dblink command, now the
question is: somebody knows how to install the dblink in a postgresql 8.2
running in windows? I've found how to install it in a postgresql 8.3 in linux,
but not in windows. So far i haven't been able to find out this info.
I'll appreciate any help you may provide me. Thanks a lot (once again) and I
apologize for any molestation that i may cause.
Greetings.
From | Date | Subject | |
---|---|---|---|
Next Message | lalebarde | 2010-09-23 23:14:09 | psql -c "select * from a-user-name-that-exist fails |
Previous Message | Tom Lane | 2010-09-23 16:42:16 | Re: log options |