Questions tagged [postgres]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

How can I use psql installed inside docker to work with heroku pg:psql?

To be clear, I am not deploying Docker image on to heroku. Heroku deployment is normal git push In order to test locally, I am using postgres via docker, instead of native installation. heroku pg:...
0
votes
0answers
47 views

Dataclip Error ERROR: cannot execute CREATE TABLE in a read-only transaction

I just created a Heroku database but when I try and run a simple create table command in the I get the data clips it says: Dataclip Error ERROR: cannot execute CREATE TABLE in a read-only ...
0
votes
0answers
12 views

Heroku Postgres Dataclip shows wrong information

At least that's what I'm guessing the issue is, I'm rather new to both databases and Heroku. It works just fine with all the other tables and table 'user' itself is likely functional, as app is using ...
0
votes
0answers
67 views

How to not get charged for large unused posgres database?

I am planning for a heroku app using a postgres database with 1m rows. The app only runs three months of the year. If I disable the app, will I continue to get charged for the 1m record database? ...
1
vote
1answer
122 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
112 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 = ...
0
votes
0answers
47 views

How to fetch “bulk data loads” from salesforce using python and store it in postgres table?

How to fetch the number of record processed and number of record failed in salesforce using python. After a Bulk API upsert, how can i inspect the batch to find the count of record I am using the ...
1
vote
1answer
44 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
136 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, ...