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
- Filter a foreignkey field based on logged in user in Django Admin Dashboard
- How to deploy a django project with staticfiles on vercel
- How to access inputed values of model fields before creation in Django admin dashboard
- Hosting PostgreSQL database on Supabase for free
- Error: Invalid `prisma.model.findMany()` invocation. Query engine library for current platform "debian-openssl-1.1.x" could not be found.
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-04loading..
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.