Socket & TCP connections

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
मेरा भारत महान !
मम भारत: महत्तम भवतु !

Responses

Browse pgsql-admin by date

  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