Skip site navigation (1) Skip section navigation (2)

Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X

From: Lola Lee <lola(at)his(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X
Date: 2004-12-15 11:31:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I am running the latest version of OS X on my PowerBook.  When I try to 
access my 7.4.3 Postgresql installation (I used the package from, I get this message "Login disallowed for security reasons. 
". So, I checked ph_hba.conf and this is how it is set up right now:

local   all         all                                             trust
# IPv4-style local connections:
host    all         all   trust
# IPv6-style local connections:
host    all         all         ::1 
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust

  So I ought to be able to access the database server at, unless I'm missing something. Also, I 
checked for phpPgAdmin, as follows:

// Display name for the server on the login screen
$conf['servers'][0]['desc'] = 'PostgreSQL';

// Hostname or IP address for server.  Use '' for UNIX domain socket.
$conf['servers'][0]['host'] = '';

// Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432;

// Change the default database only if you cannot connect to template1
$conf['servers'][0]['defaultdb'] = 'template1';

// Specify the path to the database dump utilities for this server.
// You can set these to '' if no dumper is available.
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';

I also tried setting extra_login_security in, to true, 
and to false, but that doesn't work in both cases.  When I access the 
database server in Terminal as postgres, it works just fine.

I'm totally clueless as to why this is happening.  I've had previous 
installations of Postgresl and had no problems.

Lola - mailto:lola(at)his(dot)com | Blog at
Terrorism delenda est! (Terrorism must be destroyed utterly!)
I'm in Bowie, MD, USA, halfway between DC and Annapolis.


pgsql-novice by date

Next:From: GeoffreyDate: 2004-12-15 12:39:54
Subject: Re: postgresql compile errors
Previous:From: Keith WorthingtonDate: 2004-12-15 03:39:56
Subject: Re: status variables

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group