On 10/9/19 11:39 AM, Timmy Siu wrote:
Dear Bob,
Thank you.?? hostssl works out of the box!?? It does not require extra
That depends on how you installed Postgres. My guess is whatever package
manager/installer you used did the setup/configuration for you. That
would be:
1) In postgresql.co
Dear Bob,
Thank you.?? hostssl works out of the box!?? It does not require extra
configuration.?? I can connect to my own pgsql server via pgadmin 4.?? I
personally feel that Postgresql v11 is much clever than Mysql v5.7 (I
haven't tried its v8).
I also have tested postgres against TCP Wrappe
Hi Timmy
You need to use CIDR form in your pg_hba.conf. So:
host all testuser 111.222.333.444/32 md5
Most likely you would probably want to ensure ssl connection if coming
over untrusted network. So, at minimum, this is better:
hostssl all testuser 111.222.333.444/32 md5
This is better s
Dear All Users,
* How do I allow an external client IP address access to my pgsql server?
According to my own experience and test, if I set the external client IP
address to, for example, 111.222.333.444 in the file
/etc/postgresql/11/main/pg_hba.conf, it will not be able to connect to
the s
