Can not connect to Postgres instance

715 views
Skip to first unread message

Nhat Khanh Le Dinh

unread,
Aug 28, 2017, 10:36:10 AM8/28/17
to Google Cloud SQL discuss
My Postgres instance and deploy nodejs app are on the same project, I tried this connection string: pg://postgres:[Password]@/[DB]?host=/[Instance_name] but Knex always return this error: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? How to fix this, thank you.
I tried this on my local machine (Allow my IP) and it works fine.

Shivam(Google Cloud Support)

unread,
Aug 28, 2017, 1:28:47 PM8/28/17
to Google Cloud SQL discuss

Could you try this example. If you get the same error, elaborate how are you connecting to the instance.


Justin Medina

unread,
Jan 23, 2018, 8:50:44 PM1/23/18
to Google Cloud SQL discuss
Hi Nhat,

I'm having exactly the same issue. The response below was not helpful (neither the example nor the connecting link) but I suspect there is an issue with how we are writing the connection string. Were you ever able to solve your problem, and if so, how?

Justin Medina

unread,
Jan 23, 2018, 8:50:44 PM1/23/18
to Google Cloud SQL discuss


On Monday, August 28, 2017 at 7:36:10 AM UTC-7, Nhat Khanh Le Dinh wrote:

Kurtis Van Gent

unread,
Jan 24, 2018, 12:06:44 PM1/24/18
to Google Cloud SQL discuss
Hi Justin, 

Are you using App Engine Standard? I don't believe that the Node.js runtime supports connections with PostgreSQL on CloudSQL at this time.

Thanks,
Kurtis
Reply all
Reply to author
Forward
0 new messages