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.
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.