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?