Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at: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

    By 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.

    Advertisement

    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

    Related Posts

    SVN Repository Corruption – SVNREPO/db/current

    The login is invalid – WHM/cPanel

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

    View 3 Comments

    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

    Advertisement
    Recent Posts
    • How to Split Large Archives in Linux using the Command Line
    • System.out.println() Method in Java: A Beginner’s Guide
    • Split Command in Linux With Examples (Split Large Files)
    • Test Your Internet Speed from the Linux Terminal
    • 11 Practical Example of cat Command in Linux
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

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