pg_dumpall in crontab doesn't work
От | Werner Modenbach |
---|---|
Тема | pg_dumpall in crontab doesn't work |
Дата | |
Msg-id | afriab$921$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: pg_dumpall in crontab doesn't work
|
Список | pgsql-admin |
I'm doing some backup action for my database using crontab. Unfortunately the following entry doesn't work and I can't figure out the problem: ----------------------------- /etc/crontab --------------------------- 05 22 * * 1-5 postgres /usr/bin/pg_dumpall -D > /disks/postgres/db.pg_dumpall ---------------------------------------------------------------------- The message I get is: ---------------------------- stderr ---------------------------------- connected to template1... /usr/bin/pg_dumpall: 0: Bad file descriptor ---------------------------------------------------------------------- The outputfile looks like: ----------------------- the output file ------------------------------ -- -- pg_dumpall (7.2) -D -- \connect template1 DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0'); CREATE USER "werner" WITH SYSID 100 CREATEDB CREATEUSER; CREATE USER "martin" WITH SYSID 101 NOCREATEDB NOCREATEUSER; CREATE USER "juergen" WITH SYSID 102 CREATEDB NOCREATEUSER; CREATE USER "www" WITH SYSID 103 NOCREATEDB NOCREATEUSER; CREATE USER "procad" WITH SYSID 99 NOCREATEDB NOCREATEUSER; DELETE FROM pg_group; ---------------------------------------------------------------------- That's all. No databases dumped. Calling pg_dumpall manually works fine. Whe is the problem? Any hints? - Werner -
В списке pgsql-admin по дате отправления: