can't run pg_dump in sh script using crontab

Поиск
Список
Период
Сортировка
От Kogotkov, Vyacheslav
Тема can't run pg_dump in sh script using crontab
Дата
Msg-id D15F32DE6D70D411814400508B4492ED55EC5C@SVRSPBEXCH01
обсуждение исходный текст
Список pgsql-general
      Dear colleagues,

      I have a sh-script which run pg_dump by hand successfully. But
I have no results when I run this script using crontab. Unfortunately, I'm
new for Postgres and even have no idea, what the matter. I can't get
any error log.
      Please, help me.
      Here is my sh-script:
#!/bin/sh

PG_BIN=/ora/pgsql/bin
BACKUP_DEST=/ora/home/FOR_POSTGRES/backup/dump

$PG_BIN/pg_dump -f $BACKUP_DEST/`date +%d%m%Y`_cspb.dmp dbname

     Thanks,
     Slava


В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: SQL function problem in 7.1?
Следующее
От: Steven Saner
Дата:
Сообщение: ODBC with Visio