First Time Starting Up PostgreSQL and Having Problems
I've done a lot of Google searching and PostgreSQL archive searching and can't seem to figure out why I'm having problems. This is a first time install of PostgreSQL version 11.3 on a CentOS server running release 7.6.1810. I've just finished setting up the postgresql.conf and pg_hba.conf files and am trying to start up PostgreSQL for the first time. I'm getting errors no matter what I try. My first attempt resulted in errors that look like the following: syntax error in file "/var/lib/pgsql/11/data/pg_hba.conf" line 84, near token "all" I received this error for every configuration line that wasn't a comment. The "all" is in the USER column. No matter what I put in the USER column, I get the same error, but listing whatever string is in that column. I wandered if this error was just a result of a different error someplace else, so I commented out all lines in this file. That resulted in the following error: FATAL: exceeded maxAllocatedDescs (16) while trying to open file "/var/lib/pgsql/11/data/pg_hba.conf" I'm at a loss and don't know where to look next. Any help or pointers would be greatly appreciated. Thanks. Brent L. Bates - UNIX System Administrator Information Technology Department - Langley Federal Credit Union 11742 Jefferson Avenue Suite 240 Newport News, VA 23606 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.
RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems
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 DATABASEUSERADDRESS 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.
RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems
I found the problem. I cleared everything out and started from scratch, then slowly added my changes back to the configuration files. The problem was in the postgresql.conf. At the bottom of the file I had uncommented all the ‘include’ lines, so they looked like this: include_dir = ''# include files ending in '.conf' from # a directory, e.g., 'conf.d' include_if_exists = '' # include file only if it exists include = ''# include file The first one is what caused all the headaches. I recommented out these lines and everything works now. Thanks for all the quick suggestions. 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.
