Search Postgresql Archives

pg_dumpall: does not exist database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
.
.
.


There is that one nagging line though with no DB name:
     | kahn     | SQL_ASCII

How do I drop this no-name DB?

Thanks,
Ari


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux