Re: Can not connect to database in Workgroup-Net on Windows-XP

From: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
To: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can not connect to database in Workgroup-Net on Windows-XP
Date: 2007-01-11 10:54:09
Message-ID: 45A61751.6040603@mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Firstly it would be helpful to say what error you're getting on the
client side.
At a quick guess, I would say it's because you've got 2 "0.0.0.0"
declarations in your pg_hba.conf - you only need the one - like this:

host all all 0.0.0.0/0 md5

Regards,

Andy.

Josef Springer wrote:
> Hi folks,
>
> i have a workgroup (not a classic server) with Windows-XP-machines:
>
> the database server machine contains the line
> host all all 0.0.0.0
> 0.0.0.0 md5
> in the file pg_hba.conf
> and
> listen_addresses = '*'
> in the file postgresql.conf.
>
> the 'client's host file contain the line
> */nnn.nnn.nnn.nnn Labor/* where /nnn.nnn.nnn.nnnn/ is the IP-adress of
> the database server machine and /Labor /is the machine's name.
>
> If i start PGAdmin III on the 'client' machine i can not connect to
> the database on the /Labor/ no matter wether i use the machine's name
> or the IP-adress.
>
> What to do ?
>
> mit freundlichen Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> Postal
> Address
> _Josef(dot)Springer(at)joops(dot)com _
> Orlando-di-Lasso Str. 2
> D-85640 Putzbrunn
> Phone
> Office
> +49 (0)89 600 6920
>
>
> Phone
> Fax
> +49 (0)89 600 69220
>
>
> Web
> Web
> http://www.joops.com
>
>
>
>
> JOOPS
> *-- the software company --*
>
>
>
>
>
> !DSPAM:37,45a60e36137102078430163!

--
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Mamin 2007-01-11 12:07:08 configuring the postmaster.log
Previous Message Rigmor Ukuhe 2007-01-11 10:42:57 Re: Lob datatype