Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009

    Unanswered: Unable to restore backup file.


    I have a taken a backup of database on postgres 8.3.6 installed using exe setup.

    Now we have requirement to use msi setup same version postgres.

    But now some table are not getting restored.

    Error produced at the time of restore is:
    pg_restore: [archiver (db)] COPY failed: ERROR: character 0xc29d of encoding "UTF8" has no equivalent in "WIN1252"

    But the same db is getting restored properly on exe setup of postgres properly..

    Please help...

    Awaiting reply....

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 8
    It seems you have initialized the database cluster with the wrong encoding (Win1252) when using the msi installer (and your original db was initialized using UTF8)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts