Re: [GENERAL] [ADMIN] 6.5.3/doesn't recognize localhost in pg_hba.conf (fwd)

Yes, and Yes.

# su - postgres

$ id -a
uid=400(postgres) gid=400(postgres) groups=400(postgres)
$ ls -l $PGDATA/pg_hba.conf
-r--------    1 postgres postgres       5192 Nov 13 15:59 /usr/local/pgsql/data/pg_hba.conf
$ postmaster -i&
[1]     28410
$ psql
No pg_hba.conf entry for host localhost, user postgres, database postgres
Connection to database 'postgres' failed.
No pg_hba.conf entry for host localhost, user postgres, database postgres
$ ls -laR $PGDATA
total 92
drwx------    3 postgres postgres       1024 Nov 13 15:59 .
drwxr-xr-x    8 postgres postgres       1024 Nov 13 16:01 ..
-rw-------    1 postgres postgres          4 Nov 13 15:59 PG_VERSION
drwx------    3 postgres postgres         96 Nov 13 15:58 base
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_database
-r--------    1 postgres postgres       3407 Nov 13 15:59 pg_geqo.sample
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_group
-r--------    1 postgres postgres       5192 Nov 13 15:59 pg_hba.conf
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_log
-rw-rw-rw-    1 postgres postgres         53 Nov 13 15:59 pg_pwd
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_shadow
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_variable

/usr/local/pgsql/data/base:
total 6
drwx------    3 postgres postgres         96 Nov 13 15:58 .
drwx------    3 postgres postgres       1024 Nov 13 15:59 ..
drwx------    2 postgres postgres       2048 Nov 13 15:59 template1

/usr/local/pgsql/data/base/template1:
total 1878
drwx------    2 postgres postgres       2048 Nov 13 15:59 .
drwx------    3 postgres postgres         96 Nov 13 15:58 ..
-rw-------    1 postgres postgres          4 Nov 13 15:59 PG_VERSION
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_aggregate
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_am
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_amop
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_amproc
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_attrdef
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_attrdef_adrelid_index
-rw-------    1 postgres postgres      49152 Nov 13 15:59 pg_attribute
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_attribute_attrelid_index
-rw-------    1 postgres postgres      49152 Nov 13 15:59 pg_attribute_relid_attnam_index
-rw-------    1 postgres postgres      32768 Nov 13 15:59 pg_attribute_relid_attnum_index
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_class
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_class_oid_index
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_class_relname_index
-rw-------    1 postgres postgres      65536 Nov 13 15:59 pg_description
-rw-------    1 postgres postgres      40960 Nov 13 15:59 pg_description_objoid_index
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_index
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_indexes
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_inheritproc
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_inherits
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_ipl
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_language
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_listener
-rw-------    1 postgres postgres       8192 Nov 13 15:59 pg_opclass
-rw-------    1 postgres postgres      65536 Nov 13 15:59 pg_operator
-rw-------    1 postgres postgres     172032 Nov 13 15:59 pg_proc
-rw-------    1 postgres postgres      40960 Nov 13 15:59 pg_proc_oid_index
-rw-------    1 postgres postgres     139264 Nov 13 15:59 pg_proc_proname_narg_type_index
-rw-------    1 postgres postgres      57344 Nov 13 15:59 pg_proc_prosrc_index
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_relcheck
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_relcheck_rcrelid_index
-rw-------    1 postgres postgres      24576 Nov 13 15:59 pg_rewrite
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_rules
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_statistic
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_tables
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_trigger
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_trigger_tgrelid_index
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_type
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_type_oid_index
-rw-------    1 postgres postgres      16384 Nov 13 15:59 pg_type_typname_index
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_user
-rw-------    1 postgres postgres          0 Nov 13 15:59 pg_views
$ tail -10 $PGDATA/pg_hba.conf
# The above would allow users from 192.168.0.x hosts to connect to any
# database, but if Ident says the user is "bryanh" and he requests to
# connect as PostgreSQL user "guest1", the connection is only allowed if
# there is an entry for map "omicron" in pg_ident.conf that says "bryanh" is
# allowed to connect as "guest1".

# By default, allow anything over UNIX domain sockets and localhost.

local        all                                         trust
host         all         127.0.0.1     255.255.255.255   trust
$

Patrick Welche wrote:
> Larry Rosenman wrote:
> >
> > Just trying to get answers....
> >
> > LER
>
> > HELP!
> >
> > Just recompiled PostgreSQL 6.5.3 on UnixWare 7.1.0 on a P-III.
> >
> > Followed all the steps, but when I try to connect, it says
> > that there is NO pg_hba.conf entry, but there is.
> >
> > Anyone else see this?
>
> Does $PGDATA/pg_hba.conf exist on your system? Did you run initdb?
>
> Cheers,
>
> Patrick
>


--
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749