RE: Perl and pg_dump

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.Hall@RadioShack.com]
> Sent: Monday, July 10, 2000 3:55 PM
> To: pgsql-novice@postgresql.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@backpack.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!"   
-----------------------------------------------------------------------------