Connexion to Postgresql using TCP/IP

From: Secrétariat <ets(at)rolland-fr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Connexion to Postgresql using TCP/IP
Date: 2004-07-23 13:57:31
Message-ID: 004c01c470bc$ffdef1a0$0a00a8c0@lrp43008
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello !

I use a PostgreSQL server 7.4 on Linux Mandrake 10 with IP 192.168.0.15,
a database gestix is created.
An PostegreSQL user "postgres" id defined on this server,
I add in the .bash_profile of this user the line :
PGDATA=$HOME/data; export PGDATA
My PC have IP 192.168.0.10.
in postgresql.conf I have :
tcpip_socket = true
in pg_hba.conf I add :
host all all 192.168.0.10 255.255.255.255 trust
(I know, I shoul'd use better identification, it's for testing)

When I log as postgres if I use :
pg_ctl start
the postmaster is coming up,
I can connect from the PC with PgAdmin3 under Windows XP.

On automatic startup, or when I use :
service postgresql start
I can't connect from the PC. I get the message :
FATAL : no pg_hba.conf entry for host "192.168.0.10", user "postgres", database "gestix", SSL off

I don't understand my error (probably I made one ?)
I'm becoming mad !

What's the matter ?

Best regards.

Luc ROLLAND

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-07-23 14:33:04 Re: Connexion to Postgresql using TCP/IP
Previous Message Doug McNaught 2004-07-23 13:54:31 Re: pgadmin problem