vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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@postgresql.org [mailto Sent: Wednesday, August 03, 2005 8:34 AM To: postgre Cc: sandhya Subject: [ADMIN] reg 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 |
| Thread Tools | |
| Display Modes | |
|
|