Hey folks-first post here-and stoked you are all here in town!
I'm trying to use dblink_connect to access a client's remote DB
SELECT dblink_connect('myconn', 'host=server.client.com port=5432
dbname=clientdb user=me password=password requiressl=1')
I get the following error:
********** Error **********
ERROR: could not establish connection
SQL state: 08001
Detail: FATAL: connection requires a valid client certificate
The three certificate files are all in the default location (~/.postgresql/)
and I can successfully connect in pgAdmin using the same parameters...
I tried hardcoding the certs (sslcert=~/.postgresql/postgresql.crt
this produced the same error.
I should note that this is just a local test case for a remote connection,
as the applications will need to connect in this way...
Anyone have any guidance here?
Business Systems Developer/Analyst*
Clean Energy Works* *Oregon*
3934 NE Martin Luther King Jr. Blvd, Suite 204
Portland, Oregon 97212
desk (+1 503 446 1091)
pdxpug by date
|Next:||From: Dave Kerr||Date: 2011-06-06 22:38:19|
|Subject: Looking for a Jr. PostgreSQL DBA in Portland, Oregon|
|Previous:||From: Melissa Hollingsworth||Date: 2011-06-01 23:29:22|
|Subject: Re: May 19th meeting|