Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Work with PostgreSQL?

edited October 2011 in Vanilla 2.0 - 2.8
What's required, if anything, to get Vanilla working with PostgreSQL?


  • Options
    x00x00 MVP
    edited October 2011
    It is not something that is supported but you could hack away.

    You will probably have to create PostgreSQL driver and structure classes, in library/database. it it not for the faint hearted. It is based largely on code igniter. This might be not a lot different than mysql really, if almost identical.

    then you have the following configuration options to set:

    $Configuration['Database']['Engine'] = 'MySQL'; $Configuration['Database']['Host'] = 'dbhost'; $Configuration['Database']['Name'] = 'dbname'; $Configuration['Database']['User'] = 'dbuser'; $Configuration['Database']['Password'] = ''; $Configuration['Database']['ConnectionOptions'] = array( PDO::ATTR_PERSISTENT => FALSE, 1000 => TRUE, // PDO::MYSQL_ATTR_USE_BUFFERED_QUERY is missing in some php installations 1002 => "set names 'utf8'" // PDO::MYSQL_ATTR_INIT_COMMAND is missing in PHP 5.3, so I use the actual value "1002" instead ); $Configuration['Database']['CharacterEncoding'] = 'utf8'; $Configuration['Database']['DatabasePrefix'] = 'GDN_'; $Configuration['Database']['ExtendedProperties']['Collate'] = 'utf8_unicode_ci';

    It depend how up for it you are

    grep is your friend.

Sign In or Register to comment.