hey Mariano,

damn thing has me stumped.  i first under root:

> cp postgresql.conf.sample postgresql.conf
> gedit postgresql.conf &
where i added the line
listen_addresses = '*'
> service postgresql-9.1 restart
Stopping postgresql-9.1 service:                           [  OK  ]
Starting postgresql-9.1 service:                           [  OK  ]

then under lucas:
> psql prac2 -U lucas -h 127.0.0.1
psql: FATAL:  Ident authentication failed for user "lucas"
> psql
psql: FATAL:  database "lucas" does not exist

but this works
> psql prac2

i did add your lines to pg_hba.conf:

# IPv4 local connections:
local   all         postgres                          ident
local   all         all                               ident
host    all         all         127.0.0.1/32          md5
host    all         all         ::1/128               md5
host       all         all      0.0.0.0/0             md5
hostssl    all         all      0.0.0.0/0             md5
host    all             all             127.0.0.1/32            md5
hostssl    all             all             127.0.0.1/32            md5

and after restarting the postgres service, i still get
> psql prac2 -U lucas -h 127.0.0.1
psql: FATAL:  Ident authentication failed for user "lucas"
> psql
psql: FATAL:  database "lucas" does not exist

really really stumped

Reply via email to