Hello my friends!
I was making a pretty simple script to export our databases, and found a
strange (funny) behavior of psql (or bash?).
[EMAIL PROTECTED] psql -Atl | cut -d"|" -f1 | grep -v template
Db_1
Db_2
Db_3
Db_4
The databases name were changed due privacy reasons (our client database),
but as you can see the command worked.
Now, when I come with the bash script:
#!/bin/bash
imprime () {
echo `date +"%d/%m/%y %H:%M:%S |"` $*
}
BANCOS=`psql -Atl | cut -d"|" -f1 | grep -v template`
for BANCO in $BANCOS; do
imprime "Inicio do backup da base $BANCO"
done
[EMAIL PROTECTED] backup_psql8]$ ./backup.sh
psql: could not send startup packet: Broken pipe
Any clues????
Best Regards,
Bruno Almeida do Lago
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org