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