Postgres Pro
Downloads
Home   >   mailing lists

Re: Scheduled backup in postgresql - Mailing list pgsql-admin

From Dilipkumar
Subject Re: Scheduled backup in postgresql
Date
Msg-id 053c01c6b45b$933dead0$4d7ad2d2@sifydba
Whole thread Raw
In response to Scheduled backup in postgresql  (Mostafizur Rahaman Sohel <sohel@dreamapps.com>)
List pgsql-admin
Tree view
Hi,
 
BKPDIR=/var/postgres/dumps
 
/usr/local/pgsql/bin/pg_dump -d genx | gzip > ${BKPFILE}.txt.gz 2>${BKPDIR}/bkp.err
 
Thanks & Regards
Dilipkumar
----- Original Message -----
Sent: Monday, July 31, 2006 10:00 AM
Subject: Re: [ADMIN] Scheduled backup in postgresql

On 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 by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: Scheduled backup in postgresql
Next
From: "Aaron Bono"
Date:
Subject: Controlling CPU Usage in PostgreSQL