...
[15:49:24 CST(-0600)] <dmccallum54> on OSX i usually just connect as a super user and create the db specifying sspadmin as the owner
[15:51:16 CST(-0600)] <dmccallum54> doesnt look like our linux installs do anything special in postgres.conf other than specify a listen_address
[15:51:25 CST(-0600)] <dmccallum54> then they do this...
[15:51:33 CST(-0600)] <dmccallum54> psql -d template1 -U postgres
[15:51:45 CST(-0600)] <dmccallum54> CREATE DATABASE uportal;
[15:51:45 CST(-0600)] <dmccallum54> CREATE USER ssp WITH PASSWORD 'ssp';
[15:51:45 CST(-0600)] <dmccallum54> CREATE USER sspadmin WITH PASSWORD 'sspadmin';
[15:51:45 CST(-0600)] <dmccallum54> GRANT ALL PRIVILEGES ON DATABASE uportal to sspadmin;
[15:51:45 CST(-0600)] <dmccallum54> GRANT ALL PRIVILEGES ON DATABASE uportal to ssp;
[15:52:02 CST(-0600)] <dmccallum54> all the actual names and passwords are implementation details, of course