From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Brent Bates <BBates(at)langleyfcu(dot)org> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: First Time Starting Up PostgreSQL and Having Problems |
Date: | 2019-06-19 19:51:25 |
Message-ID: | 21255.1560973885@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Brent Bates <BBates(at)langleyfcu(dot)org> writes:
> 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"
Hm ... could we see exactly what you have in pg_hba.conf?
> 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"
That's just weird. Zero entries in pg_hba.conf isn't a useful situation
(since the postmaster wouldn't allow any connections), but if I try it
I get a failure like this:
2019-06-19 15:43:24.257 EDT [20959] LOG: starting PostgreSQL 12beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-23), 64-bit
2019-06-19 15:43:24.281 EDT [20959] LOG: listening on IPv4 address "0.0.0.0", port 5440
2019-06-19 15:43:24.281 EDT [20959] LOG: listening on IPv6 address "::", port 5440
2019-06-19 15:43:24.282 EDT [20959] LOG: listening on Unix socket "/tmp/.s.PGSQL.5440"
2019-06-19 15:43:24.303 EDT [20959] LOG: configuration file "/home/postgres/testversion/data/pg_hba.conf" contains no entries
2019-06-19 15:43:24.303 EDT [20959] FATAL: could not load pg_hba.conf
2019-06-19 15:43:24.305 EDT [20959] LOG: database system is shut down
Reading between the lines suggests that something might be trying to
recursively read pg_hba.conf if it's empty, but it's hard to say what that
something could be. Are you sure this is a stock build of Postgres?
Where did you get it from?
Another question is what non-default (not-commented) entries you have in
postgresql.conf. One idea that came to me while thinking about the syntax
error is that maybe you have one of the other configuration-file-name
variables pointing to pg_hba.conf. That error message tells us that the
server is trying to read pg_hba.conf, right enough, but it doesn't
actually say what it's expecting to find in that file ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Brent Bates | 2019-06-19 20:28:27 | RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems |
Previous Message | Brent Bates | 2019-06-19 19:31:56 | First Time Starting Up PostgreSQL and Having Problems |