From: | Martin Moore <martin(dot)moore(at)avbrief(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgres 9.6 fails to start on VMWare |
Date: | 2017-10-22 14:13:21 |
Message-ID: | 6D3A8E33-4539-47AE-A09E-D3A6826CBA61@avbrief.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I’ve migrated a running Debian Jessie system from a Google Compute instance to a VMWare ESXi 6.5 system.
Postgres won’t start, although returns [ok] :
/etc/init.d/postgresql start 9.6
[ ok ] Starting postgresql (via systemctl): postgresql.service.
2017-10-22 14:08:28 UTC [2479-1] LOG: 00000: database system shutdown was interrupted; last known up at 2017-10-22 14:07:20 UTC
2017-10-22 14:08:28 UTC [2479-2] LOCATION: StartupXLOG, xlog.c:6009
2017-10-22 14:08:28 UTC [2479-3] LOG: 00000: database system was not properly shut down; automatic recovery in progress
2017-10-22 14:08:28 UTC [2479-4] LOCATION: StartupXLOG, xlog.c:6505
2017-10-22 14:08:28 UTC [2479-5] LOG: 00000: redo starts at A1/688398C0
2017-10-22 14:08:28 UTC [2479-6] LOCATION: StartupXLOG, xlog.c:6760
2017-10-22 14:08:28 UTC [2479-7] LOG: 00000: invalid record length at A1/6AC96408: wanted 24, got 0
2017-10-22 14:08:28 UTC [2479-8] LOCATION: ReadRecord, xlog.c:4024
2017-10-22 14:08:28 UTC [2479-9] LOG: 00000: redo done at A1/6AC963E0
2017-10-22 14:08:28 UTC [2479-10] LOCATION: StartupXLOG, xlog.c:7023
2017-10-22 14:08:28 UTC [2479-11] LOG: 00000: last completed transaction was at log time 2017-10-21 16:40:52.629875+00
2017-10-22 14:08:28 UTC [2479-12] LOCATION: StartupXLOG, xlog.c:7028
2017-10-22 14:08:29 UTC [2479-13] LOG: 00000: request to flush past end of generated WAL; request A1/72AF47A8, currpos A1/6AC96408
2017-10-22 14:08:29 UTC [2479-14] CONTEXT: writing block 0 of relation base/203725/2840_vm
2017-10-22 14:08:29 UTC [2479-15] LOCATION: WaitXLogInsertionsToFinish, xlog.c:1583
2017-10-22 14:08:29 UTC [2479-16] FATAL: XX000: xlog flush request A1/72AF47A8 is not satisfied --- flushed only to A1/6AC96408
2017-10-22 14:08:29 UTC [2479-17] CONTEXT: writing block 0 of relation base/203725/2840_vm
2017-10-22 14:08:29 UTC [2479-18] LOCATION: XLogFlush, xlog.c:2765
2017-10-22 14:08:29 UTC [2478-1] LOG: 00000: startup process (PID 2479) exited with exit code 1
2017-10-22 14:08:29 UTC [2478-2] LOCATION: LogChildExit, postmaster.c:3504
2017-10-22 14:08:29 UTC [2478-3] LOG: 00000: aborting startup due to startup process failure
2017-10-22 14:08:29 UTC [2478-4] LOCATION: reaper, postmaster.c:2777
2017-10-22 14:08:29 UTC [2478-5] LOG: 00000: database system is shut down
2017-10-22 14:08:29 UTC [2478-6] LOCATION: UnlinkLockFiles, miscinit.c:755
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2017-10-22 17:09:21 | Re: Re: Restoring tables with circular references dumped to separate files |
Previous Message | rakeshkumar464 | 2017-10-22 12:32:56 | How to get login user name and host name in pgaudit |