pg_dumpall: does not exist database

From: Ari Kahn <akahn1(at)gmu(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dumpall: does not exist database
Date: 2006-04-25 07:13:27
Message-ID: 14914666-CB11-4FA8-A558-2C51DA66B8E7@gmu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-25 07:15:23 Re: invalid memory alloc request size 1684370054
Previous Message Wes 2006-04-25 06:52:31 Re: [GENERAL] Concurrency problem building indexes