pg_upgrade: out of memory

From: deepak <deepak(dot)pn(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_upgrade: out of memory
Date: 2012-02-06 22:14:55
Message-ID: CAALYutcivUpo1Y+zW1=Jbqzty5dZBqm9mwDkd==sH+2eFb33nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

While running pg_upgrade, on one instance, it ran out of memory during the
final stages of upgrade
(just before it starts to "link" old database files to new ones).

We are using Postgres 9.1.1, and I see that there were some fixes to
pg_upgrade in 9.1.2, though
it doesn't mention anything about memory issues as such.

Wondering if anyone has run into a similar type of situation, and if so,
how to solve it?

Also, is it possible to recover the database once pg_upgrade aborts in this
manner?

Here's an excerpt from the log while running pg_upgrade:
...
"bin/pg_ctl" -w -D "data" stop
waiting for server to shut down....LOG: received smart shutdown request
LOG: shutting down
.......LOG: database system is shut down
. done
server stopped
Restoring user relation files
Restoring user relation files
pg_upgrade: out of memory

pg_upgrade: out of memory

Thanks for any pointers,

Deepak

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Potts 2012-02-06 23:03:34 problems connecting to php via pg_connect and PGCLUSTER
Previous Message 84.le0n 2012-02-06 21:48:12 SOUNDEX call