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@xxxxxxxxxxx
