Wrong Encoding on Restoring?


#1

Hi, i begin to use this tool and i have one problem restoring backups, maybe is a misconfiguration of my side but i can’t find where change the configuration.
I have one database on PostgreSQL with LATIN1 encoding.
In the backup task i don’t add extra commands on Output SQL Options and the generated SQL have:


– PostgreSQL database dump

– Dumped from database version 9.2.23
– Dumped by pg_dump version 11.1

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = ‘LATIN1’;

but when i restore the database the encoding changes to UTF8.
I need that the restored database have the same encoding (LATIN1) that the original one.
How i may achieve that?
Regards.


#2

Hi SB1,

Thank you for your reply.

Yes, this is a known issue, and we’ll fix it in the future. Currently, if you need to restore with another encoding, then please do it manually.

Sorry for the inconvenience.