Postgres
Connecting Postgres
Follow these steps to sync an existing Postgres table
Creating your connection URI
-
Gather the following details for a user on your Postgres database:
- username (often
postgres
) - password
- host
- port
- database
- schema
- table name
- username (often
If you are starting with a full connection URI string, it should follow the format below:
Postgres Connection URI
postgresql://[user[:password]@][host][:port][,...][/database][?param1=value1&...]
- Enter the details above to the web app at app.usebracket.com
OPTIONAL: Creating a read only user on your database
Perform this step if you would like to give Bracket access through a dedicated account. Skip this step if you prefer to use an existing Postgres account during setup.
- Create a new user and password
Postgres User Creation
CREATE USER bracket WITH PASSWORD 'any_safe_password';
- Allow this new user to connect to the database
Postgres Connection Access
GRANT CONNECT ON DATABASE database_name TO bracket;
- Allow Usage on the schema (typically ‘public’)
Postgres Connection Access
GRANT USAGE ON SCHEMA schema_name TO bracket;
- Allow read access on a specific table
Postgres Connection Access
GRANT SELECT ON table_name TO bracket;