Re: [GENERAL] help with upgrade from 9.1 to 9.2

2012-11-07 Thread Bruce Momjian
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 c

[GENERAL] help with upgrade from 9.1 to 9.2

2012-10-24 Thread Aníbal Pacheco
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

[GENERAL] help with upgrade from 9.1 to 9.2

2012-10-24 Thread Aníbal Pacheco
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

Re: [GENERAL] help with upgrade from 9.1 to 9.2

2012-10-24 Thread Aníbal Pacheco
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