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?


  • 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.