Nic-systems: Created page with "Must create new role as user postgres: su postgres createuser newuser Then create database as new role: su newuser createdb testdb Note - here it is assumed that the..."

2020-02-04T02:06:53Z

Created page with "Must create new role as user postgres: su postgres createuser newuser Then create database as new role: su newuser createdb testdb Note - here it is assumed that the..."

New page

Must create new role as user postgres:
su postgres
createuser newuser
Then create database as new role:
su newuser
createdb testdb
Note - here it is assumed that the role will take on the same username as the OS username.

Procedure:Set up PostgreSQL database - Revision history

Nic-systems: Created page with "Must create new role as user postgres: su postgres createuser newuser Then create database as new role: su newuser createdb testdb Note - here it is assumed that the..."