Re: How to allow non-local to postgreSQL - Mailing list pgsql-general

From Florian G. Pflug
Subject Re: How to allow non-local to postgreSQL
Date
Msg-id 4460E30C.4030105@phlo.org
Whole thread Raw
In response to How to allow non-local to postgreSQL  (leo camalig <leo_camalig@yahoo.com>)
List pgsql-general
leo camalig wrote:
> Good Day....
>
>
> I Just want to ask on how to allow a non-local in PostgreSQL
> without adding it in
> pg-hba.conf
You don't. pg_hba.conf is the place where you can specify who
can connect from where to which database using what authentication
method. Your only alternative to using pg_hba.conf would be
to allow access from anywhere in pg_hba.conf, and use the firewalling
capabilieties of your OS to restrict access.

> I just want to view a desktop application on Web, yes it works, but you
> need to allow those I.P. addresses that will gonna connect to
> postgreSQL. What I want is everyone in the net can access the said
> desktop application. Can you help me on how to configure it.
You can add whole subnets to pg_hba.conf - that's the reason why
there is a "host" and a "netmask" field ;-)
To e.g. allow anyone from the ip-range 192.168.0.0-192.168.0.255,
you'd use a line containing "192.168.0.0 255.255.255.0".
To allow connections from anywhere, use "0.0.0.0 0.0.0.0".

greetings, Florian Pflug

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [PERFORM] Arguments Pro/Contra Software Raid
Next
From: Wayne Conrad
Date:
Subject: Re: A better AND query?