1,052 questions
0
votes
1
answer
33
views
Connect to Heroku PostgreSQL using Tableau ODBC and SSL
I'm trying to connect to my Heroku PostgreSQL database through Tableau and ODBC, this needs to be over ODBC because it needs to be SSL connection. This being said, I have configured a User DSN. I ...
- 1,084
0
votes
2
answers
62
views
Performing data validation using hash comparison on snowflake tables
Here is the scenario:
I have data in two schemas within Snowflake, aiming to validate that both tables contain identical data values. I’ve set up a dynamic SQL approach in Snowflake to accomplish this....
0
votes
2
answers
75
views
Postgres Query fast when field TRUE and slow when FALSE
I have a tickets table (Postgres on Heroku) that has about 7 million records.
I have a single table query that is run often with the exported field either true or false. When it is true, it runs very ...
- 259
0
votes
0
answers
20
views
How to set search paths for Heroku PostgreSQL database?
I'm currently deploying a Django app to Heroku, and my settings.py looks like this:
if IS_HEROKU_APP:
DATABASE_URL = dj_database_url.config(
env="DATABASE_URL",
...
- 101
2
votes
1
answer
471
views
Huge performance degradation after upgrade to Postgres 16
Heroku updated my Postgres instance from version 13 to 16 tonight.
After this update we have huge performance issues. The simplest queries take a few seconds to execute.
Regardless of whether I do it ...
- 255
0
votes
1
answer
35
views
Heroku Postgres not working on Heroku Server [Django]
I have a Django project, where I am using Redis/Celery to call some API's. I've set up my settings.py file to connect to the Postgres database and when running the Django project locally (with Redis/...
- 1
0
votes
0
answers
46
views
SQL Inner Join is incorrectly returning 'None' in an entire column
I am a hobbyist who is trying to deploy a Flask app with Heroku. The project worked fine when running locally. I was using SQLite locally and transferred the database to Postgres on Heroku.
I have ...
- 59
0
votes
0
answers
47
views
Ruby on Rails app ID sequence gets out of order all the time
I have a Ruby on Rails app using a Heroku Postgres database. When I create new records for any model, the id's get out of sequence constantly. They usually skip about 30 id's. I know how to reset the ...
- 1,098
0
votes
0
answers
24
views
Which Database name Should I Follow When Upgrading Heroku Postgres?
I am following the Heroku documentation for upgrading the version of a Heroku Postgres database.
I am currently on Step 1: Provision a Follower Database
However, when I ran the command heroku pg:info -...
- 957
0
votes
0
answers
23
views
Connecting to Heroku Postgres with a different environment variable
The app I'm trying to deploy to Heroku uses an environment variable different from the one Heroku Postgres automatically sets and I'm unable to find a way to change it. That is, my app uses the ...
- 1
0
votes
0
answers
31
views
Application error is coming in heroku, for N8N one click deploy, after deploying
According to the n8n documentation of one click deploy to heroku, I clicked the button, named the app and set the required fields. later I generated SSL using ACM and the status is green. but in the ...
0
votes
0
answers
15
views
heroku aplication getting error after launched [duplicate]
I'm new in deploying app. I started using Heroku.
I followed msome web tutorials, by heroku and another devs, everything goes ok but after i launhce the qpp and try to acces te link, i get this error ...
- 1
0
votes
2
answers
75
views
I am trying to view rows and run queries in my heroku postgres database using the heroku pg:psql command but I always get this error
I am trying to view rows and run queries in my heroku postgres database using the heroku pg:psql command but I always get this error : --> Connecting to postgresql-tapered-69603
psql: error: ...
0
votes
0
answers
21
views
Connecting to Heroku database issue
(First time on stack overflow) I am trying my React project with my Heroku database. the DATABASE_URL matches the URI and I feel like I have made all the correct steps I even forced: true on the db....
- 1
0
votes
0
answers
83
views
Heroku - Django - How to reduce cool down of keep alive
I have an API that creates a model object whenever an action is true.
Slight problem, everytime the API sends some data it creates a connection and these connections dont seem to cool down very ...
- 313