CODEWITHSUNDEEP
heroku-postgres
Rahul Saxena
Rahul Saxena

Reputation: 41

Unable to CREATE DATABASE postgresql on Heroku Hobby database

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.

Upvotes: 4

Views: 2075

Answers (1)

RangerRanger
RangerRanger

Reputation: 2493

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.

Upvotes: 3

Related Questions