########################################################################
# PWiki
# Copyright (C) 1999,2000 John L. Jorgensen
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
########################################################################

As of pwiki-0.9.3, pwiki works with the postgresql database. We reccomend that you use PostgreSQL 7.1beta3 or higher because the tuple size limit has been removed. I believe it used to be 32k which could truncate big pages.

In order to use postgres;
1) Install pwiki as normal
2) ensure that postgres is started on the local machine
3) in the pwiki/sql directory, modify the create user and grant statements
   to the user that runs your web server. By default, it's nobody.
4) run the perl script postgres in the sql directory. This will import
   the templates, the wiki database, and create the admin user.
5) in pwiki/pwikicfg.phl, change $dbtype to "postgres"
6) fire up your wiki!

In order to use mysql;
1) Install pwiki as normal
2) ensure that mysql is started on the local machine
3) in the pwiki/sql directory, modify the grant statement
   to the user that runs your web server. By default, it's nobody.
4) modify the $mysqlBinDir= line in pwiki/sql/mysql
5) run the perl script mysql in the sql directory as root. This will import
   the templates, the wiki database, and create the admin user.
6) in pwiki/pwikicfg.phl, change $dbtype to "mysql"
7) fire up your wiki!

A future version will allow you to use a different host as the database.

