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