DB Transfer

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.

Browse pgsql-novice by date

  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