$ 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 CREATE ON SCHEMA public TO grouper; # \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. You're installing Postgres 12, is that just for dev? because the spec sheet says PG 9.  Grouper Specsheet