Header Shadow Image


Archive for May, 2019

FATAL:  the database system is starting up

If you are receiving the following when postgresql ( w/ Patroni ) is starting up: 2019-04-04 14:59:15.715 EDT [26025] FATAL:  could not receive data from WAL stream: ERROR:  requested WAL segment 000000390000000000000008 has already been removed 2019-04-04 14:59:16.420 EDT [26029] FATAL:  the database system is starting up consider running the individual postgres line separately in […]

psql01 etcd: read wal error (walpb: crc mismatch) and cannot be repaired

To fix: May 22 00:29:31 psql01 etcd: read wal error (walpb: crc mismatch) and cannot be repaired Do the following.  First copy the old wal files out of the way: [root@psql01 wal]# ls -altri total 375092 201347741 -rw——-. 1 etcd etcd 64000056 Mar 30 15:44 0000000000000027-000000000181bbc9.wal 201347715 -rw——-. 1 etcd etcd 64000104 Apr  1 18:46 […]


     
  Copyright © 2003 - 2013 Tom Kacperski (microdevsys.com). All rights reserved.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License