Re: pg_upgrade: out of memory

"Carrington, Matthew (Produban)" <Matthew.Carrington@Produban.co.uk> writes:
> I have attempted to upgrade my Postgres installation this morning from 9.0.1 to 9.2.0 and it failed with an out of
memoryproblem using pg_dumpall to dump the first database. 

Hm.  I'm not aware of any reason for 9.2 pg_dump to take hugely more
memory than 9.0.  How big is the database (how many objects)?  When
you run 9.0 pg_dump against it, how big does the process get?  (Watching
it in "top" is probably a close enough answer here.)

            regards, tom lane