How do I setup cronjob for user "postgres" then in
scripts? that what i mean
--- tim hall <tech(at)glastonburymusic(dot)org(dot)uk> 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
> > too sure about it. Can anyone contribute the
> > 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?
> tim hall
> ---------------------------(end of
> TIP 8: explain analyze is your friend
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
In response to
pgsql-admin by date
|Next:||From: Geoffrey||Date: 2004-09-06 02:22:25|
|Subject: Re: Create Linux Script for PostgreSQL database backup|
|Previous:||From: Tony Reina||Date: 2004-09-05 11:23:01|
|Subject: Re: Selecting HW RAID controller|