CODEWITHSUNDEEP
postgresqlunicodeencodingutf-8
HackoNe Naani
HackoNe Naani

Reputation: 1

Restore old PostgreSQL 8.0 unicode dump to PostgreSQL 8.4

I have an old backup of a PostgreSQL 8.0 database. PostgreSQL 8.0 has Unicode and plain backup options, and I used Unicode.

I tried to restore my backup using PostgreSQL 8.4 , which does not use Unicode format for backups. Rather, version 8.4 has UTF-8 backup encoding. When I restored the backup using version 8.4 it was restored, with some errors reported while restoring. But I found that some data was missing while I was checking the restore with my application.

Is there a way to restore data from an old Unicode format backup to UTF-8 format in PostgreSQL 8.4 without data loss?

Upvotes: 0

Views: 184

Answers (1)

hagello
hagello

Reputation: 3255

The PostgreSQL developers have chosen to misuse the term Unicode for UTF-8. Or, as you can see on http://www.postgresql.org/docs/8.4/static/multibyte.html, UNICODE is an alias for UTF-8 in PostgreSQL.

So if all your assumptions are right, you try to restore UTF-8 as UTF-8.

I guess there is another problem anywhere.

Upvotes: 1

Related Questions