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