I have a postgres database on a remote server , and it is a 8.4 version.
I store pictures in a bytea field, and everything work fine.
I recently moved to another server, so I pgdumped the database, and imported it in the new server
the server is a 9.6 postgres version, it is first sight the only difference.
and my bytea field are wrongly stored !
I encodehex the picture before saving, the program is strictly the same, and the bytes stored in the database are not the same, and so unreadable back.
any hint ?
edit: there is only one user, and the rights are good. if I try to write to another field in the same table, I can do it.
edit2: changed 9.4 to 8.4