[imp] IMP and PostgreSQL

[Marc G. Fournier]

On Tue, 3 Dec 2002, Mike DiChiappari wrote:

> Hi,
>
> I just got IMP 3.1 running on RedHat 8.0.  I am not sure how to set
> things up for PostgreSQL.  In particular, what should be placed into
> horde.php.  The following are present for MySQL:
>
>    // use MySQL to store Horde Stuff
>    $conf['prefs']['driver'] = 'sql';
>    $conf['prefs']['params']['phptype'] = 'mysql';
>    $conf['prefs']['params']['hostspec'] = 'localhost';
>    $conf['prefs']['params']['username'] = 'horde';
>    $conf['prefs']['params']['password'] = '';
>    $conf['prefs']['params']['database'] = 'horde';
>    $conf['prefs']['params']['table'] = 'horde_prefs';
>
> I have created the tables in PostgrSQL and the db is running.  I'm
> just not sure what to set in the above config file.

change mysql -> pgsql, and there needs to be a port line added:

$conf['prefs']['params']['port'] = '5432';