backup of postgres scheduled with cron
От | Sorin N. Ciolofan |
---|---|
Тема | backup of postgres scheduled with cron |
Дата | |
Msg-id | 20071122131908.F1D0F8E40FC@mailhost.ics.forth.gr обсуждение исходный текст |
Ответ на | Re: EAV or not to EAV? (Oleg Bartunov <oleg@sai.msu.su>) |
Ответы |
Re: [ADMIN] backup of postgres scheduled with cron
Re: backup of postgres scheduled with cron Re: backup of postgres scheduled with cron |
Список | pgsql-general |
Hello all! I've a small bash script backup.sh for creating dumps on my Postgre db: #!/bin/bash time=`date '+%d'-'%m'-'%y'` cd /home/swkm/services/test pg_dump mydb > mydb_dump_$time.out I've edited crontab and added a line: 00 4 * * * swkm /home/swkm/services/test/backup.sh to execute the backup.sh as user swkm daily at 4 am. The user swkm is the user I use to create backups manually. The script itself is executed fine if run manually but run on cron scheduler I got an mydb_dump_$time.out file empty (of 0 kb) Do you have any idea about what's wrong? Thanks Sorin
В списке pgsql-general по дате отправления: