pg_restore: [archiver] input file does not appear to be a valid archive

Channel: Linux
Abstract: I hope it will help you.mydb # cat backup-db.txt | psql mydb
Linux . I-have-deleted-a-user-Now-ISPConfig-2-does-not-let-me-create-a-new-user-with-the-same-user-name
Linux . File-Encryption-using-GPG-Key-Pair-in-Linux
Linux . File-Encryption-using-GPG-Command-Line-in-Linux

If you are getting above error while restoring backup of database in postgresql. This error means you have taken backup in plain text format.

Error:

pg_restore: [archiver] input file does not appear to be a valid archive

Solution:

To restore plain text backup using below command.

Backup filename: backup-db.txt
Database name: mydb

# cat backup-db.txt | psql mydb

I hope it will help you.

Ref From： tecadmin

Related articles

ERROR-Site-examplecom-does-not-exists!---Apache-a2ensite-command
How-to-create-a-DynamoDB-table-on-AWS-using-Terraform
How-To-Virtualize-A-Physical-Linux-Machine
How-to-Deploy-a-Multi-Tier-Application-with-Kubernetes
How-To-Create-a-Sudo-User-On-CentOS-Ubuntu--Debian
How-to-Fix-Repository-does-not-have-a-release-file-Error-in-Ubuntu
How-to-copy-a-folder-from-remote-to-local-using-SCP
How-to-Copy-a-File-to-Multiple-Directories-in-Linux