| From: | huang <foggyglass(at)163(dot)com> |
|---|---|
| To: | depesz(at)depesz(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-29 14:05:18 |
| Message-ID: | 82eefc1.ed30.157764383eb.Coremail.foggyglass@163.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
I am sorry .
we want to hide the database postgres for the security concern .
However I found this message in log .
I think there are some problem in vacuumdb .
But now I see this is my mistake .
Best regards,
TT
At 2016-09-29 01:29:37, "hubert depesz lubaczewski" <depesz(at)depesz(dot)com> wrote:
>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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M. Roscio | 2016-09-29 14:29:03 | Re: BUG #14346: CREATE TABLE xxx (LIKE yyy INCLUDING ALL) fails |
| Previous Message | Peter Geoghegan | 2016-09-29 13:21:31 | Re: BUG #14344: string_agg(DISTINCT ..) crash |