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@xxxxxxxxx]
Sent: Tuesday, September 19, 2006 12:18 PM
To: Magnus Hagander
Cc: pgsql-admin@xxxxxxxxxxxxxx
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://pginst aller.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
