1,049 questions
1
vote
1
answer
116
views
n8n and postgres deploy incompatibility version
I am trying to use the fast deploy of n8n with heroku:
link deploy
But, I get the following error:
We tried to create heroku-postgresql:essential-0, but received an error from the add-on provider. Try ...
0
votes
1
answer
43
views
Django Heroku django-tenant attributeerror: 'databasewrapper' object has no attribute 'schema_name'
I'm migrating my development to django-tenants, I didn´t had any issues doing it on my local, but when I push my changes to the prod environment in Heroku, I'm getting the following error:
...
- 525
0
votes
0
answers
12
views
Adding add-ons on build to Review applications on Heroku
This is my app.json file which i am using to push to github for the review app on heroku but the add-ons listed are not being added upon build finish. How to fix this?
{
"name": "test ...
0
votes
0
answers
48
views
How to get local issuer certificate when trying to run migration on Heroku
I get the error below. How can I find out what the issue is? I've tried running this command from the Heroku website's terminal, and I still get the same error
unable to get local issuer certificate
...
- 37
1
vote
1
answer
155
views
ActiveRecord::ConnectionNotEstablished tries local PostgreSQL socket instead of Heroku DB
I have a Rails 8.0.1 application (Ruby 3.3.4) that I’m deploying to Heroku. The code pushes successfully, but whenever I run:
heroku run rails db:migrate
I get this error:
ActiveRecord::...
1
vote
1
answer
124
views
Heroku not running database migrations for Rails app
I have a Rails 8 app deployed to Heroku. The app was working with the Postgres database connected. I pushed code for an automatic deploy. The deploy said it worked, but I am getting a 500 on some ...
- 450
0
votes
1
answer
77
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,104
0
votes
2
answers
367
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
81
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 ...
- 369
5
votes
2
answers
3k
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 ...
- 285
0
votes
1
answer
39
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/...
- 11
0
votes
0
answers
50
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
52
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
19
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
104
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
100
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 ...
- 415
1
vote
1
answer
538
views
DrizzleORM - ClientAuthentication Error using `heroku-postgres` database (aws) connection url
I am trying to connect to a heroku-postgres database with drizzleORM, the db is actually an aws db.
This is the error I get, using the db url I got from the heroku dashboard:
xxx\node_modules\drizzle-...
- 167
1
vote
1
answer
92
views
Flask Deployment on Heroku Issue : App not compatible with buildpack
I hope you can help me out, I developed a flask app and I'm trying to deploy to heroku.
I have researched and followed the steps I came across in youtube videos etc
My git tree is clean, I have a ...
- 41
0
votes
1
answer
126
views
Deployment Failure on Heroku: Vue-CLI Build Errors
I am encountering persistent issues with deploying my Node.js application, which includes a Vue.js frontend, on Heroku. Despite multiple attempts and varying configurations, my builds consistently ...
- 3
2
votes
1
answer
266
views
How to move PostGIS extension out of the schema heroku_ext in a Heroku Postgres database?
I have encountered the following problem with the Postgresql database on Heroku and the PostGIS extension with a Python/Django Rest Framework project.
When trying to release the application, I get the ...
1
vote
1
answer
43
views
Heroku API for data processing and Postgres post
I'm attempting to write my first API. I wrote (with help of GPT), a simple Request script and I uploaded the Dash-API script to Heroku. I'm getting input from multiple remote locations and I wish to ...
- 303
1
vote
1
answer
149
views
Heroku deployment failing due to bad PG connection
I've been running my Rails application on Heroku with a PostgreSQL database for years without any issues. However, recently, I've started encountering a connection timeout error, and I'm not sure what'...
- 21
0
votes
1
answer
186
views
Background jobs on heroku
I am brand new to Heroku and I am going through the tutorials for a Rails app.
Right now all it does is process some background jobs with sidekiq. The only frontend component is the Sidekiq dashboard.
...
- 23
0
votes
1
answer
153
views
Heroku: Unable to Resolve Sequelize
I'm trying to re-deploy an old project to Heroku and running into the error: Unable to resolve sequelize package in /app after pushing, then running the command heroku run npx sequelize-cli db:migrate....
- 21
0
votes
1
answer
65
views
Local postgres database not syncing with Heroku postgres database
I am creating a CRM system with Django for my non-profit organisation. Have installed a local postgres database to which I created a table students and have added 2 rows via Django Admin interface. ...
- 3
0
votes
1
answer
53
views
Assets files not read in the uploaded Laravel project
Everything has been connected, but the problem is in the page formatting and the style is not loaded or read, why, what is the problem, is it in La Ravel or is it missing a definition that I did not ...
0
votes
0
answers
44
views
Securely connect to a database from a CLI
I am writing a CLI in Kotlin primarily using this library: the CLIKT Library and I am using Gradle to manage dependencies
I have a separate Django website that I have deployed to Heroku
This Heroku ...
- 220
0
votes
1
answer
59
views
Why is Filterrific Search in Production on Heroku add-on db not working?
I use the filterrific gem (currently 5.2.3) a lot for my Rails apps and love it. I have run into a weird problem. I have a secondary Postgres database for my dev team to write to as an additional add-...
- 3
0
votes
1
answer
38
views
Django Heroku /GET Favicon.Ico when running heroku logs --tail
My Heroku build is complete, but the application is not booting for some reason.
When I run heroku logs --tail,
2023-09-04T13:32:07.484629+00:00 heroku[router]: at=error code=H10 desc="App ...
0
votes
1
answer
175
views
How to encrypt the entire PostgreSQL database in Heroku?
So we have this PostgreSQL managed by Heroku and I am looking for a way to encrypt the entire database. I already searched for it online but the only thing I found was the PGCrypto extension.
The ...
- 3,488
1
vote
0
answers
48
views
Significantly slower DB queries between Ruby 2.7.6 (heroku-20) and Ruby 3.1.4 (heroku-22)
I have a Ruby 2.7.6 app running on Heroku (stack heroku-20) and a branch of the same app on Ruby 3.1.4 running on Heroku (stack heroku-22). Both have identical DBs. Running these two branches locally, ...
- 1,985
2
votes
0
answers
341
views
When deploying a Next.js application on Heroku, only the server-side data is obtained, but there is no page rendering
if my expression is too verbose or unclear, please let me know and I will immediately make corrections. Thank you.
I encountered some issues while deploying my project to Heroku (as stated in the ...
- 21
1
vote
0
answers
103
views
apt file and sql repository error on app deployment in Heroku
Newbie here. I am trying to deploy an app in Heroku. All the code and files are in github.
In the review apps, the app is working just fine, but when it is in production, I don't understand why it is ...
- 11
0
votes
0
answers
55
views
Can't deploy rails app to heroku Compilation failed: [webpack-cli] Failed to load '/tmp//config/webpack/production.js' config
Here's the link to the git repo so you can see webpack files:
https://github.com/grantleslie/tenantportal
I can't deploy to Heroku. I have the ruby buildpack installed on my heroku app, and the git ...
- 1
0
votes
1
answer
109
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 ...
- 1,716
0
votes
1
answer
246
views
Heroku provided DATABASE_URL is incorrect
We're migrating our ORM from Sequelize to Prisma, and we have a Heroku Postgres add-on setup. In Sequelize, we had the connection string hardcoded to the credentials below:
So our config.json looked ...
- 315
3
votes
3
answers
1k
views
Connecting Heroku Postgres to Google Studio Looker
I'm trying to connect a Heroku Postgres database to Google Looker Studio (former Data Studio).
I found an old stack overflow question that suggests I need to use SSL and for that I need to enable ...
- 2,911
1
vote
0
answers
41
views
Heroku postgres crached
I want to run some python code from a remote server in order to expose the database in output of this code. Do you have an idea of what is my probleme ?
I'm connected to the heroku posgresql apps-on ...
0
votes
1
answer
31
views
failure to deploy by django webapp on heroku
Good day, I'm trying to deploy by django webapp on heroku but i'm facing the following problem.
The conflict is caused by:
The user requested botocore==1.23.50
awsebcli 3.20.3 depends ...
- 27
1
vote
0
answers
137
views
"ClassNotFoundException: org.springframework.boot.SpringApplication" for Deploy Spring Boot app to Heroku
I have created a simple repository which has two functions:
Greets the user.
Asks for a username, saves it to the postgresql database, greets the user by this name.
When I test my application ...
- 2,010
1
vote
0
answers
100
views
How do I fetch data from Heroku Postgres database in my Heroku app?
My Heroku app fetches data from a "products" table in my database to display on my shop page. When I deploy the app on Heroku, the shop page isn't rendering the products. I'm not seeing any ...
0
votes
0
answers
339
views
Receiving external Webhooks in Heroku
I'd like to receive web hooks in Heroku from a third-party app and perform an action upon reception (a simple Rest API request). I'm a bit of a beginner in this.
I've followed Heroku's guide, assuming ...
- 393
0
votes
1
answer
2k
views
pg_restore: error: error returned by PQputCopyData when restoring database to heroku
I have my local database and I created a dump file that is 1.1GB I need that data to put on Heroku but every time I run this command
pg_restore --verbose --clean --no-acl --no-owner -h heroku-host -U ...
0
votes
1
answer
574
views
What is the postgres_fdw CLOSE transaction and why does it block the table?
I just went to run a migration on my production database. The migration was a simple ALTER TABLE .. add a column on a small table. I had tested it locally, it ran in under a second. But when I ...
- 2,003
0
votes
0
answers
47
views
how big can a Heroku Postgres database be?
I have a Heroku database ($200 plan). THe database is quite simple: it contains user clicks. There are about 10 fields in the main table, some fields are indexed, and the table contains about several ...
- 8,832
0
votes
1
answer
61
views
Rails App Heroku PG::UndefinedTable: ERROR:
I have been searching for 12 hours to a solution to this problem, please can someone help with the following.
Locally my app is working as it should no errors, as soon as I deploy to heroku it just ...
- 21
1
vote
0
answers
44
views
How can I access the Heroku Postgres Database copy?
I was one of the users who had their free DB deleted. I notice they left me with a DB copy when I run heroku pg:backups as you can see below:
(venv) MacBook-Pro-4:TheDropCore adamlamorre$ heroku pg:...
- 705
0
votes
1
answer
228
views
problem deploying ruby on rails app to Heroku: ruby version issue
I forked and cloned a repo so I could deploy to Heroku - then I got the message below asking to upgrade the project Ruby version.
! The Ruby version you are trying to install does not exist on ...
2
votes
1
answer
322
views
What is the command to upgrade Heroku Postgresql to a Basic plan
I need to upgrade my Heroku Postgresql database to the Basic plan. I've found the command in Heroku's docs, but I'm not sure if I need to change it to affect my account. My app's name on Heroku is ...
- 1,764
2
votes
0
answers
124
views
Heroku App + Heroku Postgres query doesn't seem to be working
I have a React, Node/Express, Postgres app hosted / deployed on heroku
Everything was working locally up until I made configurations for deployment
The client side seems to be working, server side as ...
- 21