BUG #18609: Repeated installcheck failure in test_pg_dump due to existing role

PG Bug reporting form <noreply@postgresql.org>

From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: n.kalinin@postgrespro.ru
Date: 2024-09-11T06:42:48Z
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18609
Logged by:          Nikita Kalinin
Email address:      n.kalinin@postgrespro.ru
PostgreSQL version: 16.4
Operating system:   ubuntu 22.04
Description:        

Hello! 
When running the installcheck a second time, the test_pg_dump fails due to
the following reason:
CREATE ROLE regress_dump_test_role;
+ERROR:  role "regress_dump_test_role" already exists  
CREATE EXTENSION test_pg_dump;  

This issue is present from REL_12_STABLE to REL_16_STABLE. Maybe it's worth
adding DROP ROLE regress_dump_test_role at the end of the test, like in
REL_17_STABLE?

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Drop global objects after completed test