$ docker run --name postgres -e POSTGRES_PASSWORD=pass -d -p 5432:5432 postgres:14
$ docker exec -it -u postgres postgres psql
# CREATE USER grouper PASSWORD 'pass';
# CREATE DATABASE grouper;
# GRANT ALL PRIVILEGES ON DATABASE grouper TO grouper;
# (NOTE, DONT DO THIS ON A SHARED DATABASE):  ALTER SCHEMA public OWNER TO grouper;
# GRANT USAGE ON SCHEMA public TO grouper;
# GRANT ALL ON SCHEMA public TO grouper;
# GRANT CREATE ON SCHEMA public TO grouper;
# alter database grouper_v5 owner to grouper_v5; 
# \q

Get your IP address

$ ifconfig

Database url: jdbc:postgresql://a.b.c.d:5432/grouper    (sub in ip address)

  • No labels

1 Comment

  1. John Imholz (musc.edu)

    You're installing Postgres 12, is that just for dev? because the spec sheet says PG 9.  Grouper Specsheet