Re: Streaming replica failure

2021-04-30 Thread Vijaykumar Jain
Were there any issues with hardware ? Memory/storage ? I am not sure but it look like data loss to me. If you have admin access? Can you run dmesg -a, system logs, hyperion logs etc and see if there are any errors related to memory corruption. Coz if there are hardware issues, this will happen

Streaming replica failure

2021-04-27 Thread Aleš Zelený
Hello, we are using PostgreSQL 12.4 on CentOS 7. The hot standby failed: 2021-04-24 09:19:27 CEST [20956]: [747-1] user=,db=,host=,app= LOG: recovery restart point at 3D8C/352B4CE8 2021-04-24 09:19:27 CEST [20956]: [748-1] user=,db=,host=,app= DETAIL: Last completed transaction was at log time