Changes

m
test 2
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
emailconfirmed, Administrators
123

edits