Re: permission denied to create and drop user

On 2/2/21 2:43 PM, Joao Miguel Ferreira wrote:
> Hi,
> 
> 

> But... my dump file contains some agressive commands that are actually 
> making a reall mess. here they are:
> 
> CREATE ROLE pgcon;
> ALTER ROLE pgcon WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN 
> NOREPLICATION NOBYPASSRLS;
> CREATE ROLE postgres;
> ALTER ROLE postgres WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB 
> LOGIN NOREPLICATION NOBYPASSRLS;
> 
> that is why I messed up my database. Lucky it is not critical at all. I 
> can start all over again, no problem.
> 
> maybe "pg_dumpall" has options to avoid those changes?
> 

That would be attributing AI abilities to pg_dumpall that it does not 
have. Those commands got there from someone in the original database 
tinkering with grants.


-- 
Adrian Klaver
adrian.klaver@aklaver.com