User:Jtraulle/DiscourseMigration
This page gathers info about Discourse migration.
Allow PostgreSQL to be accessed from an external application
Useful to be able to access the database from a graphical client (like pgAdmin 4, TablePlus or Postico for example).
- Expose the 5432 TCP port from the container to the host by adding this line to the
expose:
section ofcontainers/app.yml
:
- "5432:5432"
CREATE USER my_username WITH PASSWORD 'my_password'; GRANT ALL PRIVILEGES ON DATABASE "discourse" to my_username; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO my_username;