Expresso Livre Comunidade

CREATE ROLE sa_master LOGIN
  ENCRYPTED PASSWORD '<md5password-here>'
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

CREATE DATABASE expresso_master
  WITH OWNER = sa_master
       ENCODING = 'LATIN1'
       TABLESPACE = pg_default
       LC_COLLATE = 'pt_BR.iso88591'
       LC_CTYPE = 'pt_BR.iso88591'
       CONNECTION LIMIT = -1;

ALTER DATABASE expresso_master
  SET bytea_output = 'escape';

CREATE SEQUENCE nextid_seq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 500000
  CACHE 1;

ALTER TABLE nextid_seq
  OWNER TO sa_nextid;