Heroku Postgres Database

Question

I'm completely confuse about Heroku Postgres Plan. Please help.

When I check for PG info, using:

heroku pg:info

It's showing:

=== HEROKU_POSTGRESQL_BRONZE_URL
Plan:        Basic
Status:      available
Connections: 1
PG Version:  9.2.4
Created:     2013-07-30 12:44 UTC
Data Size:   6.3 MB
Tables:      0
Fork/Follow: Unsupported

=== HEROKU_POSTGRESQL_MAROON_URL (DATABASE_URL)
Plan:        Dev
Status:      available
Connections: 4
PG Version:  9.2.4
Created:     2013-08-06 05:17 UTC
Data Size:   10.7 MB
Tables:      13
Rows:        22346/10000 (Write access revoked)
Fork/Follow: Unsupported

Here showing HEROKU_POSTGRESQL_MAROON(free) have 13 tables. But in Paid database there is no table. Isn't it means paid database is not working?

I don't want to use that free database. Please help me to find a way to inset data into my paid database not into free.

I also tried by deleting free database from heroku database console. But then it shows application error.

Pierre-Louis Gottfrois · Accepted Answer · 2013-08-15 10:31:55Z

1

You need to "promote" the database you want to use.

heroku pg:promote HEROKU_POSTGRESQL_BRONZE_URL

This will set the DATABASE_URL to the corresponding database.

More info here

answered Aug 15, 2013 at 10:31

Pierre-Louis Gottfrois

17.6k9 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Heroku Postgres Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related