Doctrine database create command failing with Postgresql

Question

When in Symfony I am trying to create the database via doctrine:database:create it throws the following exception:

[Doctrine\DBAL\Exception\ConnectionException]                                
 An exception occured in driver: SQLSTATE[08006] [7] FATAL:  database "tm_ootb" does not exist

Am I facing a bug or am I missing something in the configuration.

Here is my dbal config:

dbal:
    driver:   pdo_pgsql
    host:     "%database_host%"
    port:     "%database_port%"
    dbname:   "%database_name%"
    user:     "%database_user%"
    password: "%database_password%"
    charset:  UTF8

Possible duplicate of How to change a database to postgresql with Symfony 2.0? — fpilee
– fpilee, Commented Oct 17, 2015 at 17:50
@FelipeMorales you are far away from my question, I already have Postgres properly installed and configured. — DanielRestrepo
– DanielRestrepo, Commented Oct 22, 2015 at 23:57

DanielRestrepo · Accepted Answer · 2015-10-23 00:13:18Z

0

Turns out that it is a Postgresql's permissions situation. Depending on the user level that you have configured on your parameters you will face this situation.

When connecting to Postgres with the postgres super user account that also owns the administrative data base called postgres, there is no problem at all because it issues the following command:

psql -U postgres

No problem because user and database exist, after that issues the 'createdb' command. But when using any other user that do not owns a data base or is not super user it throws the mention error. There should be a way to avoid such error with Doctrine.

Hopes this was useful for someone else.

edited Oct 23, 2015 at 0:13

answered Oct 23, 2015 at 0:08

DanielRestrepo

1438 bronze badges

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

Collectives™ on Stack Overflow

Doctrine database create command failing with Postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related