pg_upgrade: out of memory

["Carrington, Matthew (Produban)" <Matthew.Carrington@xxxxxxxxxxxxxx>]

Hi,

 

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 memory problem using pg_dumpall to dump the first database.

 

So after backing out the change and restarting level 9.0.1, I’ve done some basic investigation into the failure of the 9.2.0 pg_upgrade by checking output in pg_upgrade_utility.log ...

 

command: "/opt/serviceMonitoring/postgres/bin/pg_dumpall" --port 50432 --username "postgres" --schema-only --binary-upgrade  -f pg_upgrade_dump_all.sql >> "pg_upgrade_utility.log" 2>&1

pg_dump: out of memory

pg_dumpall: pg_dump failed on database "cahoot_monitoring", exiting

 

... rerunning pg_dump_all using existing version 9.0.1 ...

 

"/opt/serviceMonitoring/postgres/bin/pg_dumpall" --port 65432 --username "postgres" --schema-only --binary-upgrade  -f pg_upgrade_dump_all.sql

 

... works fine.

 

Try with version 9.2.0 as per pg_upgrade ...

 

"/opt/serviceMonitoring/postgres_9.2/bin/pg_dumpall" --port 65432 --username "postgres" --schema-only --binary-upgrade  -f pg_upgrade_dump_all.sql

 

pg_dump: out of memory

pg_dumpall: pg_dump failed on database "cahoot_monitoring", exiting

 

... tail -3 pg_upgrade_dump_all.sql ...

 

\connect cahoot_monitoring

 

... no help there.

 

Try with version 9.1.5 as per pg_upgrade ...

 

cd /tmp

"/opt/serviceMonitoring/postgres_9.1/bin/pg_dumpall" --port 65432 --username "postgres" --schema-only --binary-upgrade  -f pg_upgrade_dump_all.sql

 

... works fine.

 

Has anyone else hit this problem ?

 

Matthew

Emails aren't always secure, and they may be intercepted or changed
after they've been sent. Produban doesn't accept liability if this
happens. If you think someone may have interfered with this email,
please get in touch with the sender another way. This message and any
documents attached to it do not create or change any contract unless
otherwise specifically stated. Any views or opinions contained in this
message are solely those of the author, and do not necessarily represent
those of Produban, unless otherwise specifically stated and the sender
is authorised to do so. Produban doesn't accept responsibility for
damage caused by any viruses contained in this email or its attachments.
Emails may be monitored. If you've received this email by mistake,
please let the sender know at once that it's gone to the wrong person
and then destroy it without copying, using, or telling anyone about its
contents. Produban Servicios Informaticos Generales, S.L. (UK Branch).
Registered office: Shenley Wood House, Chalkdell Drive, Shenley Wood,
Milton Keynes MK5 6LA. Branch registration number BR 008486.
Ref:[PDB#014]