On Mon, Feb 22, 2010 at 11:39 PM, Net Tree Inc. <nettree...@gmail.com> wrote: > Ok, I am just trying to find the proper way to back and restore database > that contain restriction. > The other way to ask. If I have two 99% schema similar databases. The old > one might contain few columns that does not exist in the new one and contain > constrains that the new DB does not have. In that case, what's standard to > do this? > Since they are 99% similar in schema, can I do "data dump" only ? will that > work? > If owner for database between Old and new DB are different, do I must add > that owner in by create new role? > appreciated,
What I would do is to dump and restore the db as a whole which will take care of constraint issues. Then I would alter the tables to match the new schema. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
