4 Use the following to set up a local PostgreSQL.
8 CREATE USER mygpo WITH PASSWORD 'mygpo';
9 ALTER USER mygpo CREATEDB; -- required for creating test database
10 CREATE DATABASE mygpo;
11 CREATE DATABASE test_mygpo;
12 GRANT ALL PRIVILEGES ON DATABASE mygpo to mygpo;
13 GRANT ALL PRIVILEGES ON DATABASE test_mygpo to mygpo;
14 ALTER DATABASE mygpo OWNER TO mygpo;
15 ALTER DATABASE test_mygpo OWNER TO mygpo;
16 ALTER ROLE mygpo SET statement_timeout = 5000;