Skip site navigation (1) Skip section navigation (2)

RE: Perl and pg_dump

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 (view raw or flat)
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!"   
-----------------------------------------------------------------------------


In response to

pgsql-novice by date

Next:From: Oliver ElphickDate: 2000-07-11 10:57:23
Subject: Re: Library Error
Previous:From: Eric L. WalstadDate: 2000-07-10 23:50:57
Subject: Help with -lcrypt problem during compile...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group