From: Shane Ambler <pgsql@Sheeky.Biz>
To: Simone Gadenz <s.gadenz@geologyx.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: Connecting from xp to linux server
Date: Tue, 10 Jun 2008 00:09:19 +0930
Message-ID: <484D4097.4070807@Sheeky.Biz> (raw)
In-Reply-To: <484D11CC.3050806@geologyx.it>
References: <484D11CC.3050806@geologyx.it>
Simone Gadenz wrote:
> Hi all,
>
> this is the problem I am facing.
>
> I have PG 8.3 running on a KUBUNTU installation running on a virtual
> machine. From inside the virtual machine I can use PGADMIN to manage PG
> but when I try to connect from the xp machine I have this error: "Error
> connecting to the server:FATAL: missing or erroneous pg_hba.conf file" .
>
> I set the permission in the pg_hba.conf on the server.
>
> The machine talk each oher, I can ping and use telnet on the 5432 port.
>
> The log on the server does not report any problem.
>
> Ideas?
>
If you can telnet then I would say your network and firewall is right
and the error with pg_hba.conf is where you need to look.
The pg_hba.conf is located in the data dir that you have specified for
postgresql. Is it there? What entries do you have after all the
comments? The errornous part would indicate a small syntax error or did
you edit it on windows with cr/nl characters and copy it across to linux?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
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: pgsql@Sheeky.Biz, s.gadenz@geologyx.it
Subject: Re: Connecting from xp to linux server
In-Reply-To: <484D4097.4070807@Sheeky.Biz>
* 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