X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D6EBA529C7 for ; Wed, 3 Aug 2005 10:27:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39310-04 for ; Wed, 3 Aug 2005 13:27:22 +0000 (GMT) Received: from amiindia.co.in (unknown [203.199.198.234]) by svr1.postgresql.org (Postfix) with ESMTP id 2B32E52824 for ; Wed, 3 Aug 2005 10:27:18 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by amiindia.co.in (8.12.10/8.12.11) with SMTP id j73D4Irk025383 for ; Wed, 3 Aug 2005 18:34:18 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTPid BAFB54FC07B; Wed, 3 Aug 2005 18:34:10 +0530 (IST) Message-ID: <012001c59830$069cd200$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: reg:permission for the remote clients Date: Wed, 3 Aug 2005 19:04:08 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_011D_01C5985E.204BE640" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:79.31545 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.064 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200508/28 X-Sequence-Number: 18347 This is a multi-part message in MIME format. ------=_NextPart_000_011D_01C5985E.204BE640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_011D_01C5985E.204BE640 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
    I need a = help.
    I have postgresql = database=20 server running in my system.
 
If i want to connect with this = database from=20 any other system's what i should do?
 
Where should i set permissions for the = other=20 '  ip's ' to connect with my database?
Please tell me what i did is correct or = not.If=20 not,suggest me where to set this permission.
 
 I have=20 set the permissions in the = pg_hba.conf file for = allowing=20 the
clients to the particular datbase and for the particular ip=20 range?
once i set, i=20 have restarted the postgres server.
The=20 following is the one i have added in pg_hba.conf=20 :

TYPE      = DATABASE    =20 USER     IP-ADDRESS    =20 IP-MASK    =20 METHOD
host          = ;  =20 all           &nbs= p;        =20 all           =20 10.3.0.76       255.255.255.0 &nb= sp;  =20 trust

How to check the permission setted for the database is = initialized=20 - whether
by restarting the server or restarting the system itself=20 ?


Thank you.....
 
Regards,
Sandhya
------=_NextPart_000_011D_01C5985E.204BE640--