pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josef Springer <Josef.Springer@joops.com>
To: Magnus Hagander <mha@sollentuna.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Where is the msi-setup described ?
Date: Tue, 19 Sep 2006 13:00:15 +0200
Message-ID: <450FCDBF.3070100@joops.com> (raw)
References: <450FAE7A.9070408@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C6@algol.sollentuna.se>
	<450FC3E0.2030001@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C7@algol.sollentuna.se>

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

view thread (7+ messages)  latest in thread

Message-ID: <450FCDBF.3070100@joops.com>
Permalink:  ../450FCDBF.3070100@joops.com/
Also on:    postgresql.org/message-id/450FCDBF.3070100@joops.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Josef.Springer@joops.com, mha@sollentuna.net
  Subject: Re: Where is the msi-setup described ?
  In-Reply-To: <450FCDBF.3070100@joops.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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