Remote connection to PostgreSQL
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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.
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
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"
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.