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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749