From: | Kenneth Downs <ken(at)secdat(dot)com> |
---|---|
To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Cron'd dumpall failing? |
Date: | 2007-04-05 11:34:52 |
Message-ID: | 4614DEDC.3020205@secdat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I truly hoping I'm missing something silly here. I've got a cron job to
run a dumpall each early am. It fails, and I get a handful of emails.
The first reads like this:
pg_dump: [archiver (db)] connection to database "adocs" failed: FATAL: sorry, too many clients already
pg_dumpall: pg_dump failed on database "adocs", exiting
...and then as we go along we get this one repeating for each database:
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 may need to increase max_locks_per_transaction.
pg_dump: The command was: SELECT sequence_name, last_value, increment_by, CASE WHEN increment_by > 0 AND max_value = 9223372036854775807 THEN NULL WHEN increment_by < 0 AND max_value = -1 THEN NULL ELSE max_value END AS max_value, CASE WHEN increment_by > 0 AND min_value = 1 THEN NULL WHEN increment_by < 0 AND min_value = -9223372036854775807 THEN NULL ELSE min_value END AS min_value, cache_value, is_cycled, is_called from tabproj_skey
pg_dumpall: pg_dump failed on database "XXXXX", exiting
The cron entry (for user root) is
* 1 * * * /root/dumpall.sh > /dev/null
and the routine in question is this:
pg_dumpall -U postgres > /home/bups/bsource/pg/dhost2.dumpall
chown bups:root /home/bups/bsource/pg/dhost2.dumpall
chmod 600 /home/bups/bsource/pg/dhost2.dumpall
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-04-05 11:57:34 | Re: All objects of a Particular USER |
Previous Message | Inoqulath | 2007-04-05 11:14:29 | Trigger on CREATE ROLE |