X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id F279B9FB1D5 for ; Tue, 19 Sep 2006 08:30:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 50201-01 for ; Tue, 19 Sep 2006 08:30:28 -0300 (ADT) X-Greylist: delayed 00:18:48.244 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 140359FB21B for ; Tue, 19 Sep 2006 08:30:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smx2-izb.izb.net (smx2-izb.izb.net [212.34.66.102]) by svr4.postgresql.org (Postfix) with SMTP id 4DC345AF8B1 for ; Tue, 19 Sep 2006 11:11:37 +0000 (GMT) Received: from m0000s0b.co.ins.izb.de (unknown [172.20.166.33]) by smx2-izb.izb.net (Postfix) with ESMTP id 6246E2417E9; Tue, 19 Sep 2006 13:11:27 +0200 (CEST) Received: by M0000S0B with Internet Mail Service (5.5.2653.19) id ; Tue, 19 Sep 2006 13:11:27 +0200 Message-ID: <11EC9A592C31034C88965C87AF18C2A70CFC50@m0000s61> From: Matthias.Pitzl@izb.de To: Josef.Springer@joops.com Cc: pgsql-admin@postgresql.org Subject: Re: Where is the msi-setup described ? Date: Tue, 19 Sep 2006 13:09:41 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6DBDC.1A99696C" X-IZB-OE30173-MailScanner-Information: Please contact IZB/OE30173/+49 89 94511 8833 for more information X-IZB-OE30173-MailScanner: Found to be clean X-IZB-OE30173-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (score=-0.763, required 3, ALL_TRUSTED -1.44, HTML_MESSAGE 0.00, HTML_TAG_EXIST_TBODY 0.13, NO_REAL_NAME 0.55) X-MailScanner-From: matthias.pitzl@izb.de X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.962 tagged_above=0 required=5 tests=HTML_MESSAGE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200609/199 X-Sequence-Number: 23113 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C6DBDC.1A99696C Content-Type: text/plain Hi Josef! You need a line looking like this one: host all all 0.0.0.0 0.0.0.0 md5 This would enable every client to connect to all databases on the server with using MD5 hashed passwords. The two lines posted by you are just rules for localhost. One is for IPv4, the other for IPv6. Further explanations can be found at http://www.postgresql.org/docs/8.1/interactive/client-authentication.html Greetings, Matthias -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Josef Springer Sent: Tuesday, September 19, 2006 1:00 PM To: Magnus Hagander Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Where is the msi-setup described ? Hi Magnus, i must explain my users how to maintain. The menu opens the dialog pgAdminIII - Backend Access Configuration Editor with 6 colomns: Type Database User IP-Address Method Option host all all 127.0.0.1/32 md5 host all all ::1/128 md5 Is all required option set ? If no, what is required to access from any client ? Josef ------_=_NextPart_001_01C6DBDC.1A99696C Content-Type: text/html Content-Transfer-Encoding: quoted-printable Nachricht
Hi=20 Josef!
 
You=20 need a line looking like this one:
 
host       = ;    =20 all           =20 all           =20 0.0.0.0        = 0.0.0.0   =20 md5
 
This=20 would enable every client to connect to all databases on the server = with using=20 MD5 hashed passwords.
The=20 two lines posted by you are just rules for localhost. One is for IPv4, = the other=20 for IPv6.
Further explanations can be found at http://www.postgresql.org/docs/8.1/interactive/client-authent= ication.html
 
Greetings,
Matthias
-----Original Message-----
From:=20 pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org]=20 On Behalf Of Josef Springer
Sent: Tuesday, September = 19, 2006=20 1:00 PM
To: Magnus Hagander
Cc:=20 pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Where is = the=20 msi-setup described ?

Hi Magnus,

i must = explain my=20 users how to maintain.
The menu opens the dialog pgAdminIII - = Backend=20 Access Configuration Editor with 6 colomns:
Type 
 Database 
 User
 IP-Address
 Method
 Option
host
 all
 all
 127.0.0.1/32
 md5
host
 all
 all
 ::1/128
 md5

Is all = required option set ?=20 If no, what is required to access from any client ?
  =20           =20
Josef      =20

------_=_NextPart_001_01C6DBDC.1A99696C--