Re: Remote connection to PostgreSQL

On Mon, Jun 19, 2017 at 12:21 PM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> Thx, David.
>
> On Mon, Jun 19, 2017 at 12:09 PM, David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> > On Mon, Jun 19, 2017 at 9:02 AM, Igor Korot <ikorot01(at)gmail(dot)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(at)postgresql(dot)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.