From: Carsten K. <car...@us...> - 2001-12-19 06:22:09
|
Update of /cvsroot/phpwiki/phpwiki/doc In directory usw-pr-cvs1:/tmp/cvs-serv26769/phpwiki/doc Modified Files: INSTALL.pgsql Log Message: troubleshooting tip, note about schema file with latest pgsql Index: INSTALL.pgsql =================================================================== RCS file: /cvsroot/phpwiki/phpwiki/doc/INSTALL.pgsql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -r1.2 -r1.3 *** INSTALL.pgsql 2001/12/03 04:10:38 1.2 --- INSTALL.pgsql 2001/12/19 06:22:06 1.3 *************** *** 1,2 **** --- 1,4 ---- + Note: postgresql does work with phpwiki 1.3. + FIXME: The pgsql backend has not yet been ported to the new database scheme. (Though it should not be very hard, and is certainly in *************** *** 36,39 **** --- 38,43 ---- </IfModule> + FIXME: php4 + (This is from a stock 6.2 Red Hat distro, which ships with an rpm of PHP 3.0.12, but should give you an idea. I had to add the line for *************** *** 59,65 **** bash$ createdb wiki ! Now run the script schemas/psql.sql bash$ psql wiki -f schemas/psql.sql For some reason I had to stop/start the database so that these changes took --- 63,73 ---- bash$ createdb wiki ! Now run the script schemas/psql.sql to create the tables: bash$ psql wiki -f schemas/psql.sql + + (Newer versions of postgresql will require: psql wiki < schemas/psql.sql) + + If the schema starts to load but then fails near the end, you might need to change the user name at the top of psql.sql to match that which is used by your web server; e.g. nobody, apache, or www. For some reason I had to stop/start the database so that these changes took |