There is an issue with the pg npm package version that is included with the example code. There is a very simple fix that will solve this timeout error:
npm install pg@latest --save
Thank you for posting a solution to this. knex changed after the book went into print, and I’m sure other readers will encounter this same issue.