On Apr 25, 2006, at 3:25 AM, Tom Lane wrote:
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?
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
