$ 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)
1 Comment
John Imholz (musc.edu)
You're installing Postgres 12, is that just for dev? because the spec sheet says PG 9. Grouper Specsheet