can't run pg_dump in sh script using crontab

From: "Kogotkov, Vyacheslav" <Vyacheslav(dot)Kogotkov(at)artificial-life(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: can't run pg_dump in sh script using crontab
Date: 2001-02-09 18:58:13
Message-ID: D15F32DE6D70D411814400508B4492ED55EC5C@SVRSPBEXCH01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Steven Saner 2001-02-09 19:17:26 ODBC with Visio
Previous Message Stephan Szabo 2001-02-09 17:42:59 Re: SQL function problem in 7.1?