Re: [GENERAL] Remote connection to PostgreSQL - Mailing list pgsql-general

From Melvin Davidson
Subject Re: [GENERAL] Remote connection to PostgreSQL
Date
Msg-id CANu8FizrLQ19i8MbYYN8A1Mn+C82V1W-uFA77vpt+hct8oO9Bg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Remote connection to PostgreSQL  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general

On Mon, Jun 19, 2017 at 12:21 PM, Igor Korot <ikorot01@gmail.com> wrote:
Thx, David.

On Mon, Jun 19, 2017 at 12:09 PM, David G. Johnston
<david.g.johnston@gmail.com> wrote:
> On Mon, Jun 19, 2017 at 9:02 AM, Igor Korot <ikorot01@gmail.com> wrote:
>>
>>  Hi, ALL,
>> Is there some magic in order to turn on remote connection to PostgreSQL?
>>
>> There are some extra steps to turn it on for MS SQL and MySQL, so I
>> figured
>> it should be the same for Postgre.
>
>
> See "listen_addresses"
>
> https://www.postgresql.org/docs/9.6/static/runtime-config-connection.html
>
> It forward links you to setting up client authentication for the same.
>
> David J.
>


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In addition to enabling  listen_addresses, you also have to add entries in pg_hba.conf.

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: [GENERAL] Remote connection to PostgreSQL
Next
From: Dmitry O Litvintsev
Date:
Subject: Re: [GENERAL] autovacuum holds exclusive lock on table preventing itfrom to be updated