User:Jtraulle/DiscourseMigration

< User:Jtraulle
Revision as of 08:44, 1 August 2019 by Jtraulle (talk | contribs) (Created page with "This page gathers info about Discourse migration. <br /> == Allow PostgreSQL to be accessed from an external application == ''Useful to be able to access the databa...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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).

  1. Expose the 5432 TCP port from the container to the host by adding this line to the expose: section of containers/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;