Re: Scheduled backup in postgresql
От | Dilipkumar |
---|---|
Тема | Re: Scheduled backup in postgresql |
Дата | |
Msg-id | 053c01c6b45b$933dead0$4d7ad2d2@sifydba обсуждение исходный текст |
Ответ на | Scheduled backup in postgresql (Mostafizur Rahaman Sohel <sohel@dreamapps.com>) |
Список | pgsql-admin |
Hi,
BKPDIR=/var/postgres/dumps
/usr/local/pgsql/bin/pg_dump -d genx | gzip > ${BKPFILE}.txt.gz 2>${BKPDIR}/bkp.err
Thanks & Regards
Dilipkumar
Dilipkumar
----- Original Message -----From: Aaron BonoSent: Monday, July 31, 2006 10:00 AMSubject: Re: [ADMIN] Scheduled backup in postgresqlOn 7/29/06, Mostafizur Rahaman Sohel <sohel@dreamapps.com> wrote:Hi,
Actually I was trying to create backup schedule using postgresql enterprise manager. But failed to do it. Please let me know how I can create backup schedule in postgresql?
Regards,Sohel
Set up a cron job to run pg_dump. See:
http://www.postgresql.org/docs/8.1/interactive/backup.html
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
В списке pgsql-admin по дате отправления: