From: | Adam Roberts <adam(at)cleanenergyworksoregon(dot)org> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Dblink ssl cert issue |
Date: | 2011-06-03 17:13:26 |
Message-ID: | BANLkTi=SgJnF=m7cF3iNGF+FnbyTLpnrBg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
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
when using:
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
sslkey=~/.postgresql/postgresql.key sslrootcert=~/.postgresql/root.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?
Much appreciated,
Adam
--
*Adam Roberts*
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)
adam(at)cleanenergyworksoregon(dot)org
www.cleanenergyworksoregon.org
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Kerr | 2011-06-06 22:38:19 | Looking for a Jr. PostgreSQL DBA in Portland, Oregon |
Previous Message | Melissa Hollingsworth | 2011-06-01 23:29:22 | Re: May 19th meeting |