Re: pg_dumpall -r -c try to drop user postgres

On Tue, Dec 5, 2017 at 9:03 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

> On Sun, Dec 3, 2017 at 3:21 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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