HowTo make Wiki history working with Postgres 90 » History » Version 4

Florian Breitwieser, 2011-02-21 17:31

1 1 Florian Breitwieser
h1. HowTo make Wiki history working with Postgres 9.0
2 1 Florian Breitwieser
3 3 Florian Breitwieser
h2. Problem
4 3 Florian Breitwieser
5 2 Florian Breitwieser
When accessing the history version of a Wiki page (e.g. Wiki?version=16), just a string which is not human readable is displayed. It starts like this and is about 5000 characters long:
6 2 Florian Breitwieser
7 2 Florian Breitwieser
<pre>
8 4 Florian Breitwieser
\x68312e204d532050726f63657373696e6720506970656 ...
9 2 Florian Breitwieser
10 2 Florian Breitwieser
</pre>
11 2 Florian Breitwieser
Same result for exporting TXT or HTML of the current version, and a Wiki-diff just diffs between two such strings.
12 2 Florian Breitwieser
13 1 Florian Breitwieser
h2. Solution
14 3 Florian Breitwieser
15 1 Florian Breitwieser
PostgreSQL 9 introduced a new 'hex' format for bytea data input and output. Default for output is now hex, but it can be easily reverted to the old 'escape' format with the following command:
16 1 Florian Breitwieser
17 1 Florian Breitwieser
<pre>
18 1 Florian Breitwieser
ALTER DATABASE redmine SET bytea_output TO 'escape';
19 1 Florian Breitwieser
</pre>
20 1 Florian Breitwieser
21 1 Florian Breitwieser
See also #7677.