pg_dump command inside shell scripts
pg_dump command inside shell scripts
От:
Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Дата:
Hi Folks!
Again I need a help from you!
I have develop a shell script (seen below) to do dump and vaccum
automatically.
Once pg_dump command prompts for password, I changed the $PGDATA/*hba.conf
file
to identify Linux user which starts the shell script to avoid password
prompt.
But now I need change the $PGDATA/*hba.conf file as it was originally
and
face the password prompt again.
In shell script programming how do I can do to answer this prompt?
I have done something like this:
#> pd_dump -d zakal < **********" > ${LOG}
PARAM="-U ${USER} -Fp -v -s -c -X use-set-session-authorization"
${DUMPCMD} ${PARAM} ${PGDB} -f ${ARQ} >> ${LOG} 2>&1
if [ $? -ne 0 ]; then
ERR_VAL=$?
echo "*** Erro no: ${ERR_VAL}" >> ${LOG}
echo "*** Comando: ${DUMPCMD} ${PARAM} ${PGDB} -f ${ARQ} >> ${LOG} 2>&1"
>> ${LOG}
cat ${LOG} | \
mail -s "`hostname`: Erro no deump DLL do banco ${PGDB}"
elielsonf@prodam.sp.gov.br
fi
ARQ=${BKHOME}/${PGDB}.data
echo "********** ascii do banco <${PGDB}> **********" >> ${LOG}
PARAM="-U ${USER} -Fp -a -v -X use-set-session-authorization"
${DUMPCMD} ${PARAM} ${PGDB} -f ${ARQ} >> ${LOG} 2>&1
if [ $? -ne 0 ]; then
ERR_VAL=$?
echo "*** Erro no: ${ERR_VAL}" >> ${LOG}
echo "*** Comando: ${DUMPCMD} ${PARAM} ${PGDB} -f ${ARQ} >> ${LOG} 2>&1"
>> ${LOG}
cat ${LOG} |\
mail -s "`hostname`: Erro no dump ASCII do banco ${PGDB}"
elielsonf@prodam.sp.gov.br
fi
ARQ=${BKHOME}/${PGDB}.tar
echo "********** tar do banco <${PGDB}> **********" >> ${LOG}
PARAM="-U ${USER} -Ft -v -X use-set-session-authorization"
${DUMPCMD} ${PARAM} ${PGDB} -f ${ARQ} >> ${LOG} 2>&1
if [ $? -ne 0 ]; then
ERR_VAL=$?
echo "*** Erro no: ${ERR_VAL}" >> ${LOG}
echo "*** Comando: ${DUMPCMD} ${PARAM} ${PGDB} -f ${ARQ} >> ${LOG} 2>&1"
>> ${LOG}
cat ${LOG} |\
mail -s "`hostname`: Erro no dump tar do banco ${PGDB}"
elielsonf@prodam.sp.gov.br
fi
###
# Parametro de vaccum
###
# -d: dbname
# -z: Calculate statistics for use by the optimizer.
# -f: Perform "full" vacuuming
# -v: verbose
###
echo "********** vacuum de <${PGDB}> **********" >> ${LOG}
PARAM="-U ${USER} -z -v -f"
${VACUUMCMD} ${PARAM} -d ${PGDB} > ${LOG} 2>&1
if [ $? -ne 0 ]; then
ERR_VAL=$?
echo "*** Erro no: ${ERR_VAL}" >> ${LOG}
echo "ERRO: vacuumdb ${VACUUMCMD} ${PARAM} -d ${PGDB} > ${LOG} 2>&1" >>
${LOG}
cat ${LOG} |\
mail -s "`hostname`: Erro no vacuum do banco ${PGDB}"
elielsonf@prodam.sp.gov.br
fi
..............................................
A Question...
Since before your sun burned hot in space
and before your race was born,
I have awaited a question.
Elielson Fontanezi
DBA Technical Support - PRODAM
Parque do Ibirapuera s/n - SP - BRAZIL
+55 11 5080 9493
Re: pg_dump command inside shell scripts
От:
"David F. Skoll" <dfs@roaringpenguin.com>
Дата:
On Tue, 8 Oct 2002, Elielson Fontanezi wrote: > to identify Linux user which starts the shell script to avoid password > prompt. There's a virtually-undocmented environment variable: PGPASSWORD PGPASSWORD="secret-password" export PGPASSWORD # Now pg_dump will not prompt for password. pg_dump -U postgres ... Make sure you only use this in a script which normal users cannot read, and on a system which hides root-process environment variables from being displayed by normal users (with ps). -- David.