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
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 |