Line 339:
Line 339:
}
}
</syntaxhighlight><br />
</syntaxhighlight><br />
−
==Allow PostgreSQL to be accessed from an external application==
+
==''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).''
''Useful to be able to access the database from a graphical client (like pgAdmin 4, TablePlus or Postico for example).''
Line 348:
Line 348:
./launcher rebuild app
./launcher rebuild app
3. Enter into the container, login as the default postgresql user, add a new user and grant it all perms to the database
3. Enter into the container, login as the default postgresql user, add a new user and grant it all perms to the database
+
+
test ajout de ligne
./launcher enter app
./launcher enter app
sudo -u postgres psql discourse
sudo -u postgres psql discourse
Line 354:
Line 356:
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO my_username;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO my_username;
\q
\q
+
+
+
'''test liste'''
+
+
# numéro 1
+
# numéro 10
+
# numéro 11