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

Florian Breitwieser, 2011-02-21 17:28

1 1 Florian Breitwieser
h1. HowTo make Wiki history working with Postgres 9.0
2 1 Florian Breitwieser
3 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:
4 1 Florian Breitwieser
5 1 Florian Breitwieser
<pre>
6 1 Florian Breitwieser
ALTER DATABASE redmine SET bytea_output TO 'escape';
7 1 Florian Breitwieser
</pre>
8 1 Florian Breitwieser
9 1 Florian Breitwieser
See also #7677.