Facebook Twitter Instagram
    TecAdmin
    • Home
    • Ubuntu 20.04
      • Upgrade Ubuntu
      • Install Java
      • Install Node.js
      • Install Docker
      • Install LAMP Stack
    • Tutorials
      • AWS
      • Shell Scripting
      • Docker
      • Git
      • MongoDB
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    Home»Issues»pg_restore: [archiver] input file does not appear to be a valid archive

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

    RahulBy RahulJuly 26, 20131 Min Read

    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.

    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp
    Previous ArticleHow to Install Apache CouchDB on CentOS/RHEL 7/6
    Next Article MySQL Dump/Restore Stored Procedures and Triggers

    Related Posts

    SVN Repository Corruption – SVNREPO/db/current

    2 Mins Read

    The login is invalid – WHM/cPanel

    1 Min Read

    ERROR: Site example.com does not exists! – Apache a2ensite command

    Updated:October 7, 20191 Min Read

    Error installing mysql2 Gem on Linux

    2 Mins Read

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    1 Min Read

    CHECK_NRPE: Error – Could not complete SSL handshake.

    1 Min Read

    3 Comments

    1. OM At Work on July 25, 2021 5:32 am

      Why do you assume it is in Linux? What if this problem is coming on Windows? “cat” is not a Windows command.

      Reply
      • RandomPersonThatTalksCraps on February 14, 2022 7:38 am

        if you are developer most of us are working on linux so its majority fix

        Reply
        • Anon on April 23, 2022 9:42 am

          Nice retarded logic
          and ofc nice bait titled blog posting

          Reply

    Leave A Reply Cancel Reply

    Recent Posts
    • How to Install Sublime Text 4 on Ubuntu 22.04
    • How to Enable / disable Firewall in Windows
    • How to Install JAVA on Ubuntu 22.04
    • Switching Display Manager in Ubuntu – GDM, LightDM & SDDM
    • Changing the Login Screen Background in Ubuntu 22.04 & 20.04
    Facebook Twitter Instagram Pinterest
    © 2022 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.