CREATE USER connectedhome WITH PASSWORD 'connectedhome' CREATEDB;
CREATE DATABASE connectedhome
    WITH
    OWNER = connectedhome
    ENCODING = 'UTF8'
    LC_COLLATE = 'en_US.utf8'
    LC_CTYPE = 'en_US.utf8'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1;