Re: [GENERAL] trouble with upgrade from 9.0 (many schemas and tables)

2013-01-30 Thread Groshev Andrey
30.01.2013, 18:47, "Jeff Janes" : > On Tue, Jan 29, 2013 at 9:23 PM, Groshev Andrey wrote: > >>  Hello! >>  I update the databases to version 9.1. >>  Today, faced with a new challenge. >>  The database itself is not very big 60G, but has ~ 164,000

[GENERAL] trouble with upgrade from 9.0 (many schemas and tables)

2013-01-29 Thread Groshev Andrey
Hello! I update the databases to version 9.1. Today, faced with a new challenge. The database itself is not very big 60G, but has ~ 164,000 tables in 1260 schemes. I tried and pg_upgrade and pg_dumpall and pg_dump. But they all work very, very long time. For so long that I do not have patience. A

[GENERAL] trouble with pg_upgrade 9.0 -> 9.1

2012-12-17 Thread Groshev Andrey
Hello! I'm trying to update a database from version 9.0 to 9.1 by pg_upgrade. The test is normal, but the actual conversion fails. This is a bug from pg_upgrade? I just saw this in the newsletter similar error with a note that it has been fixed in 9.1.2, but I already install 9.1.7. My environmen