Symfony2 and postgresql

Question

I want to create a project using symfony2 with postgresql, but when I run the command: php app/console doctrine:database:create I got the error: Could create database named "test", could not find driver, I know It has something with drivers but I made sure wampserver load php_pdo_pgsql, this is my parameters.yml file:

database_driver: pdo_pgsql
database_host: 127.0.0.1
database_port: 5432
database_name: test
database_user: postgres
database_password: openpgpwd
mailer_transport: smtp
mailer_host: 127.0.0.1
mailer_user: null
mailer_password: null
locale: en
secret: eb10e110d2a3c3f3f5df66181eb10376109f
database_path: null

Do you find an entry for pqsql in your phpinfo() output?

Emii Khaos
– Emii Khaos

2013-08-20 17:11:40 +00:00
Commented Aug 20, 2013 at 17:11 — Emii Khaos
– Emii Khaos, Commented Aug 20, 2013 at 17:11
yea I do find both pdo_pgsql and pgsql

jsf
– jsf

2013-08-20 22:42:06 +00:00
Commented Aug 20, 2013 at 22:42 — jsf
– jsf, Commented Aug 20, 2013 at 22:42

Todor Todorov · Accepted Answer · 2015-07-31 05:58:37Z

2

Try this. Tested on Symfony 2.7. In parameters.yml the database_driver does not work. To make postgre work with Symfony, in config.yml find

doctrine:
  dbal:
    driver:   pdo_mysql

And change it to

doctrine:
  dbal:
    driver:   pdo_pgsql

That should do the trick. You can get rid of database_driver in parameters.yml or use it as you change pdo_mysql to %database_driver% . There is no need to tell that the php postgresql module is necessary.

answered Jul 31, 2015 at 5:58

Todor Todorov

2,5391 gold badge18 silver badges15 bronze badges

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

Comments

user3203627 · Accepted Answer · 2014-01-16 17:27:55Z

0

I had the same problem, I solved it by installing php-pgsql

answered Jan 16, 2014 at 17:27

user3203627

1

1 Comment

Snopzer Over a year ago

Which Driver you have Selected while installing.?

Collectives™ on Stack Overflow

Symfony2 and postgresql

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related