Using symfony with postgresql

I am trying to create a website usi开发者_JS百科ng Symfony and PostgreSQL. I cant find any documentation that shows how to do this. All the documentation assumes the backend db is mySQL.

Anyone knows how to do this?

---

If you are using Doctrine, just use a dsn for pgSQL in your databases.yml, like this :

pgsql:dbname=testdb;host=127.0.0.1

It use the PDO syntax. Check the Doctrine documentation and PDO documentation.

---

Symfony uses 3rd-parties ORMs for DB communication which provide abstraction layer over RDBMS specific architecture. Basically everything you have to do is to change Doctrine's/Propel's driver name, so in /config/databaes.yml set pgsql instead of mysql and you're done.

---

The full answer (took me about an hour to figure this out) is:

1. Modify database.yml as described here (see under Propel or Doctrine)
2. (assuming you're using the Propel ORM like I am) Modify propel.ini as shown below (undocumented AFAIK)

Look for a section in your propel.ini names ;mysql options

comment the mysql options out - otherwise the generated SQL is a mix of postgresql and mysql - which confuses the hell out of psql.