X-Original-To: pgsql-admin-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 813ED9FA2EC
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 19 Sep 2006 08:02:53 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 57997-09 for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 19 Sep 2006 11:02:36 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from vserver0202.onit4u.de (ns.redaex.de [213.133.112.5])
	by postgresql.org (Postfix) with ESMTP id 63EC79FA2A0
	for <pgsql-admin@postgresql.org>; Tue, 19 Sep 2006 08:02:34 -0300 (ADT)
Received: from joops.com (dslb-084-057-002-250.pools.arcor-ip.net
	[84.57.2.250])
	by vserver0202.onit4u.de (8.11.6/8.11.6/SuSE Linux 0.5) with ESMTP id
	k8JB2Qn08758; Tue, 19 Sep 2006 13:02:27 +0200
Message-ID: <450FCDBF.3070100@joops.com>
Date: Tue, 19 Sep 2006 13:00:15 +0200
From: Josef Springer <Josef.Springer@joops.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:0.9.4) Gecko/20011128 Netscape6/6.2.1
X-Accept-Language: en-us, de-de
MIME-Version: 1.0
To: Magnus Hagander <mha@sollentuna.net>
CC: pgsql-admin@postgresql.org
Subject: Re: Where is the msi-setup described ?
References: <450FAE7A.9070408@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C6@algol.sollentuna.se>
	<450FC3E0.2030001@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C7@algol.sollentuna.se>
Content-Type: multipart/alternative;
	boundary="------------060900020108020105050405"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.27 tagged_above=0 required=5 tests=FORGED_RCVD_HELO,
	HTML_50_60, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200609/197
X-Sequence-Number: 23111


--------------060900020108020105050405
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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      

Magnus Hagander wrote:

>Edit postgresql.conf and set a listen_addresses that's not just
>localhost. Then edit pg_hba.conf and add permissions based on the soruce
>address of the connection. There are sections in the manual that will
>explain the details of what you have to put there.
>
>//Magnus
>
>>-----Original Message-----
>>From: Josef Springer [mailto:Josef.Springer@joops.com]
>>Sent: Tuesday, September 19, 2006 12:18 PM
>>To: Magnus Hagander
>>Cc: pgsql-admin@postgresql.org
>>Subject: Re: [ADMIN] Where is the msi-setup described ?
>>
>>Hi Magnus,
>>
>>thanks for quick answer. I have installed PostgreSQL 8.1 on the
>>server without the option Accept connections on all addreses, not
>>just localhost . I want to connect from a client. How can this
>>option be switched on without a new installation of the server ?
>>
>>Josef
>>
>>Magnus Hagander wrote:
>>
>>
>>		Hi folks,
>>
>>
>>		where do i get documentation about the msi-setup
>>dialogs for
>>		Windows plaforms  ?
>>
>>
>>	http://pginstaller.projects.postgresql.org
>>
>>	//Magnus
>>
>>
>>	---------------------------(end of broadcast)----------------
>>-----------
>>	TIP 9: In versions below 8.0, the planner will ignore your
>>desire to
>>	       choose an index scan if your joining column's
>>datatypes do not
>>	       match
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>

--------------060900020108020105050405
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<html>
<head>
</head>
<body>
Hi Magnus,<br>
<br>
i must explain my users how to maintain.<br>
The menu opens the dialog <i>pgAdminIII - Backend Access Configuration Editor</i>
 with 6 colomns:<br>
<table cellpadding="2" cellspacing="2" border="1" width="100%">
  <tbody>
    <tr>
      <td valign="Top"><b>Type&nbsp;</b><br>
      </td>
      <td valign="Top"><b>Database&nbsp;</b><br>
      </td>
      <td valign="Top"><b>User</b><br>
      </td>
      <td valign="Top"><b>IP-Address</b><br>
      </td>
      <td valign="Top"><b>Method</b><br>
      </td>
      <td valign="Top"><b>Option</b><br>
      </td>
    </tr>
    <tr>
      <td valign="Top">host<br>
      </td>
      <td valign="Top">all<br>
      </td>
      <td valign="Top">all<br>
      </td>
      <td valign="Top">127.0.0.1/32<br>
      </td>
      <td valign="Top">md5<br>
      </td>
      <td valign="Top"><br>
      </td>
    </tr>
    <tr>
      <td valign="Top">host<br>
      </td>
      <td valign="Top">all<br>
      </td>
      <td valign="Top">all<br>
      </td>
      <td valign="Top">::1/128<br>
      </td>
      <td valign="Top">md5<br>
      </td>
      <td valign="Top"><br>
      </td>
    </tr>
  </tbody>
</table>
<br>
Is all required option set ? If no, what is required to access from any client
?<br>
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; <br>
Josef &nbsp; &nbsp;&nbsp;&nbsp; <br>
<br>
Magnus Hagander wrote:<br>
<blockquote type="cite" cite="mid:6BCB9D8A16AC4241919521715F4D8BCEA356C7@algol.sollentuna.se">
  <pre wrap="">Edit postgresql.conf and set a listen_addresses that's not just<br>localhost. Then edit pg_hba.conf and add permissions based on the soruce<br>address of the connection. There are sections in the manual that will<br>explain the details of what you have to put there.<br><br>//Magnus<br><br></pre>
  <blockquote type="cite">
    <pre wrap="">-----Original Message-----<br>From: Josef Springer [<a class="moz-txt-link-freetext" href="mailto:Josef.Springer@joops.com">mailto:Josef.Springer@joops.com</a>]<br>Sent: Tuesday, September 19, 2006 12:18 PM<br>To: Magnus Hagander<br>Cc: <a class="moz-txt-link-abbreviated" href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a><br>Subject: Re: [ADMIN] Where is the msi-setup described ?<br><br>Hi Magnus,<br><br>thanks for quick answer. I have installed PostgreSQL 8.1 on the<br>server without the option Accept connections on all addreses, not<br>just localhost . I want to connect from a client. How can this<br>option be switched on without a new installation of the server ?<br><br>Josef<br><br>Magnus Hagander wrote:<br><br><br>		Hi folks,<br><br><br>		where do i get documentation about the msi-setup<br>dialogs for<br>		Windows plaforms  ?<br><br><br>	<a class="moz-txt-link-freetext" href="http://pginstaller.projects.postgresql.org">http://pginst
aller.projects.postgresql.org</a><br><br>	//Magnus<br><br><br>	---------------------------(end of broadcast)----------------<br>-----------<br>	TIP 9: In versions below 8.0, the planner will ignore your<br>desire to<br>	       choose an index scan if your joining column's<br>datatypes do not<br>	       match<br><br><br><br></pre>
    </blockquote>
    <pre wrap=""><!----><br><br>---------------------------(end of broadcast)---------------------------<br>TIP 4: Have you searched our list archives?<br><br>               <a class="moz-txt-link-freetext" href="http://archives.postgresql.org">http://archives.postgresql.org</a><br><br><br></pre>
    </blockquote>
    </body>
    </html>

--------------060900020108020105050405--