Error during restore - dump taken with pg_dumpall -c option - Mailing list pgsql-hackers

From Rushabh Lathia
Subject Error during restore - dump taken with pg_dumpall -c option
Date
Msg-id CAGPqQf2T5oQRZjqy4r1fpZz6SvERCdccfUopba8KCtt8XYospw@mail.gmail.com
Whole thread Raw
Responses Re: Error during restore - dump taken with pg_dumpall -c option  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Re: Error during restore - dump taken with pg_dumpall -c option  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers

On master branch when we do pg_dumpall with -c option, I can see that
it also dumping the "DROP ROLE pg_signal_backend", which seems wrong.
Because when you restore the dump, its throwing an error
"ERROR:  cannot drop role pg_signal_backend because it is required by the database system".


dumpRoles()::pg_dumpall.c does have logic to not dump "CREATE ROLE"  if the
rolename starts with "pg_", but similar check is missing into dropRoles() function.

PFA patch, to fix the problem in the similar way its been handled into dumpRoles().

Thanks,


--
Rushabh Lathia
Attachment

pgsql-hackers by date:

Previous
From: konstantin knizhnik
Date:
Subject: Re: Academic help for Postgres
Next
From: Sameer Thakur-2
Date:
Subject: Re: Declarative partitioning