I created a database dumb using pg_dump on Postgres 8.3.6. After that I tried to import the same database into a Postgres 9.0 install. Everything worked fine except some image blobs. Some of them seem to be corrupt.
OS: Mac OS X Server 10.5.8. The same issue happened on Mac OS X client 10.6.6.
I downloaded the Postgres 9 version taken from Enterprise DB. I also tried the one from http://www.postgresqlformac.com/ since my initial database was created in Postgres 8 downloaded from there. I had the same issue.
In some forums, it was mentioned that I needed to set bytea_output = 'escape' in the config file. Which I did with no luck even after deleting and importing the DB again.
pgsql-general by date
|Next:||From: Álvaro Plata||Date: 2011-02-28 12:22:14|
|Subject: NullPointerException when making a getCapabilities request|
|Previous:||From: Michael Harris||Date: 2011-02-28 06:27:08|
|Subject: Re: ERROR: missing chunk number 0 for toast value
382548694 in pg_toast_847386|