Thread: Scheduled backup in postgresql

Scheduled backup in postgresql

From

Mostafizur Rahaman Sohel

Date:

31 July 2006, 02:45:31

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

Re: Scheduled backup in postgresql

From

"Aaron Bono"

Date:

31 July 2006, 04:31:34

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
==================================================================

Re: Scheduled backup in postgresql

From

"Dilipkumar"

Date:

31 July 2006, 04:41:01

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 -----
From: Aaron Bono
To: Mostafizur Rahaman Sohel
Cc: pgsql-admin@postgresql.org
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
==================================================================