Обсуждение: reg:permission for the remote clients

Поиск

Список

Период

Сортировка

reg:permission for the remote clients

От

"sandhya"

Дата:

03 августа 2005 г., 13:27:33

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

Re: reg:permission for the remote clients

От

"Chandra Sekhar Surapaneni"

Дата:

03 августа 2005 г., 21:24:54

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:pgsql-admin-owner@postgresql.org] 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,