From: | Frank Heikens <frankheikens(at)mac(dot)com> |
---|---|
To: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: bytea_output default value change in 9.0 breaks Apache::Session::Postgres |
Date: | 2010-10-05 18:22:28 |
Message-ID: | BEDD02CA-A662-48B6-82E5-E1F924C08724@mac.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Op 5 okt 2010, om 20:12 heeft Rajesh Kumar Mallah het volgende
geschreven:
> Dear List ,
>
> recent change of bytea_output format from escape to hex in 9.0
> apparently breaks
> popular persistent session handling perl modules like
> Apache::Session::Postgres
> which stores pickled data structures in bytea columns of db table.
> It is difficult to guess the root cause from the exception thrown by
> the said module.
> The problem is fixed by adding
> bytea_output='escape' in postgresql.conf
> and issuing a pg_ctl reload.
>
You can set this per database, using SQL:
ALTER DATABASE dbname SET bytea_output TO 'escape';
>
> Eg in RT application the error is:
> error: RT couldn't store your session.
> This may mean that that the directory /blah/blah/foo/bar isn't
> writable or a database table is missing or corrupt
>
> Regds
> Rajesh Kumar Mallah.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
Regards,
Frank Heikens
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2010-10-05 18:23:27 | Re: Problem installing 9.0.1 on Windows 7 x64 |
Previous Message | Vick Khera | 2010-10-05 18:16:08 | Re: Need the binary of PG9.0 for Windows 32bit |