Difficulty accessing remote Postgres DB from Wrangler

I’m trying to connect to a remote PG DB but it won’t connect. My means of connection is via host, user, pass etc., not Hyperdrive or anything like that. The creds are definitely correct as I can connect to the DB via a local client outside Wrangler.

When running Wrangler locally I get:

kj/compat/http.c++:6978: error: Error in HttpClientAdapter connect(); kj::cp(ex) = kj/compat/tls.c++:221: failed: TLS peer's certificate is not trusted; reason = self signed certificate

When running with --remote I get:

proxy request failed, cannot connect to the specified address

Could anyone please advise? Thank you.