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:20UTC
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general