Re: Debugging Failed Startup

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?

> 
> 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


-- 
Adrian Klaver
adrian.klaver@aklaver.com