Re: [HACKERS] dumpall prob

> % pg_dumpall > db.out2
> Connection to database 'List' failed.
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
>
> pg_dump failed on List, exiting
>
>
> ... investigating ...

Reason:

In pg_dumpall, line 50 is:

psql -l -A -q -t| tr '|' ' ' | grep -v '^template1 ' | \

which outputs:

% psql -l -A -q -t| tr '|' ' ' | grep -v '^template1 '
List of databases
Database Owner
darwin prlw1
...
(5 rows)

so presumably, it tries to open a connection to "List" as user "of"
this implies that "-q" isn't quite as quiet as it could be...

I tried changing it to

psql -l -A -q -t| tr '|' ' ' | egrep -v '(^template1 |^List of databases|^Database Owner| rows)' | \

as a work around, but then:

\connect template1 ERROR: attribute 'prlw1' not found
create database darwin;
\connect darwin ERROR: attribute 'prlw1' not found

etc

and this is because line 56 wants to read

where usesysid = \'$DBUSERID\'; \" | \
rather than
where usesysid = $DBUSERID; \" | \

Cheers,

Patrick