On Thu, Oct 25, 2012 at 02:39:09AM -0200, Aníbal Pacheco wrote: > I could after some work, what I want to ask now is this: > In the middle of the pg_restore process I had to stop it (^Z) and remove one > problematic and not needed database from the generated pg_upgrade_dump_db.sql > file and then continue the process with fg, of course it failed BUT: I started > the new server and checked for my only needed database and it seems to be ok, > can I be sure that this database was restored correctly? I think that is very > probably that the answer is yes because the pg_restore process probably > restores the databases in sequence like transactions, I'm right? thanks! Pg_upgrade is quite complex. I would not trust this as a valid upgrade. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
