Gerard Samuel wrote:
#!/bin/sh
#
# To back up PostgreSQL database
#
date=`date '+%Y%m%d-%H%M%S'`
pg_dump -cO -U user database > /root/db_back/pgsql-$date.sql
You probably need the full path to pg_dump.
The crontab environment doesn't have a lot of the settings you
get in a login shell.
Ceri
Thanks to James and Ceri.
Use the full path to pg_dump -> /usr/local/bin/pg_dump
Works now.
Gerard Samuel wrote:
#!/bin/sh
#
# To back up PostgreSQL database
#
date=`date '+%Y%m%d-%H%M%S'`
pg_dump -cO -U user database > /root/db_back/pgsql-$date.sql
Ceri Davies wrote:
On Fri, Jan 17, 2003
#!/bin/sh
#
# To back up PostgreSQL database
#
date=`date '+%Y%m%d-%H%M%S'`
pg_dump -cO -U user database > /root/db_back/pgsql-$date.sql
Ceri Davies wrote:
On Fri, Jan 17, 2003 at 05:35:47PM -0500, Gerard Samuel wrote:
Im trying to setup a cron job to back up my db.
If I manually execute t
On Fri, Jan 17, 2003 at 05:35:47PM -0500, Gerard Samuel wrote:
> Im trying to setup a cron job to back up my db.
> If I manually execute the script it works fine, but the cron job isn't
> executing the job.
>
> ## Backup PostgreSQL database
> */1* * * * /root/bin/pgsql
Im trying to setup a cron job to back up my db.
If I manually execute the script it works fine, but the cron job isn't
executing the job.
## Backup PostgreSQL database
*/1* * * * /root/bin/pgsql-back2>
/dev/null > /dev/null
Anyone notice anything with this c