Spoke too soon, Not coming back after a boot. Seems I can install, run, but not reboot!
On Thu, May 2, 2019 at 3:18 PM Ray Cote <rgac...@appropriatesolutions.com> wrote: > > > On Thu, May 2, 2019 at 2:57 PM Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> On 5/2/19 11:22 AM, Ray Cote wrote: >> > Does anyone have a hint on how I'd go about debugging why PostgreSQL 11 >> > is not starting on CentOS 7? >> > Was running fine for several weeks then fails to come up after a reboot. >> > >> > I did change the name of the CentOS7 server, but I don't expect that to >> > have any effect on the database. >> > >> > I'm running debug5 to the logs. >> >> The log below is coming from your syslog? >> >> Is there more in the syslog? >> > Yes, that's from the syslog (messages) trimmed a little. There's nothing > further in the log. > Added the debug messages that were prior to that below. > > Ended up uninstalling and installing and all's fine again. Comes back > after a reboot. > >> > >> > There's nothing in the ./log directory past the database shutting down. >> > Here's what's in messages. All seems to be fine and then boom! >> > >> >>> ... systemd: Starting PostgreSQL 11 database server... >> >> ... postmaster: ... DEBUG: postmaster: PostmasterMain: initial >>> environment dump: >> >> ... postmaster: ... DEBUG: ----------------------------------------- >> >> ... postmaster: ... DEBUG: #011LANG=en_US.UTF-8 >> >> ... postmaster: ... DEBUG: >>> #011PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin >> >> ... postmaster: ... DEBUG: #011NOTIFY_SOCKET=/run/systemd/notify >> >> ... postmaster: ... DEBUG: #011HOME=/var/lib/pgsql >> >> ... postmaster: ... DEBUG: #011LOGNAME=postgres >> >> ... postmaster: ... DEBUG: #011USER=postgres >> >> ... postmaster: ... DEBUG: #011SHELL=/bin/bash >> >> ... postmaster: ... DEBUG: #011PGDATA=/var/lib/pgsql/11/data/ >> >> ... postmaster: ... DEBUG: >>> #011PG_OOM_ADJUST_FILE=/proc/self/oom_score_adj >> >> ... postmaster: ... DEBUG: #011PG_OOM_ADJUST_VALUE=0 >> >> ... postmaster: ... DEBUG: #011PGLOCALEDIR=/usr/pgsql-11/share/locale >> >> ... postmaster: ... DEBUG: #011PGSYSCONFDIR=/etc/sysconfig/pgsql >> >> ... postmaster: ... DEBUG: #011LC_COLLATE=en_US.UTF-8 >> >> ... postmaster: ... DEBUG: #011LC_CTYPE=en_US.UTF-8 >> >> ... postmaster: ... DEBUG: #011LC_MESSAGES=en_US.UTF-8 >> >> ... postmaster: ... DEBUG: #011LC_MONETARY=C >> >> ... postmaster: ... DEBUG: #011LC_NUMERIC=C >> >> ... postmaster: ... DEBUG: #011LC_TIME=C >> >> ... postmaster: ... DEBUG: ----------------------------------------- >> >> ... postmaster: ... DEBUG: registering background worker "logical >>> replication launcher" >> >> > ... postmaster: LOG: listening on IPv6 address "::1", port 5432 >> > ... postmaster: LOG: listening on IPv4 address "127.0.0.1", port 5432 >> > ... postmaster: LOG: listening on Unix socket >> > "/var/run/postgresql/.s.PGSQL.5432" >> > ... postmaster: LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" >> > ... postmaster: DEBUG: invoking IpcMemoryCreate(size=148553728) >> > ... postmaster: DEBUG: SlruScanDirectory invoking callback on >> > pg_notify/0000 >> > ... postmaster: DEBUG: removing file "pg_notify/0000" >> > ... postmaster: DEBUG: dynamic shared memory system will support 288 >> > segments >> > ... postmaster: DEBUG: created dynamic shared memory control segment >> > 1998722972 (6928 bytes) >> > ... postmaster: DEBUG: max_safe_fds = 983, usable_fds = 1000, >> > already_open = 7 >> > ... postmaster: LOG: redirecting log output to logging collector >> process >> > ... postmaster: HINT: Future log output will appear in directory "log". >> > ... systemd: postgresql-11.service: main process exited, code=exited, >> > status=1/FAILURE >> > ... systemd: Failed to start PostgreSQL 11 database server. >> > ... systemd: Unit postgresql-11.service entered failed state. >> > >> > --Ray >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> > > > -- > Raymond Cote, President > voice: +1.603.924.6079 email: rgac...@appropriatesolutions.com skype: > ray.cote > Schedule a meeting: https://calendly.com/ray_cote/60min/ > > > -- Raymond Cote, President voice: +1.603.924.6079 email: rgac...@appropriatesolutions.com skype: ray.cote Schedule a meeting: https://calendly.com/ray_cote/60min/
