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