"Robert Frantz" <rfrantz(at)cognitronix(dot)com> writes:
> I was able to backup this server using PGAdmin in postgresql 8.4 but now
> that I've migrated to 9.0, I get:
> pg_dump: Error message from server: ERROR: out of shared memory
> HINT: You might need to increase max_locks_per_transaction.
> I have tried increasing max_locks_per_transaction first to 1500, then 10000
> and then 50000 with no success.
That should fix it. Did you remember to restart the server after
adjusting the config file entry? ("pg_ctl reload" won't do.)
You can verify the active value with "SHOW max_locks_per_transaction".
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Jason Tan Boon Teck||Date: 2011-08-12 04:11:04|
|Subject: Alter table to add foreign key|
|Previous:||From: Robert Frantz||Date: 2011-08-11 20:26:33|
|Subject: Backup Server Error "might need to increase max_locks_per_transaction"|