Thread: Strange behavior

Hello my friends!

I was making a pretty simple script to export our databases, and found a
strange (funny) behavior of psql (or bash?).

[psql8@xxxx]$ 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


[psql8@webix backup_psql8]$ ./backup.sh
psql: could not send startup packet: Broken pipe


Any clues????


Best Regards,
Bruno Almeida do Lago

On Fri, Jan 06, 2006 at 03:26:27PM -0200, Bruno Almeida do Lago wrote:
> #!/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
>
>
> [psql8@webix backup_psql8]$ ./backup.sh
> psql: could not send startup packet: Broken pipe

What version of PostgreSQL are you using?  What operating system
and version?  Does anything show up in the postmaster or system
logs?  How repeatable is the problem?  Does it happen with a one-line
script that executes just a simple psql command?

We've seen previous reports of "Broken pipe" that turned out to be
caused by exhausted resources -- could that be the problem?

--
Michael Fuhr