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 по дате отправления:

Предыдущее
От: Inoqulath
Дата:
Сообщение: Trigger on CREATE ROLE
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: All objects of a Particular USER