debbie trunk (2.5 builds failing) for 9.6 and 9.5

[robe]

I've been scratching my head on this one. debbie seems to be failing on just postgis 2.5 runs for 9.6,9.5 (I tested those). pg 11 and pg 10 are fine.

I thought it was maybe result of my recent upgrades but that would affect 2.4 runs and those are fine and would probably affect pg10 and pg11.

Then I thought maybe it's the port I'm running them on, so switch to the same pg ports I use for 2.4 job, still no go.

I get this error:

psql: FATAL:  the database system is starting up

almost like it is just not getting enough time to finish startup.

Very stumped.

[robe]

okay answer just came to me. I recalled strk added a Drop postgis_reg database command to trunk recent. I think that may be what's causing the problem.

I added a sleep 5 to the postgis regress and so far so good. Maybe in past since there was no pre-drop the postgres instance had just enough time to get ready for connections, before the tests started. Perhaps 11 and 10 just start up faster.

2.4 wouldn't have the issue since I don't think strk back-ported the change.

I'll close as soon as I have confirmed the sleep call does the trick. I maybe should just put this as part of regress script instead of hard-coding in the PostGIS_Regress job.

[robe]

In 16190:

Add 5 seconds sleep before attempt to drop regress database, to give pg time to start up in case not fully started.
Closes #3962