Re: pg_dumpall: does not exist database

Ari Kahn <akahn1@gmu.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