From: | Nilesh Govindarajan <lists(at)itech7(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Socket & TCP connections |
Date: | 2010-03-28 17:11:05 |
Message-ID: | 4BAF8DA9.2010000@itech7.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I'm trying to setup PostgreSQL so that, it will not ask password when
connected locally (socket) whereas it will ask when connected using
TCP/IP. This should apply ONLY to root account. But this is not working -
local all root trust
local all all md5
# IPv4 local connections:
#host all root 127.0.0.1/32 trust
#host all root ::1/128 trust
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
I cannot give passwordless access to TCP/IP because then it will become
a big security hole using PhpPgAdmin exposed to the public.
--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
मेरा भारत महान !
मम भारत: महत्तम भवतु !
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Williams | 2010-03-28 17:41:41 | ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory |
Previous Message | Guillaume Lelarge | 2010-03-27 14:41:23 | Re: Database size growing over time and leads to performance impact |