Question

How to set up postgraphile on a digitalocean hosted postgres db

I am trying to setup postgraphile on an already existing DigitalOcean hosted postgres db by following the instructions here https://www.graphile.org/postgraphile/quick-start-guide/ “npx postgraphile -c ‘postgres://user:secret-0.b.db.ondigitalocean.com:25060/defaultdb?sslmode=require?ssl=true&sslrootcert=ca-certificate.crt’ --watch --enhance-graphiql --dynamic-json” but it fails on the very first trial with a connection time out error reproduced below. PostGraphile v4.12.3 server listening on port 5000 :rocket:

‣ GraphQL API: http://localhost:5000/graphql ‣ GraphiQL GUI/IDE: http://localhost:5000/graphiql ‣ Postgres connection: postgres://doadmin:[SECRET]@user.b.db.ondigitalocean.com:25060/defaultdb (watching) ‣ Postgres schema(s): public ‣ Documentation: https://graphile.org/postgraphile/introduction/ ‣ Node.js version: v14.17.0 on linux x64 ‣ Join Simon Elliott in supporting PostGraphile development: https://graphile.org/sponsor/


A serious error occurred when building the initial schema. Exiting because retryOnInitFail is not set. Error details:

Error: connect ETIMEDOUT 46.101.73.34:25060 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1146:16)

it seems like a permission issue of the server not allowing connections from the location.

How can I resolve this?


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer