help with upgrade from 9.1 to 9.2

Hi, I'm trying to upgrade from 9.1 to 9.2 but lc_collate issue is very
difficult to solve, How I know the old lc_collate? I've only could grepped
old settings lc_numeric, lc_time, lc_messages and lc_monetary all them =
'C' but I don't know what lc_collate was or how to find it. please help.
Thanks

(sorry if this message gets dupplicated, I've sent a copy just a sec before
confirm the list membership)

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!

On Thu, Oct 25, 2012 at 12:18 AM, Aníbal Pacheco <apacheco.uy@gmail.com>wrote:

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