[eluser]OverZealous[/eluser] @NachoF
This will have nothing to do with DMZ. I use DMZ with PostgreSQL almost exclusively.
Most likely you have PGSQL misconfigured for accepting IP connections. Make sure you have TCP enabled, make sure your pg_hba file is set up correctly, double-check your port, etc.
Again, DMZ doesn't do anything special to connect to the databasem it's all CodeIgniter there. You'll want to ask about this on a different forum if my suggestions below don't help.
Quote:I wish it could at least give me some kind of error
That's because CodeIgniter suppresses DB connection errors for some odd reason. Edit the postgre_driver.php file and remove the @ from before pg_connect and pg_pconnect. Then you'll see connection errors.
That stupid @ caused me no end of headaches when I thought my DB was timing out, and it was actually an intermittent DNS issue.
Finally, if this is a production environment with more than a handful of users, I recommend looking into PGPOOL-II, which takes about 10 minutes to set up, and then don't use pconnect, because you will have issues on busy servers. DMZ 1.7.0 (which is basically done, I just need to update the docs, package it, and release it) has some tricks in place to really help cut down on the number of DB connections.
