From: | Kevin Coyner <kevin(at)rustybear(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: configuring postgresql on the browser |
Date: | 2003-04-05 16:40:49 |
Message-ID: | 20030405164049.GA24483@rustybear.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Fri, Apr 04, 2003 at 11:18:41PM +0200, Don Patou wrote......
> I'm trying to get pgsql to work on my browser but I can't connect. It works
> great on the shell and the psql webmin module works great but when it comes
> to phppgadmin or connecting my php application I get a :
<snip>
> this is what's on my pg_hba.conf file maybe there's something wrong with it:
>
> local all all ident sameuser
> host all all 127.0.0.1 255.255.255.255 ident sameuser
> host all all 0.0.0.0 255.255.255.255 reject
I struggled with this for a while too, especially in terms of getting
phppgadmin to work.
I've got the following in my pg_hba.conf
local all all trust
host all all 127.0.0.1 255.255.255.0 md5
Also, in your postgresql.conf make sure you have tcpip_socket = 1 as
shown below.
# Connection Parameters
#
# TCP/IP access is allowed by default, but the default access given in
# pg_hba.conf will permit it only from localhost, not other machines.
tcpip_socket = 1
I think these were the only changes I had to make to get phppgadmin to
work on the localhost.
HTH.
Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Manfred Koizar | 2003-04-05 17:27:48 | Re: Bad performance for a 3000 rows table updated permanently |
Previous Message | Don Patou | 2003-04-05 15:10:19 | Re: configuring postgresql on the browser |