Re: help with upgrade from 9.1 to 9.2

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. +