The following issue has been CLOSED ====================================================================== http://dbmail.org/mantis/view.php?id=953 ====================================================================== Reported By: cmayo Assigned To: ====================================================================== Project: DBMail Issue ID: 953 Category: Database layer Reproducibility: have not tried Severity: tweak Priority: normal Status: closed target: Resolution: no change required Fixed in Version: ====================================================================== Date Submitted: 23-Dec-11 16:44 CET Last Modified: 01-Jan-12 12:26 CET ====================================================================== Summary: Make PostgreSQL 9 users aware bytea format can be per database Description: Update to INSTALL states PostgreSQL 9 users must set bytea_output = 'escape' in postgresql.conf http://git.dbmail.eu/paul/dbmail/diff/INSTALL?id=cee2f2e9608b5866bb7cac01448d72718a8bc6ca
I believe this can also be done just for the dbmail database with: ALTER DATABASE dbmail SET bytea_output='escape'; which would probably be preferable for people with other databases on their server. Doesn't look like it exists in pre 9.0 PostgreSQL though so maybe not a good candidate for the database schema itself yet. Good to have the update to INSTALL - I had thought this was just needed during dbmail upgrade. ====================================================================== ---------------------------------------------------------------------- (0003382) paul (administrator) - 01-Jan-12 12:26 http://dbmail.org/mantis/view.php?id=953#c3382 ---------------------------------------------------------------------- The 'alter database...' statement is not valid for postgresql < 9. I'm closing this report for that reason. Issue History Date Modified Username Field Change ====================================================================== 23-Dec-11 16:44 cmayo New Issue 01-Jan-12 12:26 paul Note Added: 0003382 01-Jan-12 12:26 paul Status new => closed 01-Jan-12 12:26 paul Resolution open => no change required ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
