HowTo make Wiki history working with Postgres 90 » History » Version 2
Florian Breitwieser, 2011-02-21 17:31
| 1 | 1 | Florian Breitwieser | h1. HowTo make Wiki history working with Postgres 9.0 |
|---|---|---|---|
| 2 | |||
| 3 | 2 | Florian Breitwieser | h2. Problem: |
| 4 | 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: |
||
| 5 | |||
| 6 | <pre> |
||
| 7 | \x68312e204d532050726f63657373696e6720506970656c696e670d0a0d0a68322e2047656e6572616c2073657475700d0a0d0a57696e646f7773206d616368696e657320617474616368656420746f206d61737370656320617265207573656420746f20636f70792066696c657320746f206365727461696e206c6f636174696f6e732e20402f72 |
||
| 8 | |||
| 9 | </pre> |
||
| 10 | Same result for exporting TXT or HTML of the current version, and a Wiki-diff just diffs between two such strings. |
||
| 11 | |||
| 12 | h2. Solution |
||
| 13 | 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: |
| 14 | |||
| 15 | <pre> |
||
| 16 | ALTER DATABASE redmine SET bytea_output TO 'escape'; |
||
| 17 | </pre> |
||
| 18 | |||
| 19 | See also #7677. |