From: | Josef Springer <Josef(dot)Springer(at)joops(dot)com> |
---|---|
To: | Magnus Hagander <mha(at)sollentuna(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Where is the msi-setup described ? |
Date: | 2006-09-19 11:00:15 |
Message-ID: | 450FCDBF.3070100@joops.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)Springer(at)joops(dot)com]
>>Sent: Tuesday, September 19, 2006 12:18 PM
>>To: Magnus Hagander
>>Cc: pgsql-admin(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Matthias.Pitzl | 2006-09-19 11:09:41 | Re: Where is the msi-setup described ? |
Previous Message | Magnus Hagander | 2006-09-19 10:28:30 | Re: Where is the msi-setup described ? |