X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D34D39FB2B2 for ; Mon, 31 Jul 2006 01:41:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 43694-01 for ; Mon, 31 Jul 2006 01:40:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sifyelnet.sify.net (elneti.sifycorp.com [202.144.77.54]) by postgresql.org (Postfix) with ESMTP id 02F8E9FB2BC for ; Mon, 31 Jul 2006 01:40:44 -0300 (ADT) X-QHPSI: clean Received: (sifymail 29142 invoked by uid 508); 31 Jul 2006 10:10:38 +0530 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=corporate; d=sifycorp.com; b=Bi09AgiM3dB6d1ii39U1z/3/87OP+DEKdrySJtdzb/jgI7+Qv6HarUtemQYugxxd ; Received: from ::ffff:210.210.122.77 (HELO sifydba) (dilipkumar_parikh@sifycorp.com@::ffff:210.210.122.77) by 10.1.8.60 with ESMTPA; 31 Jul 2006 10:10:38 +0530 Message-ID: <053c01c6b45b$933dead0$4d7ad2d2@sifydba> From: "Dilipkumar" To: "Aaron Bono" , "Mostafizur Rahaman Sohel" Cc: References: <20060729094501.62681.qmail@web502.biz.mail.mud.yahoo.com> Subject: Re: Scheduled backup in postgresql Date: Mon, 31 Jul 2006 10:11:23 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0539_01C6B489.ACDD95C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.037 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HOT_NASTY, HTML_MESSAGE, SPF_PASS X-Spam-Level: ** X-Archive-Number: 200607/290 X-Sequence-Number: 22536 This is a multi-part message in MIME format. ------=_NextPart_000_0539_01C6B489.ACDD95C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, BKPDIR=3D/var/postgres/dumps /usr/local/pgsql/bin/pg_dump -d genx | gzip > ${BKPFILE}.txt.gz = 2>${BKPDIR}/bkp.err Thanks & Regards Dilipkumar ----- Original Message -----=20 From: Aaron Bono=20 To: Mostafizur Rahaman Sohel=20 Cc: pgsql-admin@postgresql.org=20 Sent: Monday, July 31, 2006 10:00 AM Subject: Re: [ADMIN] Scheduled backup in postgresql On 7/29/06, Mostafizur Rahaman Sohel 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?=20 Regards, Sohel Set up a cron job to run pg_dump. See: http://www.postgresql.org/docs/8.1/interactive/backup.html=20 = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ********** DISCLAIMER ********** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail & notify us immediately at admin@sifycorp.com Watch the latest updates on Mumbai, with video coverage of news, events, Bollywood, live darshan from Siddhivinayak temple and more, only on www.mumbailive.in Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com ------=_NextPart_000_0539_01C6B489.ACDD95C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
BKPDIR=3D/var/postgres/dumps
 
/usr/local/pgsql/bin/pg_dump -d = genx | gzip=20 > ${BKPFILE}.txt.gz 2>${BKPDIR}/bkp.err
 
Thanks & Regards
Dilipkumar
----- Original Message -----
From:=20 Aaron=20 Bono
Sent: Monday, July 31, 2006 = 10:00=20 AM
Subject: Re: [ADMIN] Scheduled = backup in=20 postgresql

On 7/29/06, Mostafizur = Rahaman=20 Sohel <sohel@dreamapps.com>=20 wrote:
Hi,
Actually I was trying to create backup schedule using = postgresql=20 enterprise manager. But failed to do it. Please let me know how I = can create=20 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=20 =

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 &nb= sp;=20 Aaron Bono
   Aranya Software Technologies, = Inc.
  =20 http://www.aranya.com
=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 ------=_NextPart_000_0539_01C6B489.ACDD95C0--