Re: pg_dumpall: does not exist database

On Apr 25, 2006, at 3:25 AM, Tom Lane wrote:

> Ari Kahn <akahn1(at)gmu(dot)edu> writes:
>> I was trying to dump all my databases:
>> su - postgres
>> /usr/local/bin/pg_dumpall > /Volumes/Space/postgresql_060425.dump
>
>> I get:
>> " does not exist database "foodmartto database "foodmart
>> ", exiting: pg_dump failed on database "foodmart
>
>> I guess I had a database called foodmart at one time. However, it
>> doesn't show up in the DB list:
>> postgres=# \l
>> List of databases
>> Name | Owner | Encoding
>> ---------------+----------+-----------
>> barry | barry | SQL_ASCII
>> | kahn | SQL_ASCII
>> .
>
> Are you trying to accurately reproduce the formatting of what you see?
Yes

> If so, I'm wondering if you've got a database with a carriage return
> embedded in the name, or something like that.
That was a good idea. But this is not the case.
postgres=# drop database "\n";
ERROR: database "\n" does not exist
postgres=# drop database "\r";
ERROR: database "\r" does not exist

I think the issue is something like this though.

>
> What PG version is this?
8.1

Ari