input file appears to be a text format dump. Please use psql

I take backup using

pg_dump db_production > postgres_db.dump

and then I copy it to localhost using scp.

Now when I import on my local db it gives an error

pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

by using commad line

pg_restore -d db_development postgres_db.dump

Related Posts:

  1. PostgreSQL: Show tables in PostgreSQL
  2. Psql could not connect to server: No such file or directory, 5432 error?
  3. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  4. What is the format for the PostgreSQL connection string / URL?
  5. “use database_name” command in PostgreSQL
  6. Postgresql 9.2 pg_dump version mismatch
  7. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  8. psql: FATAL: Ident authentication failed for user “postgres”
  9. fe_sendauth: no password supplied
  10. How can I drop all the tables in a PostgreSQL database?
  11. How to restart PostgreSQL in Ubuntu 18.04
  12. FATAL: password authentication failed for user “postgres” (postgresql 11 with pgAdmin 4)
  13. Postgresql: Scripting psql execution with password
  14. postgresql duplicate key violates unique constraint
  15. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  16. How to change PostgreSQL user password?
  17. No function matches the given name and argument types
  18. PostgreSQL error: Fatal: role “username” does not exist
  19. How to change PostgreSQL user password?
  20. How to exit from PostgreSQL command line utility: psql
  21. psql: FATAL: database “” does not exist
  22. eroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  23. Permission denied for relation
  24. postgres does not know where to find server configuration
  25. PG COPY error: invalid input syntax for integer
  26. Postgres: INSERT if does not exist already
  27. What’s the default superuser username/password for postgres after a new install?
  28. How to see active connections and “current activity” in PostgreSQL 8.4
  29. pg_dump and pg_restore: input file does not appear to be a valid archive
  30. What is this JavaScript “require”?
  31. What is this JavaScript “require”?
  32. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  33. What is the default password for Postgres
  34. missing FROM-clause entry for table
  35. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  36. Postgresql tables exists, but getting “relation does not exist” when querying
  37. psql: command not found Mac
  38. pg_ctl: no database directory specified and environment variable PGDATA unset
  39. psql: FATAL: role “postgres” does not exist
  40. Postgres Error: More than one row returned by a subquery used as an expression
  41. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  42. PostgreSQL visual interface similar to phpMyAdmin?
  43. GROUP BY and COUNT using ActiveRecord
  44. Does wpdb add considerable overhead on queries with large result sets?
  45. Problem: Create a cron job to export posts to a WordPress XML file on server
  46. How do WordPress veterans deal with the issues of upgrading WordPress?
  47. Import old SQL dump into new WordPress version
  48. What is the most comprehensive backup plugin for WordPress (it does not have to be free)? [closed]
  49. Is It Possible to Restore Accidentally Deleted Widgets?
  50. Faulty restore of the database, encoding issue
  51. Copy site from one multisite to another
  52. WordPress Backup
  53. Backup another database with BackUpWordPress plugin [closed]
  54. Backup blog posts only
  55. How does the WXR file differ from the WPDB?
  56. Managing Backups: Space Issues [closed]
  57. WordPress manual restore not completely successful
  58. What is the correct way to update both WP/plugins/themes without breaking the site?
  59. Edit page’s “Restore the backup” link does nothing
  60. If I backup my wordpress blog, how can I back-up all the external images I’ve embedded?
  61. Delete and perform a fresh install of WordPress
  62. Restore large number of permanently deleted posts
  63. Where is phpMyAdmin inside WordPress?
  64. How can I prevent anyone from logging into a WordPress failover site?
  65. UpdraftPlus installed malware – scared to download or update plugins now! [closed]
  66. How to backup my site and restore my wordpress site
  67. Cannot restore wordpress database from sql dump [closed]
  68. Backing up an old version of WP before upgrading
  69. wordpress database restore – broken link
  70. restore a db after bad backup
  71. WordPress backup(on another server)leading to old server addy and WP
  72. Can I restore a plugin that was accidentally deleted? (on localhost)
  73. Do I need a backup plugin if I’m already backing up via cPanel?
  74. How to remove symlink from folder
  75. How do I passively back-up my WordPress websites on a frequent basis? [closed]
  76. Can an update corrupt my installation?
  77. Migrate site from local to local via a backup
  78. How can i restore a WordPress site with the DB and WordPress Files
  79. Can you Recover a WordPress User from a Backup
  80. wp-config.php not affecting my site
  81. 404 on CSS and JS only on Homepage
  82. Auomated crash recovery?
  83. back up fully Customized WordPress theme [closed]
  84. Restoring from a old local copy of xampp folder where the project was stored
  85. How can I export data without using any import/export plugin
  86. blank page after update my theme
  87. How do I find out from my database what version of WordPress I need?
  88. How to regularly backup and update WordPress website with lot of images?
  89. Zip all (original) images from media gallery
  90. Backed up site on localhost affecting live site
  91. Upgrading from 3.4.2 [duplicate]
  92. Clone wordpress blog on localbox manually
  93. Restoring from a Backup after Update
  94. how to restore wordpress backup(.rar) manually?
  95. GIT as a backup tool
  96. Postgres equivalent to MySQL’s \G?
  97. protocol version mismatch — is your shell clean?
  98. How to keep the full path with rsync?
  99. restore backup full content or just specific folders
  100. How to backup my plugin database [closed]

Leave a Comment