Re: help with upgrade from 9.1 to 9.2

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Aníbal Pacheco <apacheco(dot)uy(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: help with upgrade from 9.1 to 9.2
Date: 2012-11-07 19:14:48
Message-ID: 20121107191448.GF19163@momjian.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2012-11-07 19:49:23 Re: Extra space when converting number with to_char
Previous Message Bruce Momjian 2012-11-07 19:06:20 Re: 9.1 to 9.2 requires a dump/reload?