Re: vacuumdb has a fatal after database rename

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: huang <foggyglass(at)163(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: vacuumdb has a fatal after database rename
Date: 2016-09-28 17:29:37
Message-ID: 20160928172937.se6i42u5l67eanuh@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2016-09-28 20:39:48 Re: vacuumdb parallel has a deadlock detected in 9.5.4
Previous Message hubert depesz lubaczewski 2016-09-28 17:25:51 Re: vacuumdb parallel has a deadlock detected in 9.5.4