Re: Security

you will want to modify your pg_hba.conf file, in the data directory, to
have a line that
requires anyone connecting from the internet to require a password. Part
of this requires a password file which can be created with pg_passwd
filename.

For example:

add a line to pg_hba.conf similar to this:
host         all         0.0.0.0   0.0.0.0       password passwd

then in the data directory run the following command:
pg_passwd passwd

you can test this change out by connecting using:
psql -h hostname -U username dbname

Hope this helps.

Chris Ryan


Luz Lopez wrote:
>
> Hi all,
>
> I have a Database and my interface is with PHP, but I hace problems,
> I can connect to a  Data Base using PHP with using login and password.  If I
> have an user with restricted privileges, how can I force this user to access
> with login and password, via WEB?
>
> I use pg_connect("host=localhost port=5432 user=wwwuser password=XXX
> dbname=YYY"); but if I use _connect("host=localhost port=5432 dbname=YYY");
> the program connect without problems a the Database, I believe that I have
> serius problme of security.
>
> I need your Help....
>
> Thanks in advanced,
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.