Re: Windows 10 got stuck with PostgreSQL at starting up. Adding delay lets it avoid.

t; Anyway, we will try and confirm it. We tried it. "Delayed start" was ineffective. Also setting a script that start the PostgreSQL service on the "startup" folder was ineffective. It has not been solved except by PostgreSQL code modification (inserting delay). Thanks, Haruk

Re: Windows 10 got stuck with PostgreSQL at starting up. Adding delay lets it avoid.

onfirm it. Thanks, Takatsuka Haruka > TAKATSUKA Haruka schrieb am 29.06.2018 um 08:03: > > I got a trouble in PostgreSQL 9.3.x on Windows 10. > > I would like to add new delay code as an official build option. > > > > Windows 10 sometime (approximately once in 300 tries) hu

Windows 10 got stuck with PostgreSQL at starting up. Adding delay lets it avoid.

accepted such delay codes as build-time options by preprocessor variables? Thanks, Takatsuka Haruka diff --git a/src/backend/postmaster/postmaster.c b/src/backend/postmaster/postmaster.c index d6fc2ed..ff03ebd 100644 --- a/src/backend/postmaster/postmaster.c +++ b/src/backend/postmaster

Hot standby failing with PANIC: WAL contains references to invalid pages

Hi folks, I got the same failure with the following report on Amazon Linux 2017.09 and postgresql95-9.5.8-1.73.amzn1.x86_64. The WAL's RMGR ID and its type (Heap2/VISIBLE) are also same. The servers had worked for over 2 weeks and the standby crashed. Firstly we suspected something low layer cur