Re: Postgres
Re: Postgres
- Subject: Re: Postgres
- From: Giorgio Valoti <email@hidden>
- Date: Wed, 29 Oct 2003 16:51:57 +0100
On Mercoledl, ott 29, 2003, at 16:15 Europe/Rome, Philip Mvtteli wrote:
Am 29.10.2003 um 15:29 schrieb Giorgio Valoti:
On Mercoledl, ott 29, 2003, at 14:38 Europe/Rome, Philip Mvtteli
wrote:
sudo -u postgres /sw/bin/pg_ctl start -D /sw/var/postgresql/data -l
/sw/var/postgresql/logfile -o -i
should be enough. So, let's see... Is your pg_hba.conf file correctly
configured? With something like this:
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT
host all 127.0.0.1 255.255.255.255 trust
When I put just this, I have the following error from Webmin: "SQL
select version() failed : No pg_hba.conf entry for host localhost,
user postgres, database template1"
And from EOModeler isn't any change, nor any log messages.
Before I had this:
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
local all all
trust
host all all 127.0.0.1 255.255.255.255
trust
local is for UNIX domain sockets, which could explain why you can
connect with Webmin but not with eomodeler.
The second entry should be enough to let access your db from the
loopback interface. You can enable your whole local subnet, but you
should have the same results:
... IP_ADDRESS MASK ...
... 192.168.93.0 255.255.255.0 ...
I also see, that in your list, there's no USER? How come?
I'm using pgSQL 7.2
--
Giorgio Valoti
-------------
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
| References: | |
| | >Re: Postgres (From: Philip Mötteli <email@hidden>) |