Re: pg_dump out of shared memory - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump out of shared memory
Date
Msg-id 1553.1087825492@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump out of shared memory  (tfo@alumni.brown.edu (Thomas F. O'Connell))
List pgsql-general
tfo@alumni.brown.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

pgsql-general by date:

Previous
From: Madison Kelly
Date:
Subject: New to the list; would this be an okay question?
Next
From: Tom Lane
Date:
Subject: Re: PGSQL service dieing...