Re: permission denied to create and drop user

2021-02-02 Thread Adrian Klaver
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

Re: permission denied to create and drop user

2021-02-02 Thread Joao Miguel Ferreira
Hi, On Tue, Feb 2, 2021 at 10:30 PM Tom Lane wrote: > Joao Miguel Ferreira writes: > > I have just installed postgresql on Debian stable (from debian apt > > archives). It seems that the postgres user does not have permissions to > > DROP/CREATE USER. I was expecting the postgres user to be a

Re: permission denied to create and drop user

2021-02-02 Thread Tom Lane
Joao Miguel Ferreira writes: > I have just installed postgresql on Debian stable (from debian apt > archives). It seems that the postgres user does not have permissions to > DROP/CREATE USER. I was expecting the postgres user to be a superuser but > something seems weird. my postgres user does not

Re: permission denied to create and drop user

2021-02-02 Thread Adrian Klaver
On 2/2/21 1:58 PM, Joao Miguel Ferreira wrote: Hello all, I have just installed postgresql on Debian stable (from debian apt archives). It seems that the postgres user does not have permissions to DROP/CREATE USER. I was expecting the postgres user to be a superuser but something seems weird.

permission denied to create and drop user

2021-02-02 Thread Joao Miguel Ferreira
Hello all, I have just installed postgresql on Debian stable (from debian apt archives). It seems that the postgres user does not have permissions to DROP/CREATE USER. I was expecting the postgres user to be a superuser but something seems weird. my postgres user does not have the usual superuser