Re: pg_dumpall: does not exist database

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?
If so, I'm wondering if you've got a database with a carriage return
embedded in the name, or something like that.

What PG version is this?

regards, tom lane