Unable to connect to Cloud Sql (postgres) from firebase function

Question

I am using nodejs firebase functions. I use sequlize to connect to the postgres db.

I tried following the doc https://cloud.google.com/functions/docs/sql to connect to the db from firebase functions, but I am not able to connect. I get this error.

Failed to prune sessions: connect ECONNREFUSED 127.0.0.1:5432

This is the configuration that I use.

{ username: 'postgres',
    password: '*********',
    database: 'testdb',
    host: '/cloudsql/my-project:us-central1:db-instance',
    port: 5432,
    dialect: 'postgres',
    dialectOptions: { ssl: false }}

Any thoughts ?

I don't know anything about sequlize, but I'll ask if you're you sure that host string is correct? Something is trying to connect to the local Cloud Functions instance, which is obviously not right. — Doug Stevenson
– Doug Stevenson, Commented Dec 21, 2018 at 22:12
@DougStevensonn thanks for the hint. I got it fixed. Btw the fire base carol was awesome : ) — Muthukumar
– Muthukumar, Commented Dec 23, 2018 at 20:33

Muthukumar · Accepted Answer · 2018-12-22 21:36:27Z

0

My bad. I was also using pg session and it was using a connection string. I guess pg was not able to differentiate the host from the connection string.

After replacing the connection string with a pg pool object, I was able to connect.

edited Dec 22, 2018 at 21:36

answered Dec 22, 2018 at 11:05

Muthukumar

9,73918 gold badges67 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to connect to Cloud Sql (postgres) from firebase function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related