Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » Tiki with PostgreSQL
 
Thread actions
Print this page
  • Print all pages

    • Tiki with PostgreSQL

    Posted by Vadim posts: 4 Ukraine

    I try to install Wiki with PostgerSQL
    Tiki 1.9RC2, Apache/1.3.29, php 4.3.7, FreeBSD 5.1, PostgreSQL 7.4.2

    There are many errors when I try create database from tiki-1.9-pgsql.sql script.

    I see many errors in SQL script used for DB creating (in file tiki-1.9-mysql.sql):

    ---------------
    PRIMARY KEY ("quizId"," nVersion")
    superfluous space in " nVersion".
    ---------------

    CREATE TABLE `tiki_download` ( <---- syntax error. wrong quotation marks
    ....
    PRIMARY KEY ("`id`")
    KEY `object` (`object`,`userId`,`type`), <---- syntax error
    KEY `userId` (`userId`),
    KEY `type` (`type`),

    KEY `date` (`date`)
    ) "AUTO_INCREMENT"=32;

    -------------
    Where can I get correct script for postgreSQL, please?

    Thank's

    Reads: 1401
    Posted by Vadim posts: 4 Ukraine

    I did it!


    cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/tikiwiki co -d tiki19_psql tikiwiki

    Same errors

    It works fine with mySql, but does not with PostgreSQL.
    It looks like this .sql script tiki-1.10-pgsql.sql was not tested with PostgreSQL

    Any ideas?


    Posted by Vadim posts: 4 Ukraine

    I did it!

    1. cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/tikiwiki co -d tiki19_psql tikiwiki


    Same errors

    It works fine with mySql, but does not with PostgreSQL.
    It looks like this .sql script tiki-1.10-pgsql.sql was not tested with PostgreSQL

    Any ideas?


    Posted by Damian Parker posts: 2881 United Kingdom

    If you want Tiki and Postgres, Checkout the fork called TikiPro at www.tikipro.org they are much more postgres than TikiWiki

    Damian