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 "" (, 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.


message profile

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;



Add Message

Click on the button below to add a new message to this thread



Thread detail

Satus: Open
Messages: 1Started: 2023-05-04
Thread Create
Click the button below to start a new thread for your question




Frontend Development |Backend Development |Full Website Development |Bootstrap Website upgrades | Website Debbugging | Website Hosting & deployment


Interested in hiring me or collaborating with me on a project, click on any of the links below to get my social media handle

Or contact me via Tel: (+234)-806-225-7480 | Email:
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.