Re: [SL] Byte sequence error - restoration

[Rolf S. (tokon) <in...@to...>]

David Boyle schrieb:
> ERROR:  invalid byte sequence for encoding "UTF8": 0x8b

It seems your database's encoding is UTF-8, and your backup's is not. If 
you created the target DB manually and didn't specify the charset, it's 
  in UTF-8.
EITHER try to insert

	set client_encoding to sql_ascii;

at the beginning of your backup file if you're in USA, or

	set client_encoding to latin1;

if you're in Europe.
OR create a DB with the charset you need with

	ceatedb -E <charset> <db-name>

 > SQL-Ledger 2.6.22 with Postgresql 8.1
 >
 > Moving to
 > SQL-Ledger 2.8.14 with Postgresql 8.3

I hope you don't try to restore a 2.6.22 backup into a 2.8.14 installation?

Rolf