"Leonardo Ribeiro Queiros" <leonardo@eee.ufg.br> writes:
> analysis the archives [ pg_hba.conf ] and [ postgresql.conf ]
>
>
>
> [pg_hba.conf]
> ...
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> local all postgres trust
> host all postgres 127.0.0.1 255.255.255.255 trust
> host all all 0.0.0.0/0 trust
> # IPv6 local connections:
> #host all all ::1/128 trust
Your pg_hba.conf is missing a line that corresponds to the interface to the world
of the network card.
You should add a line for the subnet your computer is connected to, for example:
host all all 172.17.1.87 255.255.248.0 md5
This is for the connection from all computers in my subnet with md5 password-authentication.
If you do not use localhost as hostname in the connection string, this is needed even
for local connections.
--
Roland Walter mailto: rwa (at) mosaic-ag (dot) com
MOSAIC SOFTWARE AG phone: +49 (0) 22 25 / 88 2-41 1
Am Pannacker 3 fax: +49 (0) 22 25 / 88 2-20 1
D-53340 Meckenheim http://www.mosaic-ag.com
Die in dieser E-Mail enthaltenen Nachrichten und Anhaenge sind ausschliesslich
fuer den bezeichneten Adressaten bestimmt. Sie koennen rechtlich geschuetzte,
vertrauliche Informationen enthalten. Falls Sie nicht der bezeichnete Empfaenger
oder zum Empfang dieser E-Mail nicht berechtigt sind, ist die Verwendung,
Vervielfaeltigung oder Weitergabe von Nachrichten und Anhaengen untersagt.
Falls Sie diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte
unverzueglich den Absender und vernichten Sie die E-Mail.
This e-mail message and any attachment are intended exclusively for the named
addressee. They may contain confidential information which may also be protected
by professional secrecy. Unless you are the named addressee (or authorised to
receive for the addressee) you may not copy or use this message or any attachment
or disclose the contents to anyone else. If this e-mail was sent to you by mistake
please notify the sender immediately and delete this e-mail.
