Forum OpenACS Q&A: Re: OpenACS 4.6.3 restore problem on Postgres7.2

Collapse
Posted by Torben Brosten on

I had a 7.2 pg db with sql_ascii encoding that didn't import very well because it contained many characters that were not part of the sql_ascii set. Maybe there's one or more case creating silent errors during import?

check the original db dump with:

iconv -t ascii db_filename > db_test

It should error if there's anything it cannot convert. You could try 'iconv -c' on the dump for good measure, if you decide to import one more time..