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" (184.108.40.206), 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.
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;
- How to clean text editor data on next.js
- Filter a foreignkey field based on logged in user in Django Admin Dashboard
- Error: Invalid `prisma.model.findMany()` invocation. Query engine library for current platform "debian-openssl-1.1.x" could not be found.
- How to access inputed values of model fields before creation in Django admin dashboard
- How to create a free CockroachDB database on CockroachLabs
Click on the button below to add a new message to this thread
Satus: OpenMessages: 1Started: 2023-05-04