Postgres Pro
Downloads
Home   >   mailing lists

WARNING: out of shared memory - Mailing list pgsql-general

From akp geek
Subject WARNING: out of shared memory
Date
Msg-id m2h2024a9fb1004210839g6d342e4en36c99a7fb3be885c@mail.gmail.com
Whole thread Raw
Responses Re: WARNING: out of shared memory  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
Hi All -

                I have been trying to drop 2000 tables using a script. I am getting the following error message. I have the value set for max_locks_per_transaction = 100 . Error message is as follows

WARNING:  out of shared memory
ERROR:  out of shared memory
HINT:  You might need to increase max_locks_per_transaction.

********** Error **********

ERROR: out of shared memory
SQL state: 53200
Hint: You might need to increase max_locks_per_transaction.


appreciate your help

regards

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Embedded Postgres
Next
From: A B
Date:
Subject: Re: Database viewpoint of subject - Sending e-mails from database table with Cronjob