I am having problems connecting to the PostgreSQL server.
Following the Definitive guide, inside the yiic shell, I receive the following error:
>> model testuser
exception 'CDbException' with message 'CDbConnection failed to open the DB connection: SQLSTATE[08006] [7] FATAL: Ident authentication failed for user "jmolins"' in /var/www/html/yii/framework/db/CDbConnection.php:233
Depending on the configuration in postgresql.conf, the hostname and port should not be included in the connection string.
you should try to leave the host= and port= parts out of the connection string. This sounds strange, but this is an "option" of Postgre. If you have not activated the TCP/IP port in postgresql.conf then postgresql doesn't accept any incoming requests from an TCP/IP port. If you use host= in your connection string you are going to connect to Postgre via TCP/IP, so that's not going to work. If you leave the host= part out of your connection string you connect to Postgre via the Unix domain sockets, which is faster and more secure, but you can't connect with the database via any other PC as the localhost.