Article 56BE0 Why is postgres failing to start?

Why is postgres failing to start?

by
andrewm659
from LinuxQuestions.org on (#56BE0)
I have a new build of CentOS 8 (latest) and am trying to get postgres 11 working. I had it working when it was communicating on localhost. But the minute I changed the config to the IP address or '*' it stopped working started complaining. SELinux IS turned on! I want to keep it that way. IPv6 is disabled at the kernel level.

Code:[@sql001 ~]$ sudo getsebool -a|grep -i postgres
postgresql_can_rsync --> on
postgresql_selinux_transmit_client_label --> off
postgresql_selinux_unconfined_dbadm --> on
postgresql_selinux_users_ddl --> on
selinuxuser_postgresql_connect_enabled --> on
[@sql001 ~]$Code:[@sql001 ~]$ sudo systemctl status postgresql-11.service
postgresql-11.service - PostgreSQL 11 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Thu 2020-07-30 14:57:49 CDT; 7s ago
Docs: https://www.postgresql.org/docs/11/static/
Process: 2284 ExecStart=/usr/pgsql-11/bin/postmaster -D ${PGDATA} (code=exited, status=1/FAILURE)
Process: 2279 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 2284 (code=exited, status=1/FAILURE)

Jul 30 14:57:48 sql001.loc.example.com systemd[1]: Starting PostgreSQL 11 database server...
Jul 30 14:57:48 sql001.loc.example.com postmaster[2284]: 2020-07-30 14:57:48.771 CDT [2284] LOG: listening on IPv4 address "0.0.0.0", port 5432
Jul 30 14:57:48 sql001.loc.example.com postmaster[2284]: 2020-07-30 14:57:48.835 CDT [2284] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Jul 30 14:57:48 sql001.loc.example.com postmaster[2284]: 2020-07-30 14:57:48.965 CDT [2284] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
Jul 30 14:57:48 sql001.loc.example.com postmaster[2284]: 2020-07-30 14:57:48.989 CDT [2284] LOG: redirecting log output to logging collector process
Jul 30 14:57:48 sql001.loc.example.com postmaster[2284]: 2020-07-30 14:57:48.989 CDT [2284] HINT: Future log output will appear in directory "log".
Jul 30 14:57:48 sql001.loc.example.com systemd[1]: postgresql-11.service: Main process exited, code=exited, status=1/FAILURE
Jul 30 14:57:48 sql001.loc.example.com systemd[1]: postgresql-11.service: Killing process 2286 (postmaster) with signal SIGKILL.
Jul 30 14:57:49 sql001.loc.example.com systemd[1]: postgresql-11.service: Failed with result 'exit-code'.
Jul 30 14:57:49 sql001.loc.example.com systemd[1]: Failed to start PostgreSQL 11 database server.
[@sql001 ~]$Code:Jul 30 15:47:59 sql001 sudo[3136]: user: TTY=pts/0 ; PWD=/home/ameyer ; USER=root ; COMMAND=/bin/systemctl restart postgresql-11.service
Jul 30 15:47:59 sql001 sudo[3136]: pam_systemd(sudo:session): Cannot create session: Already running in a session or user slice
Jul 30 15:47:59 sql001 sudo[3136]: pam_unix(sudo:session): session opened for user root by user(uid=0)
Jul 30 15:48:00 sql001 sudo[3136]: pam_unix(sudo:session): session closed for user rootThere isn't much in the logs. I've tried turning up the logging as well. No dice.

TIA!latest?d=yIl2AUoC8zA latest?i=N_lTQWz-zC0:QGibwudjeXQ:F7zBnMy latest?i=N_lTQWz-zC0:QGibwudjeXQ:V_sGLiP latest?d=qj6IDK7rITs latest?i=N_lTQWz-zC0:QGibwudjeXQ:gIN9vFwN_lTQWz-zC0
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments