Create mapbender user in postgresql

From MapbenderWiki

Jump to: navigation, search

To be able to create tables and constraints the mapbender database user needs superuser privileges.

CREATE USER mapbender;
ALTER ROLE mapbender PASSWORD 'somepassword';
ALTER ROLE mapbender SUPERUSER;

After uploading the SQLs the super user privileges should be revoked again because they are not required any more.

ALTER ROLE mapbender NOSUPERUSER;
Personal tools