What you did is correct if you want to give access to
all ip addresses in 10.3.0.*. You might also want to add your local host to this
list. You can just restart postmaster or run "pg_ctl reload" for these
permissions to take effect. You can find all this information in pg_hba.conf
file or in the postgres documentation. From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of sandhya Sent: Wednesday, August 03, 2005 8:34 AM To: postgre Cc: sandhya Subject: [ADMIN] reg:permission for the remote clients Hi,
I need a help.
I have postgresql database
server running in my system.
If i want to connect with this database from
any other system's what i should do?
Where should i set permissions for the other
' ip's ' to connect with my database?
Please tell me what i did is correct or not.If
not,suggest me where to set this permission.
I have
set the permissions in the
pg_hba.conf file for allowing
the
clients to the particular datbase and for the particular ip range? once i set, i
have restarted the postgres server.
The
following is the one i have added in pg_hba.conf
:
TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD host all all 10.3.0.76 255.255.255.0 trust How to check the permission setted for the database is initialized - whether by restarting the server or restarting the system itself ? Thank you..... Regards,
Sandhya
|