pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
reg:permission for the remote clients
2+ messages / 2 participants
[nested] [flat]

* reg:permission for the remote clients
@ 2005-08-03 13:34  sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 2+ messages in thread

From: sandhya @ 2005-08-03 13:34 UTC (permalink / raw)
  To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: reg:permission for the remote clients
@ 2005-08-03 21:24  Chandra Sekhar Surapaneni <chandu@positivenetworks.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Chandra Sekhar Surapaneni @ 2005-08-03 21:24 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; pgsql-admin

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,
    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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-08-03 21:24 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-03 13:34 reg:permission for the remote clients sandhya <sandhyar@amiindia.co.in>
2005-08-03 21:24 Re: reg:permission for the remote clients Chandra Sekhar Surapaneni <chandu@positivenetworks.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox