What is Supabase?
The open source Firebase alternative.
Screenshots
Notes
You can find your anonymous key in the Environment Variables area under SERVICE_SUPABASEANON_KEY.
Public Port Access
::: warning NOTE: There is a bug with making database publicly accessible. This bug will be fixed soon. In the meantime, you can use the following workaround: :::
Set Supabase Db to public
Then
Go to the General tab then Edit Compose File
Then add this line
ports: - ${POSTGRES_PORT:-5432}:${POSTGRES_PORT:-5432}
To
supabase-db:
image: "supabase/postgres:15.6.1.146"
healthcheck:
test: "pg_isready -U postgres -h 127.0.0.1"
interval: 5s
timeout: 5s
retries: 10
depends_on:
supabase-vector:
condition: service_healthy
ports:
- ${POSTGRES_PORT:-5432}:${POSTGRES_PORT:-5432}
And Restart
NOTE if you are changing the port to a different port altogether to update the POSTGRES_PORT in the Environment Variables
Opening ports with ufw-docker
Finally, to allow external access to the PostgreSQL port in a Docker setup, you need to open the port in the firewall using the command:
ufw route allow proto tcp from any to any port 5432
This rule ensures traffic can reach your PostgreSQL database through the Docker network. For more information, read the docs from ufw-docker.
Using Hetzner's firewall UI
If your server is hosted on Hetzner, you may not need ufw-docker. Instead, you can open the relevant database port (e.g., 5432) directly using Hetzner's firewall UI.