X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9E09D5E4719 for ; Thu, 2 Sep 2004 03:44:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15387-06 for ; Thu, 2 Sep 2004 06:44:06 +0000 (GMT) Received: from raq550.glastonbury.co.uk (unknown [213.232.90.61]) by svr1.postgresql.org (Postfix) with ESMTP id 751405E3632 for ; Thu, 2 Sep 2004 03:44:04 -0300 (ADT) Received: from xingta.tim.gigl (adsl.phonecoop.coop.38.24.55.213 [213.55.24.38] (may be forged)) by virtualglastonbury.org.uk (8.11.6/8.11.6) with ESMTP id i826A7B11929; Thu, 2 Sep 2004 07:10:07 +0100 From: tim hall Organization: Glastonbury Music To: Lawrence C Subject: Re: Create Linux Script for PostgreSQL database backup Date: Thu, 2 Sep 2004 07:44:03 +0100 User-Agent: KMail/1.6.2 References: <20040901132055.17178.qmail@web61008.mail.yahoo.com> In-Reply-To: <20040901132055.17178.qmail@web61008.mail.yahoo.com> Cc: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <200409020744.03552.tech@glastonburymusic.org.uk> X-GlastonburyOnline-MailScanner-Information: Please contact mail_trial@glastonbury.co.uk for more information X-GlastonburyOnline-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/21 X-Sequence-Number: 14724 Lawrence C, On Wednesday 01 September 2004 14:20, you went: > Anyone good in writing Linux scripting for backup > PostgreSQL. I just required a simple scripts only. > > Normally we do the manual ways as following: > > In root > > root# su - postgres > bash# pgdumpall > =A0backup.sql > bash# exit > root# > > I'm planning to write script.sh for cronjob but not > too sure about it. Can anyone contribute the scripts > for me? Er ... #! /usr/bin/bash pgdumpall > =A0backup.sql I'm being cheeky, but surely if you set that up as a cronjob for user=20 'postgres' that would do it? Are your needs more complex than this? cheers tim hall