From: | Ray Cote <rgacote(at)appropriatesolutions(dot)com> |
---|---|
To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Debugging Failed Startup |
Date: | 2019-05-02 18:22:46 |
Message-ID: | CAG5tnzpZcKGeJE7B8c4uNKDcfw-eHT3JuiJAd7A+Jr0CD7_GAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
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!
... 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-05-02 18:57:23 | Re: Debugging Failed Startup |
Previous Message | rihad | 2019-05-02 17:45:25 | Re: Upgrading locale issues |