Hi, I was wondering if it’s possible to set up multiple users with different permissions on a postgres db hosted on aptible. If so, how do I do so and how would other services connect?
You can manage users on Aptible PostgreSQL Databases the same way you would for any PostgreSQL server. Connect to the Database, e.g. by tunneling into the Database with aptible db:tunnel and using psql to connect over the tunnel, then you can run user management commands such as CREATE USER, CREATE ROLE, GRANT, REVOKE, etc.
Any place you would normally provide the default aptible username and password to access the Database you can substitute the credentials for any other users on the database server. This includes Database Tunnels, using the Database Credentials within your Stack (i.e. in your applications), and Database Endpoints.
These principles apply to all Database Types that support multiple users.