Re: vacuumdb has a fatal after database rename - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: vacuumdb has a fatal after database rename
Date
Msg-id 20160928172937.se6i42u5l67eanuh@depesz.com
Whole thread Raw
In response to vacuumdb has a fatal after database rename  (huang <foggyglass@163.com>)
Responses Re: vacuumdb has a fatal after database rename  (huang <foggyglass@163.com>)
List 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 by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: vacuumdb parallel has a deadlock detected in 9.5.4
Next
From: Alvaro Herrera
Date:
Subject: Re: vacuumdb parallel has a deadlock detected in 9.5.4