I have a Symfony2 project under Debian. What are the steps to change my database to postgresql ?
Note: The question has been asked here, but it is with symfony 1.4, I believe.
-
If you hope use two connections,just take a look here : stackoverflow.com/questions/8440403/…Nll– Nll2012-05-14 18:50:36 +00:00Commented May 14, 2012 at 18:50
Add a comment
|
1 Answer
Install postgresql under debian:
apt-get install postgresql postgresql-client
apt-get install php5-pgsql
adduser mypguser
su - postgres
psql
CREATE USER mypguser WITH PASSWORD 'mypguserpass';
CREATE DATABASE mypgdatabase;
GRANT ALL PRIVILEGES ON DATABASE mypgdatabase to mypguser;
\q
In /etc/php5/apache2/php.ini, add: (this is in fact optional)
extension=pdo.so
extension=php_pdo_pgsql.so
Change the symfony apps/config/paramters.ini file:
[parameters]
database_driver: pdo_pgsql
database_host: localhost
database_port: null
database_name: mypgdatabase
database_user: mypguser
database_password: mypguserpass
Relaod your project:
php bin/vendors update
php app/console assets:install web
php app/console doctrine:schema:create
php app/console doctrine:fixtures:load
chmod 777 -R app/cache app/logs
You're done!
References:
answered May 14, 2012 at 21:37
Benjamin Crouzier
42.2k48 gold badges179 silver badges240 bronze badges
