Is there a way to backup a PostgreSQL database with a huge number of tables?
An attempt with
pg_dump for a database of about 28000 tables resulted in the following error message:
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.link10292 IN ACCESS SHARE MODE pg_dump: *** aborted because of error
An increase of
max_locks_per_transaction to 256 instead of 64 resulted in a failure to start the server.
Anything else I can try? (PostgreSQL 9.0, Mac OS X.)