Re: pg_upgrade: out of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_upgrade: out of memory
Date
Msg-id 6577.1348239473@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade: out of memory  ("Carrington, Matthew (Produban)" <Matthew.Carrington@Produban.co.uk>)
Responses Re: pg_upgrade: out of memory
List pgsql-general
"Carrington, Matthew (Produban)" <Matthew.Carrington@Produban.co.uk> writes:
> As its AIX I don't have top but using topas and comparing it to other processes running a successful pg_dumpall
doesn'tget very large at all. 

Hmm.  Best guess at this point is that there's some specific DDL in your
database that confuses some recent change in pg_dump.  Can you try to
narrow down what it is?  Try taking a pg_dump -s (schema only) from
the cahoot_monitoring database, load parts of that into a scratch
database, see if 9.2 pg_dump fails on that.  Alternatively, if there's
nothing terribly sensitive in your DDL, maybe you could send me the
pg_dump -s output off-list?

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Using psql -f to load a UTF8 file
Next
From: "Anibal David Acosta"
Date:
Subject: Re: [ADMIN] Windows Services and Postgresql 9.1.3