From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres SSL connection without client certificates. |
Date: | 2015-07-27 13:54:32 |
Message-ID: | 55B63818.7050502@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/27/2015 12:48 AM, Amit Bondwal wrote:
> Hi Everyone.
>
> I am able to setup postgresql with TLS v1.2 with client certificate. I
> used below link to setup this and it works nicely.
> https://www.howtoforge.com/postgresql-ssl-certificates
>
> How can I connect to remote database with encrypted connection on tls
> without setting client certificates on client machine?
See here:
http://www.postgresql.org/docs/9.4/interactive/auth-pg-hba-conf.html
To use client certs you need to set cert for auth-method for a
particular connection. So to not use them and have an ssl connection set
the connection type to hostssl and set auth-method to something other
then cert.
>
> I am using linux as a clinet machine and want to connect through command
> line, without client certificate in encrypted format or on SSL. What
> should I do?
If I understand, you want to a non-ssl connection to Postgres, correct?
If so then per the docs in the above link then use host for either local
or remote TCP/IP connections or local for a socket connection.
>
> --
> Thanks & Regards,
>
> Amit Bondwal
> Contact me at +91-999-0235-948
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | papa | 2015-07-27 13:54:46 | Re: I lost my password |
Previous Message | Furlong, Shane | 2015-07-27 13:48:40 | This utility can only upgrade to PostgreSQL version 9.4 |