Обсуждение: pgAdmin requires password

<div class="Section1"><p class="MsoNormal">I have modified the C:\Program Files\PostgreSQL\8.4\data\pg_hba.conf file to
allowanyone to access any database without a password:<p class="MsoNormal"> <p class="MsoNormal">host    all        
all        127.0.0.1/32          trust<p class="MsoNormal"> <p class="MsoNormal">The problem is, when I start pgAdmin,
itrequests the password for user postgres.  I thought the pg_hba.conf file would eliminate the need for the password
forpgAdmin.<p class="MsoNormal"> <p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:navy">JaysonPrichard</span></b><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""> </span><p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy">Northrop Grumman</span></b><span style="font-size:12.0pt;
font-family:"Times New Roman","serif""></span><p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy">Warner Robins Avionics Engineering Sustainment Center</span></b><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""><br /></span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">SeniorSoftware Engineer</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""><br /></span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">293Highway 247 South</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""><br /></span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">WarnerRobins, Ga. 31088</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""><br /></span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">478.929.7349</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""> </span></div> 

On Wed, Sep 9, 2009 at 3:56 PM, Prichard, Jayson S
(TS)<jayson.prichard@ngc.com> wrote:
> I have modified the C:\Program Files\PostgreSQL\8.4\data\pg_hba.conf file to
> allow anyone to access any database without a password:
>
>
>
> host    all         all         127.0.0.1/32          trust
>
>
>
> The problem is, when I start pgAdmin, it requests the password for user
> postgres.  I thought the pg_hba.conf file would eliminate the need for the
> password for pgAdmin.

pgAdmin has no idea that a password isn't required until the
connection is attempted. Just save an empty (or any other password)
and it shouldn't ask again (unless the connection fails for some
reason).

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

On Wed, Sep 9, 2009 at 7:54 PM, Prichard, Jayson S
(TS)<jayson.prichard@ngc.com> wrote:
> Dave,
>
> That was my suggestion: if PostgreSQL uses the pg_hba.conf file for authentication, perhaps pgAdmin should/could as
well.

It has no idea where it is until a connection is established - and in
most cases couldn't access it until then, even if it remembered from a
previous session (and wouldn't know if you'd revoked 'trust' in the
meantime).

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com