Re: How to deny access to Postgres when connected from host/non-local

2021-04-05 Thread A. Reichstadt
Thanks, works. Sent from my iPhone > On Apr 3, 2021, at 11:02, Joe Conway wrote: > > On 4/2/21 7:06 PM, A. Reichstadt wrote: >> Hello, >> I try to deny access to all databases on my server if the user “postgres" >> tries to connect from a non-local host. Here is what I did in pg_hba.conf: >>

Re: How to deny access to Postgres when connected from host/non-local

2021-04-03 Thread Joe Conway
On 4/2/21 7:06 PM, A. Reichstadt wrote: Hello, I try to deny access to all databases on my server if the user “postgres" tries to connect from a non-local host. Here is what I did in pg_hba.conf: # TYPE  DATABASE        USER            ADDRESS                 METHOD # "local" is for Unix do

How to deny access to Postgres when connected from host/non-local

2021-04-03 Thread A. Reichstadt
Hello, I try to deny access to all databases on my server if the user “postgres" tries to connect from a non-local host. Here is what I did in pg_hba.conf: # TYPE DATABASEUSERADDRESS METHOD # "local" is for Unix domain socket connections only local all