How to Give A Postgres User SuperUser Privilege Through docker-compose?

Question

This is my docker-compose file section for postgres container. These settings are fine, but my django app requires this user to have superuser privileges through this command inside postgresql.

ALTER ROLE project_admin SUPERUSER;

How can this be accomodated inside this docker-compose file?

 db:
  image: postgres:latest
  container_name: project-db
  environment:
   - POSTGRES_USER='project_admin'
   - POSTGRES_PASS='projectpass'
   - POSTGRES_DB='project'

In Docker Hub, PostgreSQL state clearly for POSTGRES_USER and I quote "This variable will create the specified user with superuser power and a database with the same name". So why do you need to alter the role of 'project_admin' to be a superuser when in the docker compose is already a superuser? — Nader Belal
– Nader Belal, Commented Aug 10, 2022 at 17:21

Mihai · Accepted Answer · 2019-05-22 05:42:40Z

7

You need to save your command as a script say ./scripts/01_users.sql:

ALTER ROLE project_admin SUPERUSER;

Then your docker-compose:

...
 db:
  image: postgres:latest
  container_name: project-db
  environment:
   - POSTGRES_USER='project_admin'
   - POSTGRES_PASS='projectpass'
   - POSTGRES_DB='project'
  volumes:
   - ./scripts/:/docker-entrypoint-initdb.d/

This will run the script at startup and alter your user's privileges.

answered May 22, 2019 at 5:42

Mihai

11k3 gold badges24 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sollosa Over a year ago

Thanks Mihai, one more thing. Do I need to turn executable bit on this script or would it run anyway?

Mihai Over a year ago

It's .sql so it runs anyway

Collectives™ on Stack Overflow

How to Give A Postgres User SuperUser Privilege Through docker-compose?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related