How do I update connection pool settings in my dashboard?
Last edited: 1/18/2025
A few questions I have about updating settings for PgBouncer or Supavisor:
- How do I know which connection pooler I'm using?
The PgBouncer connection string looks like: postgres://postgres:[YOUR-PASSWORD]@db.xxxxxxxxxx.supabase.co:6543/postgres
The Supavisor connection string looks like: postgres://postgres.xxxxxxxxx:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:6543/postgres
The subdomain will vary depending on the region a project is deployed in. The project reference is to be included in the username following a .. If the username is postgres the username you use for Supavisor is postgres.[PROJECT_REF].
- How do I update the size of the connection pool to the database?
You can set the Max Client Connections field in your database settings here:
https://supabase.com/dashboard/project/_/settings/database
- How do I change the client connection limit?
You can set the Default Pool Size field in your database settings:
https://supabase.com/dashboard/project/_/settings/database
- How do I use
sessionmode?
With Supavisor you can automatically use session mode by using the connection string with port 5432 in it.
You can also set the pooler port 6543 to use session mode in the database settings: