From: | "D(dot) Duccini" <duccini(at)backpack(dot)com> |
---|---|
To: | "WOLF, PATRICK" <patrick(dot)wolf(at)Aerojet(dot)com> |
Cc: | "'James Hall'" <James(dot)Hall(at)RadioShack(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | RE: Perl and pg_dump |
Date: | 2000-07-11 02:05:08 |
Message-ID: | Pine.GSO.4.03.10007102104230.28877-100000@ra.bpsi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
true, but with the su, you only do it once to set up the crontab
it more "oo" this way
On Mon, 10 Jul 2000, WOLF, PATRICK wrote:
> How about 'su -c scriptname postgres' called from cron where scriptname is
> the name of the script you're wanting to run and postgres is the postgres
> super user. Basically this would be like su'ing to user postgres and then
> running the script.
>
> Pat
>
> -----Original Message-----
> From: James Hall [mailto:James(dot)Hall(at)RadioShack(dot)com]
> Sent: Monday, July 10, 2000 3:55 PM
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] Perl and pg_dump
>
>
>
> This may not be the right place to post this question, but I had to start
> somewhere.
>
> I have a small perl script that is supposed to run pg_dump daily to backup
> databases.
> The script is called via the cron on a Redhat 6.1 system with PostgreSQL
> 6.5.
>
> The error that I receive when cron attempts to run the script is:
>
> Connection to database 'template1' failed.
> FATAL 1: SetUserId: user 'root' is not in 'pg_shadow'
>
> I know root isn't in pg_shadow, and I don't want it there (I _do_ know
> better than to do things as root ;)).
>
> How can I tell either Linux, PostgreSQL or the script to use another user
> (Postgres?) to run the script?
>
> A copy of the script is below.
>
> TIA-
> Jim
> --------------------------------------------
> #!/bin/sh
>
> PSQL=/usr/bin/psql
> DUMP=/usr/bin/pg_dump
> PREFIX=`date +%j`
> BACKUP_DIR=/data/pgsql/data
>
> Databases=`$PSQL -tq -d template1 -c "select datname from pg_database"`
> renice 20 $$
>
> echo Backup started ...
> for db in `echo $Databases`
> do
>
> echo "time: `date +%H%M%S` - Backup of $db in progress ..."
> $DUMP -D $db > $BACKUP_DIR/$PREFIX.$db
> echo "time: `date +%H%M%S` - Backup of $db finished ..."
> done
> echo Backup finished
> ----------------------------------------------
>
-----------------------------------------------------------------------------
david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2000-07-11 10:57:23 | Re: Library Error |
Previous Message | Eric L. Walstad | 2000-07-10 23:50:57 | Help with -lcrypt problem during compile... |