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" (220.127.116.11), 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;
- 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.
Click on the button below to add a new message to this thread
Satus: OpenMessages: 1Started: 2023-05-04