Cron'd dumpall failing?
От | Kenneth Downs |
---|---|
Тема | Cron'd dumpall failing? |
Дата | |
Msg-id | 4614DEDC.3020205@secdat.com обсуждение исходный текст |
Ответы |
Re: Cron'd dumpall failing?
|
Список | 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 = 9223372036854775807THEN 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 = -9223372036854775807THEN 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
В списке pgsql-general по дате отправления: