Symfony 3 project with PostgreSQL as DB

Question

I am setting up my Symfony 3 project (using Netbeans IDE) and want to use PostgreSQL as my database instead of MySQL. After some time online I have found a few potential solutions (one of which is mentioned here but this one does not seem to work for me). So:

My symfony 3 project is running on the local MAMP server
PostgreSQL server is running on the local machine as well
I have setup my parameters.yml file as per below:

- database_driver: pdo_pgsql
- database_host: localhost
- database_port: 5432
- database_name: mypgdatabase
- database_user: mypguser
- database_password:  mypguserpass

The error that i am getting when generating entities is:

[Doctrine\DBAL\Exception\DriverException]

An exception occurred in driver: could not find driver

[Doctrine\DBAL\Driver\PDOException]

could not find driver

[PDOException] could not find driver

Been trying to figure this one out for a few days now so any help will he highly appreciated.

Do you have PHP’s PDO pgsql module installed ?

greg
– greg

2016-06-16 14:27:26 +00:00
Commented Jun 16, 2016 at 14:27 — greg
– greg, Commented Jun 16, 2016 at 14:27
Not sure, how would i check for that?

Sky21.86
– Sky21.86

2016-06-16 14:42:17 +00:00
Commented Jun 16, 2016 at 14:42 — Sky21.86
– Sky21.86, Commented Jun 16, 2016 at 14:42

Alvin Bunk · Accepted Answer · 2016-06-16 15:45:59Z

1

Have you checked in your "php.ini" file that you have this:

extension=pdo.so
extension=php_pdo_pgsql.so

The php.ini file location might depend on which operating system you are using, if it's a mac run:

$ locate php.ini

answered Jun 16, 2016 at 15:45

Alvin Bunk

7,8023 gold badges31 silver badges48 bronze badges

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

4 Comments

Sky21.86 Over a year ago

Thanks Alvin Bunk, i am using mama server on OS X and non of the above is in my php.ini file. Next question is who do i get those extantions installed. the one that i do have tho is ;extension=php_pdo_pgsql.dll however it is commented out and extension=pdo.so is missing as such.

Alvin Bunk Over a year ago

Try uncommenting ;extension=php_pdo_pgsql.dll (remove the semicolon) and see what happens. You might need to restart Apache.

Sky21.86 Over a year ago

uncommented and restarted MAMP, getting these errors now: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/no-debug-non-zts-20121212/php_pdo_pgsql.dll' - dlopen(/usr/lib/php/extensions/no-debug-non-zts-20121212/php_pdo_pgsql.dll, 9): image not found in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/no-debug-non-zts-20121212/php_pgsql.dll' - dlopen(/usr/lib/php/extensions/no-debug-non-zts-20121212/php_pgsql.dll, 9): image not found in Unknown on line 0

Alvin Bunk Over a year ago

You might have to install PostgreSQL support for PHP. Take a look at this question and the answer in particular. My original answer is correct though, and you should mark it as the correct answer. You need to figure out how to enable the php_pdo_pgsql.so module.

user2182349 · Accepted Answer · 2016-06-17 05:24:27Z

1

This is an easy way to check for PHP modules

php -m | grep 'pdo\|pgsql'

It looks like you need both PDO_pgsql and pgsql

answered Jun 17, 2016 at 5:24

user2182349

9,8323 gold badges31 silver badges44 bronze badges

Collectives™ on Stack Overflow

Symfony 3 project with PostgreSQL as DB

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related