|
Hi...
I want to create an automatic update
application. In this application, I need to update the database
because new versions of a program may use newly created tables or modified
tables, if compared to the older version program.
So, I have a database version 2.0
in Computer 'A', and I need to make a script that I can run in Computer 'B'
(still running version 1.0 of the database). After the execution of the
script, Computer 'B' tables should be exactly the same as
Computer 'A' tables.
But no data should be involved in this, all data in
Computer 'B' should be kept, and no data from Computer 'A' should be transferred
to Computer 'B'.
I tried to use pg_dump (in 'A') and pg_restore (in
'B'). I only have success with pg_restore with the --clean option, but it
erases all data.
Can anyone help me on this?
Thanks!
(sorry the not so good english ;)
)
|
