Questions tagged [postgres]
The postgres tag has no summary.
14 questions
3 votes
0 answers
92 views
Salesforce database providers and infrastructure [closed]
I've heard from some architects (in person) that Salesforce database on classic instances runs on Oracle infrastructure, while Hyperforce runs on PostreSQL. I tried to find some official Salesforce ...
0 votes
1 answer
217 views
Unable to perform Insert/Update operation on Heroku Postgres
We have a Codeigniter (PHP) application hosted on the Heroku instance. We are using the Heroku Postgres database to connect and do CRUD operations. It is also connected to the Salesforce instance ...
0 votes
1 answer
996 views
Heroku Database Detached
I am new to Heroku and have deployed an application recently. It worked for a week before breaking. The issue lies on something related to Heroku. I see the following activity in Heroku. api-...
1 vote
1 answer
485 views
Heroku ECONNREFUSED with most console commands
I'm on Ubuntu 20, working on a Rails 6.05 project with a Postgres DB. I've succesfully created a Heroku app using heroku create appname and then deployed the Rails app using git push heroku master. ...
1 vote
0 answers
498 views
Am I calling my DATABASE_URL correctly with Axios? (CORS error with Heroku Postgres..)
I am trying to deploy an app using a combination of NodeJS, Heroku, and the Postgres add-on database. Everything works fine when I deploy locally. When I try to deploy off of Heroku, however, I get ...
1 vote
1 answer
948 views
Django Heroku: remaining connection slots are reserved for non-replication superuser connections
I recently deployed an app to Heroku using Postgres free tier as database. I am using Django 3.2 Everything was working fine until I started getting a mail with the following error: Internal Server ...
0 votes
1 answer
105 views
Loading 5 million+ Emails into Salesforce
We have millions of emails(actual HTML emails that were sent to clients) stored in our old CRM Siebel but since we are migrating away from Siebel ,now we want to migrate those emails to Salesforce so ...
1 vote
0 answers
975 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
1 answer
240 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. ...
1 vote
0 answers
52 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 ...
1 vote
1 answer
1k 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
0 answers
143 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
1 answer
55 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
1 answer
300 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, ...