1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
NOTE: postgresql does work with phpwiki 1.2.x and 1.3.x
You might want to see http://www.sslug.dk/~chlor/phpwiki-pgsql-install.html
for notes how to install it for 1.3.4 (and later)
UPGRADE FROM 1.3.11 to 1.3.12
tsearch2 is mandatory now.
stored procedures and referential integrity was added.
auto-incrementing indices were added (SERIAL INDEX)
The user table is deprecated now, pref is enough.
There's a special upgrade script:
bash$ psql phpwiki < /usr/share/postgresql/contrib/tsearch2.sql
bash$ pgql phpwiki < schemas/psql-1_3_12.sql
----------
NOTE for the 1.2 release: You may see a few warnings when you first
load the pages. They may look like this:
***
Warning: PostgresSQL query failed: ERROR: ExecAppend: Fail to add null
value in not null attribute pagename in lib/pgsql.php on line 417
Inserting page ConvertSpacesToTabs, version 1 from text file
***
This is not a problem since PhpWiki is trying to update a table that
tracks hits and links.
----------
Installation instructions for PhpWiki with a Postgresql database
Installation of Postgresql will not be discussed here... you can get a
copy from http://www.postgresql.org/. However if you are running
Red Hat Linux, all you need to do is install the PHP RPM and the
Postgresql RPM and edit your Apache httpd.conf file, and uncomment
the lines for all PHP files.
And BTW. add index.php to the list of directory files while you're
at it... you may also need to add .php as a type handled by mod_php:
<IfModule mod_php3.c>
AddType application/x-httpd-php3 .php3
AddType application/x-httpd-php3 .php
AddType application/x-httpd-php3-source .phps
</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
.php).
Also note that Postgresql by default has a hard limit of 8K per
row. This is a Really Bad Thing. You can change that when you compile
Postgresql to allow 32K per row, but supposedly performance
suffers. The 7.x release of Postgresql is supposed to fix this.
It's probably a good idea to install PhpWiki as-is first, running it
off DATABASE_TYPE=dba, a single DBM file. This way you can test most
of the functionality of the Wiki.
Once that's done and you have the basic stuff done that's listed in
the INSTALL, the time comes to move to Postgresql.
Edit config.ini for Postgresql. The lines are clearly commented and
you should have no problem with this.
Next you need to create a new database, like "phpwiki".
bash$ createdb phpwiki
Now run the script schemas/psql-initialize.sql to create the tables:
bash$ psql phpwiki -f schemas/psql-initialize.sql
Newer versions of postgresql will require:
bash$ pgql phpwiki < schemas/psql-initialize.sql
Since phpwiki-1.3.12 you'll need to initialize the tsearch2 module before.
You may want to manually inspect schemas/psql-initialize.sql and add
dictionaries and stopword lists for your language.
See http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
bash$ psql phpwiki < /usr/share/postgresql/contrib/tsearch2.sql
bash$ pgql phpwiki < schemas/psql-initialize.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-initialize.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
effect.. after that just open up the Wiki in your browser and you should
have a brand-new PhpWiki running!
If you find something I missed, please let us know.
Reini Urban, Steve Wainstead <swain@panix.com>
Report bugs to phpwiki-talk@lists.sourceforge.net
$Id: INSTALL.pgsql,v 1.7 2005/11/21 20:50:26 rurban Exp $
|
