With postgresql installation, it seems that there is no
way to specify the host nor the port of the database.
It would be nice to be able to set this parameters.
In the CVS I recently coded in support for remotely hosted databases (One of my users trialling the MySQL version wanted to have a remote database).
MySQL is straightforward because it accepts TCP/IP connections by default. On the other hand PostgreSQL needs config changes to accept any host (including localhost) - or you get problems!
I've coded in MySQL, and put in commented-out code (with description) for PostgreSQL. The files to look at are config.php and /includes/pgsql_database.php
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=523452
In the CVS I recently coded in support for remotely hosted databases (One of my users trialling the MySQL version wanted to have a remote database).
MySQL is straightforward because it accepts TCP/IP connections by default. On the other hand PostgreSQL needs config changes to accept any host (including localhost) - or you get problems!
I've coded in MySQL, and put in commented-out code (with description) for PostgreSQL. The files to look at are config.php and /includes/pgsql_database.php