search

vexim / vexim2

Virtual Exim 2
Other
71 stars 47 forks source link

postgres 11: NOCREATEUSER unrecognized #268

Open LucidOne opened 3 years ago

LucidOne commented 3 years ago 
postgres=#     CREATE USER vexim WITH PASSWORD 'CHANGE' NOCREATEDB NOCREATEUSER;
ERROR:  unrecognized role option "nocreateuser"
LINE 1: ...EATE USER vexim WITH PASSWORD 'CHANGE' NOCREATEDB NOCREATEUS...

It looks like NOCREATEUSER has been deprecated. It is no longer supported in postgres v11.x

It should be removed or replaced with NOSUPERUSER which is the default.