Feature bug dumpall CREATE ROLE postgres

Поиск
Список
Период
Сортировка
От Jim Wilson
Тема Feature bug dumpall CREATE ROLE postgres
Дата
Msg-id CABboei8cKxParK=nGwjHp0i=5xdn9YtkUQAo=_vuGm-F8X46gw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Feature bug dumpall CREATE ROLE postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I understand there are workarounds, but generally the software automatically creates a postgres role during initialization. Including "CREATE ROLE postgres;" in the dumpall will cause the script to throw an error. This came to light while doing PostgreSQL upgrades. I'm finding that turning on ON_ERROR_STOP makes sense to ensure that there isn't some problem in our data or stored procedures that goes unnoticed during upgrades. The fact that a "CREATE ROLE postgres" statement is created in every dumpall means loading the script into a new server means an error is thrown and execution stops.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18367: Cannot drop schema
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18368: order by collation doesn't work as expected for the second column in the ORDER BY list