Postgresql won't restore dump

4k Views Asked by At

I've been trying to restore dump file dump-postgres-202010121008.sql but it won't be restored, I've tried the following restoration methods but it seems of no use:

Method1: using pgAdmin 4

I've tried the pg_restore method with the following inputs:

Format: custom or tar

File name: path to the file

Number of jobs: empty

Role name: postgres

When i click restore, i get a Failed(exit code: 1) with the following error message:

pg_restore: error: input file does not appear to be a valid archive

I've also tried Query Tool > open file, still i got an error File type not supported.

Method 2: using command line

I've tried pg_restore command on terminal but it returned pg_restore: error: input file does not appear to be a valid archive

I've also tried the following commands:

su postgres
psql postgres
\i dump-postgres-202010121008.sql

However i got this log:

psql:dump-postgres-202010121008:42473: error: invalid command \��0�8�ӛӣ��X�H6����.�y�:���e�ne��Pc�9x@%"˔U�rV7M=�
psql:dump-postgres-202010121008.sql:42474: error: invalid command \�T����kW:����Һ�-kL
psql:dump-postgres-202010121008.sql:42484: error: invalid command \M�LJ,�ϐ}�c,J�-�)ATo▒�HJ��+w
psql:dump-postgres-202010121008.sql:783003: ERROR:  invalid byte sequence for encoding "UTF8": 0xea 0xab 0x7a

Any help would be appreciated, thank you.

0

There are 0 best solutions below