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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
