Self hosted Deployments and PGadmin Connections #18
-
According to the docs here, you need to access the direct connection info via the settings->database menu. However on my self hosted deployment I have no option for settings. Any ideas? Should I reconfigure the docker compose file for this connectivity? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
You can open port 5432 by setting the variable I would also suggest to set a range of IPs to restrict access to the database for security reasons. The documentation you reference is mostly for the managed service offered by Supabase rather than the self-hosted option. So you won't see a Settings option. |
Beta Was this translation helpful? Give feedback.
@rdmorris
You can open port 5432 by setting the variable
enable_db_con
totrue
. This will allow you to connect to the database using the password obtained by running the commandterraform output psql_pass
within the terraform directory.I would also suggest to set a range of IPs to restrict access to the database for security reasons.
The documentation you reference is mostly for the managed service offered by Supabase rather than the self-hosted option. So you won't see a Settings option.