Unable to CREATE DATABASE postgresql on Heroku Hobby database

Question

I connected to Heroku postgresql DB (Hobby env): heroku pg:psql --app

The prompt shows : appname::DATABASE=>

Error : appname::DATABASE=> CREATE DATABASE hello ENCODING 'UTF-8';

ERROR: permission denied to create database

Any help regarding this will be appreciated.

RangerRanger · Accepted Answer · 2018-10-14 17:26:23Z

3

Creating a database is disallowed because it's unnecessary. When you provision a Heroku Postgres add-on, the database and user are created on your behalf. You can see the information by running heroku config and checking the database configuration string.

answered Oct 14, 2018 at 17:26

RangerRanger

2,5132 gold badges20 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Unable to CREATE DATABASE postgresql on Heroku Hobby 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