Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


On 12/09/2010 06:52 PM, John Abreau wrote:
> Did you add permissions to pg_hba.conf? By default, psql uses
> UNIX sockets, not TCP/IP, and ph_hba.conf (Host-Based Access)
> is where you set those permissions.
> On CentOS (and presumably RHEL and Fedora, too), the file is at
>      /usr/share/pgsql/pg_hba.conf
> On my home web server, I added the following to pg_hba.conf:
>     host    all         all          password
> This allows all users you define inside postgresql to connect from loca=
On RHEL it is in /var/lib/pgsql/data/
/usr/share/pgsql/ contains sample files.
My pg_hba.conf contains:
local   all         all                               ident sameuser
host    all         all          ident sameuser

If I use UNIX domain sockets or TCP, I still get the same message from
PHPBB3 when I use either localhost or, but as I mentioned the
command line pgsql command did allow me to create the database.

In any case, I installed mysql and the system came right up.

Jerry Feldman <gaf-mNDKBlG2WHs at>
Boston Linux and Unix
PGP key id: 537C5846
PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB  CA3B 4607 4319 537C 5846

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /