Feature bug dumpall CREATE ROLE postgres - Mailing list pgsql-bugs

From Jim Wilson
Subject Feature bug dumpall CREATE ROLE postgres
Date
Msg-id CABboei8cKxParK=nGwjHp0i=5xdn9YtkUQAo=_vuGm-F8X46gw@mail.gmail.com
Whole thread Raw
Responses Re: Feature bug dumpall CREATE ROLE postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18367: Cannot drop schema
Next
From: PG Bug reporting form
Date:
Subject: BUG #18368: order by collation doesn't work as expected for the second column in the ORDER BY list