pg_dumpall: does not exist database

Поиск
Список
Период
Сортировка
От Ari Kahn
Тема pg_dumpall: does not exist database
Дата
Msg-id 14914666-CB11-4FA8-A558-2C51DA66B8E7@gmu.edu
обсуждение исходный текст
Ответы Re: pg_dumpall: does not exist database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Brendan Duddridge
Дата:
Сообщение: invalid memory alloc request size 1684370054
Следующее
От: Tom Lane
Дата:
Сообщение: Re: invalid memory alloc request size 1684370054