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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: pg_dumpall -r -c try to drop user postgres
Дата
Msg-id CAMkU=1zuWOTHDZVFbmfoj2ywtOVLU7FUUz_iLzzAZ6zbknQjog@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dumpall -r -c try to drop user postgres  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [HACKERS] postgres_fdw super user checks
Следующее
От: Andres Freund
Дата:
Сообщение: pgbench's expression parsing & negative numbers