Opened 9 years ago

Closed 9 years ago

#24838 closed Uncategorized (invalid)

A warning is logged when running migrate with PostGIS on Heroku

Reported by: Anna Schneider Owned by: nobody
Component: Uncategorized Version: 1.8
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

When upgrading to Django 1.8.1 with PostGIS on Heroku last week, I ran into a similar issue to tickets #24797, #24791, and #24795. So I was excited to see the fix in the 1.8.2 release!

But running 1.8.2 now, I'm still seeing a variant of the problem.

heroku run ./manage.py migrate and heroku run ./manage.py shell work and yield expected results, no errors raised. But a "permission denied" message is present in the logs:

$ heroku logs
2015-05-21T19:03:46.210746+00:00 heroku[api]: Starting process with command `./manage.py migrate` by foo@bar.com
2015-05-21T19:03:57.695048+00:00 heroku[run.9837]: Awaiting client
2015-05-21T19:03:57.736396+00:00 heroku[run.9837]: Starting process with command `./manage.py migrate`
2015-05-21T19:03:58.067165+00:00 heroku[run.9837]: State changed from starting to up
2015-05-21T19:04:02Z app[postgres.2450]: [DATABASE] permission denied for database "postgres"
Detail: User does not have CONNECT privilege.
2015-05-21T19:04:02Z app[postgres.2454]: [DATABASE] extension "postgis" already exists, skipping
2015-05-21T19:04:02Z app[postgres.2454]: [DATABASE] statement: CREATE EXTENSION IF NOT EXISTS postgis
2015-05-21T19:04:05Z app[postgres.2452]: [DATABASE] could not receive data from client: Connection reset by peer
2015-05-21T19:04:06.110871+00:00 heroku[run.9837]: State changed from up to complete
2015-05-21T19:04:06.094695+00:00 heroku[run.9837]: Process exited with status 0

At this point, is it a Django or Heroku issue? Heroku was unhelpful when I raised the issue with them previously, but I'd happily try again if the Django community deems this resolved on their side.

Change History (1)

comment:1 by Tim Graham, 9 years ago

Resolution: invalid
Status: newclosed
Summary: Cannot run migrate with PostGIS on Heroku -- Django 1.8.2A warning is logged when running migrate with PostGIS on Heroku

Yes, we added a fallback solution so that Django tries to connect to the 'postgres' database first and if that's unsuccessful, we connect to the regular database. So the logged warning is expected.

Note: See TracTickets for help on using tickets.
Back to Top