Questions tagged [postgres]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
45 views

Suddenly my heroku application can't connect to Postgres. (It seems that the host of the DB server has changed.)

I'm running an application using Heroku's free plan. The application worked fine for more than half a year, but suddenly on 2021/2/24, it couldn't connect to DB (Postgres). I tried to access the DB ...
0
votes
0answers
67 views

Cannot connect to my Postgres database anymore: password authentication failed

I have this Heroku Postgres database in a hobby-dev plan for 2 months. Today I started to get this error: FATAL: password authentication failed for user "fjmtbqnoddqvqv" I did not change ...
0
votes
1answer
30 views

Node.js (Heroku integration with Salesforce): How to get records from Salesforce and display them on a Heroku app using Node.js

I have created an Heroku app to be able to retrieve records (Contracts) from Salesforce and display them on my Heroku app. But I am struggling to write the correct request on my node.js code. ...
0
votes
0answers
37 views

Heroku to Salesforce: How to fix TypeError: pendingItem.callback is not a function

I have deployed a Node.js app to heroku to be able to update a contact on Salesforce using Heroku Connect and Heroku Postgres. But when pressing the "Update Contact Information Button" ...
1
vote
0answers
20 views

Heroku & Salesforce - Database question for multiple environments [closed]

Along with our production org, we have 3 full sync sandboxes, Mule APIs and Heroku. We are in the process of setting up an app, which is really just going to hold a postgreSQL database that is written ...
0
votes
0answers
62 views

FATAL: remaining connection slots are reserved for non-replication superuser connections

My app was running perfectly until just a few minutes ago. I keep getting this error: FATAL: remaining connection slots are reserved for non-replication superuser connections Currently, there are ...
1
vote
1answer
356 views

External Object Related List shows timeout error

I am trying to configure an external object in Salesforce for which the source is a Postgres table that contains approx. 34 million records. I was able to set up the External data Source which ...
1
vote
0answers
122 views

Error when connecting to Heroku PG

When I connect to Heroku PG using pgAdmin III, I get the following error: 12:41:28 PM: Error: ERROR: column "proisagg" does not exist LINE 9: WHERE proisagg = FALSE AND pronamespace = ...
1
vote
1answer
45 views

Run Postgres migration script [closed]

I'm currently running a Dockerized NodeJS application that's using Postgres. The Postgres database url is coming as an environment variable, as set by Heroku. While this works great inside my ...
2
votes
1answer
177 views

Heroku Postgres, Redis, Kafka - is one better for storing key/value string pairs?

I'm going to make sure this stays specific and not flagged as too broad. I'm putting together an approach to store data in Heroku. This data is relatively simple in nature - it's key/value pairs, ...