Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] Remote connection to PostgreSQL

[GENERAL] Remote connection to PostgreSQL

From
Igor Korot
Date:
 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.

Thank you.

Re: [GENERAL] Remote connection to PostgreSQL

From
"David G. Johnston"
Date:
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.

Re: [GENERAL] Remote connection to PostgreSQL

From
Igor Korot
Date:
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.
>

Re: [GENERAL] Remote connection to PostgreSQL

From
Melvin Davidson
Date:

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.