[rt-users] Continous-Login problem after DB move

[Kevin Falcone]

On Tue, Oct 15, 2013 at 11:59:12AM +0200, Robert Waldner wrote:
> > I'm using RT3.8.8 from the Debian packages with postgres on a different
> > machine as a backend. Last night I moved the database from one machine
> > (postgres-8.4) to another (postgres-9.1), and pg_dumpall|psql the whole DB.
> > 
> 
> The solution is to set:
>    bytea_output = 'escape'                 # hex, escape
> in postgresql.conf (default is 'hex').

RT releases of 4.0.0 or later turn this on for you during the database
connection setup.  You were just unlucky enough to be running 3.8.8
(released in 2010) against a much newer database.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131015/e7a8538a/attachment.sig>