current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help

Tagged Questions

Heroku Postgres is the SQL database service run by Heroku that is provisioned and managed as an add-on.

learn more… | top users | synonyms

0
votes
0answers
10 views

OmniAuth::Strategies::OAuth2::CallbackError, invalid_signature | Signature does not match, it may have been tampered with shopify_app

I am getting error on finalize stage after installation of an app of shopify https://fe172941.ngrok.io/auth/shopify/callback? code=559593f3cc09b670717318307de38a02&hmac=...
0
votes
0answers
9 views

Node.js app on Heroku. Getting started

Starting from this documentation: Getting Started on Heroku with Node.js(https://devcenter.heroku.com/articles/getting-started-with-nodejs). I am now trying to put my own thing together. Inside db....
0
votes
0answers
9 views

can't run rake db:migrate on heroku

what's wrong with my schema? I can't add a new table I created. I get stuck here... SELECT "schema_migrations".* FROM "schema_migrations" Migrating to ChangeDataTypeForFieldname (20161014185102) (...
0
votes
0answers
13 views

Heroku PG - trying to create role for blazer gem “permission denied”

I'm following the "Permissions" part of the blazer gem set-up, and I'm using heroku, but I don't have permission to create any roles. app-development::DATABASE=> BEGIN; BEGIN app-development::...
1
vote
0answers
16 views

How do I disable Heroku PostgreSQL in review apps?

I am trying to enable review apps for a Rails application that uses MySQL, but Heroku keeps automatically installing Heroku Postgres :: Database as a resource and setting the DATABASE_URL environment ...
0
votes
1answer
31 views

Is it normal my heroku app postgres database and my local time having distinct datetime?

I'm experiencing an issue with a rails app deployed to heroku, actually I don't know if it's totally normal or if there's something wrong. So, I dug a little bit into the web and I found that setting ...
-2
votes
0answers
30 views

Heroku: Getting Started on Heroku with Ruby (Microsoft Windows)

Please help with the following errors on Getting Started on Heroku with Ruby (Microsoft Windows): Push local changes, Provision add-ons, Start a one-off dyno, Use a database Push local changes ...
0
votes
1answer
42 views

heroku deployment of nodejs app - An error occurred in the application and your page could not be served. Please try again in a few moments

I manually deployed an app on heroic (never done it before and just connected it to my github repository). It says deployed successfully but Im getting the error: An error occurred in the application ...
0
votes
1answer
22 views

How to access database on Heroku from Android through RESTful APIs?

I'm trying to learn how to make calls to RESTful Web Services from Android. I wanted to test my app against some free database available online and that's when I came to know about Heroku. I want to ...
-1
votes
1answer
11 views

Ruby on Rails: is it possible to access multi posgtgresql databases of heroku with one app?

I have two Rails apps in Heroku with Postgresql Databases. Noiw i want to access those two databases with one app ony. Is it Possible?
0
votes
0answers
17 views

Pushing local Postgres data to Heroku DB. pg_hba.conf errors

The issue started with trying to push local PostgresSQL data to the remote Heroku DB for a Django project using: heroku pg:push localdbname DATABASE_URL --app herokuappname After dealing with a lot ...
2
votes
1answer
54 views

How can I set logging level for Heroku Postgresql?

Using Heroku with the Postgresql add-on. Upon reviewing my logs, it seems postgresql is logging every ... single ... transaction. I understand you can set the log level by doing something like (...
0
votes
0answers
11 views

Chosen-rails gem scss assets not working on Heroku

I am using chosen-rails gem. Although it works perfectly on localhost,the css codes do not show up when I switched to Heroku. Application.js file looks like this //= require jquery //= require ...
0
votes
1answer
14 views

heroku postgres Group by query on indexed columns takes more than 2 seconds to execute

On heroku postgres my group by query is taking more than 2 seconds, is it normal? How can I optimize this further? Both columns are indexed So I was assuming that it should run faster. The query is, ...
0
votes
0answers
11 views

How do I force my heroku “pg:psql” account to login to my production database?

I’m using Heroku and Rails 4.2.7. I just created a PostGres Basic database in my heroku account … davea$ heroku addons:create heroku-postgresql:hobby-basic Creating heroku-postgresql:hobby-basic on ⬢...
0
votes
1answer
54 views

postgres production database isn't synced with heroku app

I first noticed trouble after I dropped an Active Record table using this migration: class DropDelayedJobTables < ActiveRecord::Migration def change drop_table :delayed_jobs end end ...
0
votes
0answers
13 views

heroku postgres data size vs storage capacity

I am using heroku postgres standard-0 plan which have storage capacity of 64 GB according to their add on page. When I run heroku pg:info I get Data Size: 147.4 GB. That means I have exceeded ...
0
votes
0answers
13 views

Connection Issue - R to Heroku Postgres

I'm trying to connect to my Heroku EC2 instance through R, but am having connection issues. My coworker can connect with the same script, but two others are having the same issues trying to connect ...
1
vote
1answer
69 views

PG::UndefinedColumn: ERROR: column “image_file_name” of relation “articles” does not exist

Can someone please help me with runing heroku run db:migrate? I've forgot to run db:migration on heroku along with migration on dev env. I made coulple of them and now I'm receiving the below error: ...
0
votes
1answer
48 views

Aplication error, undefined symbol: rb_thread_select

i have an RoR application everything was working fine until i deployed to heroku where i get the "Application Error" and on the logs "undefined symbol: rb_thread_select", im using "ruby 2.3.0p0", "...
0
votes
0answers
10 views

error in Heroku pg Push database in rails project

I am trying to push my database (local) to heroku database(Heroku Postgres :: Pink) . i am also trying by the commands of enter image description here there is a wrong password error .but i had ...
1
vote
1answer
14 views

Limiting downtime while importing new tables on Heroku Postgres

We have a few tables with a pretty large number of entries that sometimes need to be re-imported. Only some tables are concerned, so we don't use restore but a command similar to this: heroku pg:psql ...
1
vote
0answers
10 views

Access pg:backups from Heroku Scheduler

I want to send my last heroku postgres backup to S3 to have it stored outside the heroku infrastructure, just in case I click 'delete' on wrong DB. To achieve this I need an URL to the backup. I ...
0
votes
0answers
28 views

Heroku with PgAdmin: How can I add new Maintanance DB using pgadmin?

I can't add a new maintanance db in pgadmin: It only shows postgres, template1, and edb. I want to add a new one. How can I do it? I mean to say that I can not able to connect Heroku db as I am not ...
0
votes
0answers
31 views

importing my database into heroku database

i am trying to import database into heroku . i am creating an app into heroku but its not access by database after migration what can i do? heroku pg:psql --app YOUR_APP_NAME_HERE < updates.sql ...
0
votes
0answers
11 views

heroku pg:pull -e does not exclude given models

Using the following command heroku pg:pull HEROKU_POSTGRESQL_XXXX_URL xxxx_development -e "versions" --app xxxx does not exclude versions model from the pull. This is following the heroku docs. I'...
0
votes
1answer
41 views

Managing connections PostgreSQL and Node.js

I am using Heroku Postgres and every time I run a query in my application the connection remains open. This leads to too many simultaneous connections and hence errors. When in deployment, after I ...
-3
votes
1answer
32 views

Heroku | Need help get java servlet running as home page

I got this App running locally and on Heroku. https://devcenter.heroku.com/articles/create-a-java-web-application-using-embedded-tomcat It simple displays a html file with hello world. I want to ...
0
votes
0answers
37 views

ActiveRecord::ConnectionTimeoutError using Rails 4.0.0, Sidekiq, and Unicorn on Heroku

On Heroku I'm running Rails 4.0.0, Sidekiq, a Standard-0 PG DB plan (with around 20/120 connections used), and Unicorn with this config and a Procfile of: web: bundle exec unicorn -p $PORT -c ./...
0
votes
1answer
37 views

Heroku PostgreSQL BLOB insertion fails

I'm going to deploy my application on Heroku, for this purpose I created a database there. As Hibernate's option hibernate.hbm2ddl.auto=create didn't work I wrote a SQL queries manually. Everything ...
-2
votes
1answer
80 views

Ruby on Rails - how can I open project with postgres?

last day I have get a ruby on rails project. Know my question: How can I open this project (with postgres). More information: My contribution is Windows. Ruby and Rails are both installed. First I ...
1
vote
0answers
23 views

Adding a Worker Dyno Process to Heroku

I'm brand new to Heroku and I'm starting to get H13 errors (timeout) with my app when I upload big files that take more than 30 seconds to process. So, I'm trying to use worker dynos by following ...
0
votes
1answer
46 views

Removing indexes before Update on a live Database

We are working on a live Postgres Database on Heroku. We need to update around 5 million rows using regex replacing multiple strings, which will mean performing potentially around 100 million updates ...
0
votes
1answer
12 views

Heroku date_select issue Rails 4.2.5

I am having an issue with the date_select method in Rails on Heroku. I am using SQLite in my development environment and PG in my production environment. I'm creating an invoice application and I ...
0
votes
0answers
22 views

using Que as a heroku worker

I am using https://github.com/chanks/que I am having problem setting up que in heroku. I have setup web and worker process in heroku and I have these configurations: config/initializers/que.rb Que....
0
votes
0answers
4 views

Consistent Command Buffer in heroku pg:psql

Does anyone have a solution to the inconsistent command buffer with herkou pg:psql on windows? It seems that sometimes when I launch this I have a command buffer and sometimes I don't
0
votes
1answer
171 views

CertificateUnknown error when connecting to Heroku Postgres database

So I am in the middle of migrating from SQL Server to PostgreSQL, and I am building a temporary solution for the migration period to allow my ASP.NET app to connect to my Heroku Postgres database and ...
0
votes
1answer
44 views

Heroku SQLAlchemy database does not exist

I'm running a python 3.5 worker on heroku. self.engine = create_engine(os.environ.get("DATABASE_URL")) My code works on local, passes Travis CI, but gets an error on heroku - OperationalError: (...
0
votes
1answer
125 views

Django deploy on Heroku gives site can't be reached response

I’m having a tough time deploying my django app (v1.9) to heroku (psql 9.5),cedar stack-14. Here’s how I arrived here: I had tremendous migration issues that resulted in “””django.db.utils....
0
votes
1answer
17 views

Django app search not pulling data in Heroku but works locally?

My django app locally works fine, I have a postgres DB and when I run a search it pulls data. I have pushed my DB to Heroku, the data is there, but when I run a search it says 'no results found'. I do ...
0
votes
1answer
170 views

Heroku pg:push psql: FATAL: password authentication failed for user

I know similar questions have been asked but none of the solutions have worked. I am trying to push my local db to my Heroku db, and I keep getting psql: FATAL: password authentication failed for ...
0
votes
0answers
45 views

Dataclip queries on my Heroku database are timing out due to size

I have a PostGRES database on Heroku that is too large to query in DataClips now. Often the queries timeout due to the table size. What should I do so I can run analytical queries on my database ...
0
votes
1answer
36 views

How to restore postgresql db on Heroku

I'm totally new to Heroku and Postgres and I'm trying to figure out how to restore and access the Postgres db in Heroku. I do have backup that taken fro pgAdmin III .backup file. Any help with how to ...
0
votes
1answer
10 views

Heroku gem shows up despite having heroku toolbelt

in my project folder, when I run heroku version, I get heroku-gem/3.32.0 (x86_64-linux) ruby/2.2.0 as one of the items, however in my home folder running the same command returns heroku-toolbelt/3.42....
0
votes
1answer
27 views

Equivalent rest API call for: “heroku pg:credentials DATABASE_URL --app mypgapp”

curl -n -X GET https://api.heroku.com/apps/mypgapp/addons/heroku-postgresql -H "Content-Type: application/json" -H "Accept: application/vnd.heroku+json; version=3" Returns a JSON with reelevant PG ...
0
votes
0answers
26 views

Heroku can not compile Symfony2.7 project

I need your help with a problem using a symfony2.7 upload on heroku. I entered the command git push heroku master this is the error: https://drive.google.com/file/d/0BztswIqNuWoTQjA4enJzelM0dlU/view
1
vote
1answer
63 views

NameError: unitialized constant User for rake db:migrate in Heroku

I just recently deployed my app to Heroku however when I run Heroku run rake db:migrate I get the below errors. NameError: uninitialized constant User /app/vendor/bundle/ruby/2.2.0/gems/...
1
vote
2answers
37 views

How to rotate Heroku Postgres / Redis credentials using the API?

Rotating Postgres and Redis credentials using the Heroku Toolbelt is very easy https://blog.heroku.com/archives/2012/7/17/rotate_database_credentials_on_heroku_postgres_ Ideally, I'd need to do this ...
2
votes
0answers
301 views

Can't Push Rails Project to Heroku

So I've run into a little snag with a rails app that i'm trying to deploy on to Heroku. When I attempt to push my app onto Heroku, I'm told that rake tasks cannot be detected. In addition, I'm ...
0
votes
1answer
372 views

Cant pg_restore on Heroku: “could not read from input file: end of file”

I am trying to copy my local PostgreSQL DB to Heroku app with pg_dump / pg_restore utils. Doing according to Heroku's official guide: https://devcenter.heroku.com/articles/heroku-postgres-import-...

1 2 3 4 5 … 7