Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall -r -c try to drop user postgres - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: pg_dumpall -r -c try to drop user postgres
Date
Msg-id CAMkU=1zuWOTHDZVFbmfoj2ywtOVLU7FUUz_iLzzAZ6zbknQjog@mail.gmail.com
Whole thread Raw
In response to Re: pg_dumpall -r -c try to drop user postgres  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view
On Tue, Dec 5, 2017 at 9:03 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
On Sun, Dec 3, 2017 at 3:21 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> I am not sure if user postgres should be removed, so it is probably bug
>
> pg_dumpall -r -c | grep postgres
>
> DROP ROLE postgres;
> CREATE ROLE postgres;

 
I am not sure, if issue is in this code. But I am sure, so DROP ROLE postgres is just nonsense

This command should to fail every time, and then should not be generated.

I don't see why it should fail every time.

Not all databases clusters were created with their initdb superuser being 'postgres'.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [HACKERS] postgres_fdw super user checks
Next
From: Andres Freund
Date:
Subject: pgbench's expression parsing & negative numbers