I am designing a process to test my postgresql 10.8 backups by restoring them to a random point in time in a throwaway virtual machine. I have been unable to fully automate the process though. I am blocked at step 8 (section 25.3.4) of the official documentation
- Start the server.
When executing the
pg_ctl start over ssh, the command hangs until it is killed. If I ssh directly onto the VM and execute
pg_ctl start, then the command returns quickly as expected.
This thread from 2012 seems to describe a similar scenario. In my case however the postgres process does start successfully even if the calling session is killed while it is hanging (possibly an improvement between 9.0.5 and 10.8 though?).
This github issue seems relevant but sadly is "solved" by a long rewrite in a language I don't know and concludes finally that it's a bug in the
The Big Question
How can I automate step 8 so that I can continue on to subsequent validation tests of my backup media?
Is this an outstanding bug in the binary I need to hack around? Or have I missed a sensible implementation?