RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

From: Brent Bates <BBates(at)langleyfcu(dot)org>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems
Date: 2019-06-19 20:28:27
Message-ID: CY4PR1301MB2200377D6725169DE4F2EFF8A9E50@CY4PR1301MB2200.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-06-19 20:49:51 Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems
Previous Message Tom Lane 2019-06-19 19:51:25 Re: First Time Starting Up PostgreSQL and Having Problems