Questions tagged [postgres]
The postgres tag has no usage guidance.
15
questions
3
votes
0
answers
53
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 ...
- 61
0
votes
0
answers
86
views
Calling Heroku Postgres Stored Procedure from APEX class
I'm attempting at using Heroku as an External data source for my Salesforce ORG and run process heavy transformation tasks.
I have created my Postgres DB on Heroku, Installed the Salesforce connector ...
- 1
0
votes
1
answer
157
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 ...
- 101
0
votes
1
answer
875
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
1
vote
1
answer
428
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.
...
- 111
1
vote
0
answers
478
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 ...
- 11
1
vote
1
answer
907
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 ...
- 111
0
votes
1
answer
97
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
913
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 ...
- 11
0
votes
1
answer
224
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.
...
- 79
1
vote
0
answers
45
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 ...
- 173
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
136
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 = ...
- 11
1
vote
1
answer
50
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 ...
- 111
2
votes
1
answer
281
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, ...
- 6,441