Re: vacuumdb has a fatal after database rename

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: vacuumdb has a fatal after database rename
Дата
Msg-id 20160928172937.se6i42u5l67eanuh@depesz.com
обсуждение исходный текст
Ответ на vacuumdb has a fatal after database rename  (huang <foggyglass@163.com>)
Ответы Re: vacuumdb has a fatal after database rename
Список pgsql-bugs
On Wed, Sep 28, 2016 at 09:54:41PM +0800, huang wrote:
> If I rename the database postgres  before vacuumdb , the vacuumdb say
> FATAL:  database "postgres" does not exist.

So don't rename it. It's being used because you are running vacuumdb
using postgres shell account.

You could try something like:

PGDATABASE=template1 vacuumdb -az

but generally speaking it is not advised to rename postgres db.

Best regards,

depesz

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: vacuumdb parallel has a deadlock detected in 9.5.4
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: vacuumdb parallel has a deadlock detected in 9.5.4