Create new database and user in PostgreSQL

Create new user and a database in PostgreSQL:

	$ su - postgres
	$ psql template1
	template1=# CREATE USER tester WITH PASSWORD 'test_password';
	template1=# CREATE DATABASE test_database;
	template1=# GRANT ALL PRIVILEGES ON DATABASE "test_database" to tester;
	template1=# \q

view raw postgresql_user_db_prep1.txt hosted with ❤ by GitHub

Now check that our new user has permissions to create new tables in the database.

	psql -h localhost -U tester -d test_database
	test_database=> CREATE TABLE TESTME(ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL);
	test_database=> DROP TABLE TESTME;
	test_database=> \q

view raw postgresql_user_db_prep2.txt hosted with ❤ by GitHub