PostgreSQL connection error root certificate does not exist
I get the following error when I try to connect to my online PostgreSql database that is hosted on CockroachDB.
connection to server at "paper-marcus-0093.7tc.cockroachlabs.cloud" (52.29.118.143), port 26257 failed: root certificate file "C:\Users\Jamie\AppData\Roaming/postgresql/root.crt" does not exist
Either provide the file or change sslmode to disable server certificate verification.
Admin
2023-05-04
To fix this error all you have to do is change the ssl from verify-full to require in your connection string. An example is shown below;
postgresql://firelord_mklod_:xxxxxxxxxx@castle-herder-7233.7tc.cockroachlabs.cloud:26257/defaultdb?sslmode=require
Similar Content
- How to deploy a django project with staticfiles on vercel
- Hosting PostgreSQL database on Supabase for free
- Populating PostgreSQL database with data from a psql file
- How to access inputed values of model fields before creation in Django admin dashboard
- Filter a foreignkey field based on logged in user in Django Admin Dashboard
Add Message
Click on the button below to add a new message to this thread
Tags
#database
Thread detail
Satus: Open
Messages: 1Started: 2023-05-04Thread Create
Click the button below to start a new thread for your question
loading..
Privacy Policy
By using our website,
you agree that devmaesters can store cookies on your device and disclose information in accordance with our privacy policy.