Re: pg_dump out of shared memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tfo(at)alumni(dot)brown(dot)edu (Thomas F(dot) O'Connell)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump out of shared memory
Date: 2004-06-21 13:44:52
Message-ID: 1553.1087825492@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tfo(at)alumni(dot)brown(dot)edu (Thomas F. O'Connell) writes:
> In using pg_dump to dump an existing postgres database, I get the
> following:

> pg_dump: WARNING: out of shared memory
> pg_dump: attempt to lock table <table name> failed: ERROR: out of
> shared memory
> HINT: You may need to increase max_locks_per_transaction.

> Am I correct in thinking that, despite the
> hint, it's more likely that I need to up the shared_buffers?

No.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-06-21 13:47:10 Re: PGSQL service dieing...
Previous Message Shanmugasundaram Doraisamy 2004-06-21 13:44:16 Re: Need help with Dead Lock - reg.