Am 26.04.11 00:17, schrieb Milos Wimmer:
On Thu, 21 Apr 2011, Pascal Gienger wrote:

We have 60552 tables now, and the WAL backup (hot backup) is still
running without any problem.

PostgreSQL 8.4.7 on Ubuntu 10.04 LTS Server with different volumes for
DB files and for DB log (WAL) files, 1G shared memory.

I have 125406 tables now, PostgreSQL 8.4.7.
SOGo works without problem with so many tables.

But I cannot backup database with pg_dump command.
It writes:

pg_dump: WARNING: out of shared memory
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
pg_dump: The command was: LOCK TABLE public.sogodrendr0013165525c_quick
IN ACCESS SHARE MODE

What's the size/value of

shared_buffers = ...

and

max_locks_per_transaction = ...

in your postgresql.conf?

--
Pascal Gienger     Jabber/XMPP/Mail: pascal.gien...@uni-konstanz.de
University of Konstanz, IT Services Department ("Rechenzentrum")
Electronic Communications and Web Services
Building V, Room V404, Phone +49 7531 88 5048, Fax +49 7531 88 3739
--
users@sogo.nu
https://inverse.ca/sogo/lists

Reply via email to