I tried putting the pg_hba.conf back to stock defaults and that didn't
help any. Here is a snippet of the current file:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
I've tried single and multiple tabs or a single space between columns. It
doesn't make any difference. It always complains about the 3rd column.
Whatever is in that column is the 'near token' value. I know zero entries in
the pg_hba.conf valid, but I was just trying to see if the real error was
upstream of this file.
As far as I know, I've got a 'stock' build of PostgreSQL. I just double
checked the yum configuration and it pulled PostgreSQL from:
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-$releasever-$basearch
I wish I had kept the original postgresql.conf file for comparison. It is
primarily the original file with all the default values uncommented. I like
making sure I know what all the settings are and if it is supposed to be a
default value, I'd like to make sure it is. The pg_hba.conf file listed in
postgresql.conf is one of the few things I didn't touch at all.
#hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file
# (change requires restart)
I suppose if I had to, I could wipe the PostgreSQL stuff clean and start
over from scratch. This is a brand new install. I can keep backups of the
these 2 files I changed for comparison after the reinstall. Thanks for
responding so quickly.
Brent L. Bates - UNIX System Administrator - Langley Federal Credit Union
Phone: (757) 848-5443, Mobile: (757) 419-0295
COMMUNICATION CONFIDENTIALITY: All information in this communication, including
attachments, is strictly confidential and intended solely for delivery to and
authorized use by the addressee(s) identified above, and may contain
privileged, confidential, proprietary and/or secret information entitled to
protection and/or exempt from disclosure under applicable law. If you are not
the intended recipient, please destroy or delete this communication and any/all
attached documents as the possession, distribution and/or copying of this
communication is unauthorized and may be unlawful. If you have received this
communication in error, please remove it in its entirety from your computer and
notify the sender.
