When restoring a backup using pg_restore error crashes

pg_restore: [archiver] parallel restore is not supported with this archive file format

tar file format.

Why?

Postgresql version 9.3

    1 answer 1

    You are now restoring from the archive and pg_restore does not understand it.

    You need to unzip and then try,

    or when unzipping, run pg_restore

    try this method

    Backup :

     pg_dump -h localhost -p 5432 -U postgres -d mydb | gzip > backup.gz

    Restore :

     gunzip -c backup.gz | psql -h localhost -p 5432 -U postgres -d mydb

    instead of pg_restore you can use psql

    • one
      Thanks It works! - Fitstd