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 315695E47FE for ; Mon, 6 Sep 2004 03:09:55 +0100 (BST) 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 15709-08 for ; Mon, 6 Sep 2004 02:09:52 +0000 (GMT) Received: from web61003.mail.yahoo.com (web61003.mail.yahoo.com [216.155.196.92]) by svr1.postgresql.org (Postfix) with SMTP id 5DABD5E487D for ; Mon, 6 Sep 2004 03:09:49 +0100 (BST) Message-ID: <20040906020956.65180.qmail@web61003.mail.yahoo.com> Received: from [203.125.49.246] by web61003.mail.yahoo.com via HTTP; Mon, 06 Sep 2004 03:09:56 BST Date: Mon, 6 Sep 2004 03:09:56 +0100 (BST) From: =?iso-8859-1?q?Lawrence=20C?= Subject: Re: Create Linux Script for PostgreSQL database backup To: tim hall Cc: pgsql-admin@postgresql.org In-Reply-To: <200409020744.03552.tech@glastonburymusic.org.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200409/41 X-Sequence-Number: 14744 Hi Tim, How do I setup cronjob for user "postgres" then in scripts? that what i mean thanks :) --- tim hall wrote: > 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 >  backup.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 >  backup.sql > > I'm being cheeky, but surely if you set that up as a > cronjob for user > 'postgres' that would do it? Are your needs more > complex than this? > > cheers > > tim hall > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend > ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html