From: Ivo Rossacher <rossacher@bluewin.ch>
To: pgsql-admin@postgresql.org
Subject: Re: Connecting from xp to linux server
Date: Tue, 10 Jun 2008 00:25:32 +0200
Message-ID: <200806100025.32836.rossacher@bluewin.ch> (raw)
In-Reply-To: <484D9D62.8050705@geologyx.it>
References: <484D11CC.3050806@geologyx.it>
<484D4097.4070807@Sheeky.Biz>
<484D9D62.8050705@geologyx.it>
The attached pg_hba.conf file does have several mistakes in.
Every entry needs a mask or cidr and an auth-method. Pleas see the manual at
chapter 21.1 for details about the different formats which are recognized.
psql is a command line tool to access a database.
Best regards
Ivo
Am Montag, 9. Juni 2008 23:15:14 schrieb Simone Gadenz:
> Shane,
>
> I attached the pg_hba.conf I have on the server. I can use pgadmin3 when
> I connect from the server itself, so I think the pg_hba on the server is
> correct.
>
> From the client machine I cannot connect through pgadmin3. Is there
> another way to test connection client server? Has pg a textual client to
> send sql statements?
>
> Thanks a lot
>
> Simone
>
> Shane Ambler ha scritto:
> > 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?
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: rossacher@bluewin.ch
Subject: Re: Connecting from xp to linux server
In-Reply-To: <200806100025.32836.rossacher@bluewin.ch>
* 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