Search Postgresql Archives

Re: Debugging Failed Startup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <rgacote@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:


On Thu, May 2, 2019 at 2:57 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx


--
Raymond Cote, President
voice: +1.603.924.6079 email: rgacote@xxxxxxxxxxxxxxxxxxxxxxxx skype: ray.cote




--
Raymond Cote, President
voice: +1.603.924.6079 email: rgacote@xxxxxxxxxxxxxxxxxxxxxxxx skype: ray.cote



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux