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. PostgreSQL “DESCRIBE TABLE”
  33. How to UPSERT (MERGE, INSERT … ON DUPLICATE UPDATE) in PostgreSQL?
  34. How to restart Postgresql
  35. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  36. What is the default password for Postgres
  37. missing FROM-clause entry for table
  38. PostgreSQL: Remotely connecting to Postgres instance using psql command
  39. Simple Random Samples from a Sql database
  40. Insert text with single quotes in PostgreSQL
  41. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  42. Cannot simply use PostgreSQL table name (“relation does not exist”)
  43. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  44. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  45. could not connect to server: No such file or directory (PG::ConnectionBad)
  46. Postgresql tables exists, but getting “relation does not exist” when querying
  47. PG::ConnectionBad: fe_sendauth: no password supplied
  48. “extra data after last expected column” while trying to import a csv file into postgresql
  49. postgresql: error duplicate key value violates unique constraint
  50. psql: command not found Mac
  51. pg_ctl: no database directory specified and environment variable PGDATA unset
  52. psql: FATAL: role “postgres” does not exist
  53. Postgres Error: More than one row returned by a subquery used as an expression
  54. PostgreSQL: Query has no destination for result data
  55. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  56. PostgreSQL create table if not exists
  57. updating table rows in postgres using subquery
  58. Adb backup does not work
  59. PostgreSQL visual interface similar to phpMyAdmin?
  60. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  61. GROUP BY and COUNT using ActiveRecord
  62. Postgresql column reference “id” is ambiguous
  63. How to extract or unpack an .ab file (Android Backup file)
  64. What is a postgres superuser
  65. UpdraftPlus WordPress plugin is not working to store Backup in the Google Drive
  66. What’s the simplest way to backup my WordPress database?
  67. Mysqldump add drop table?
  68. What is a better way to backup files than FTP?
  69. Backup the Database and Restore from the Backup?
  70. Does wpdb add considerable overhead on queries with large result sets?
  71. How to keep a WordPress site synchronized between two servers?
  72. Problem: Create a cron job to export posts to a WordPress XML file on server
  73. How do WordPress veterans deal with the issues of upgrading WordPress?
  74. What is the best method to export local WordPress installation and import to live server?
  75. Plugin for automatic database backup? [closed]
  76. Import old SQL dump into new WordPress version
  77. What is the most comprehensive backup plugin for WordPress (it does not have to be free)? [closed]
  78. Is It Possible to Restore Accidentally Deleted Widgets?
  79. Faulty restore of the database, encoding issue
  80. How to Add Back Buttons to Web Pages [closed]
  81. How to migrate wordpress users from one blog to another
  82. Copy site from one multisite to another
  83. What is the best WordPress plugin for Amazon s3 backups? [closed]
  84. Does WordPress Import/Export tool actually exports media (images) as well?
  85. How to clone and locally run a network for testing
  86. WordPress Backup
  87. How to backup and restore configurations
  88. 403 Forbidden – You don’t have permission to access /wp-admin/admin-ajax.php on this server
  89. Recover from failed multisite conversion
  90. How to change Parent Themes in Child Theme CSS
  91. WordPress and automated MySQL backups to a different host
  92. How to perform WordPress backups using wp-cli?
  93. WordPress Admin Interface not styled properly
  94. Multisite Backup Plugin [closed]
  95. What is the best practice to get a site from local to online?
  96. Backup another database with BackUpWordPress plugin [closed]
  97. Is WooCommerce updates for WordPress necessary? [closed]
  98. Is it possible to create a WordPress backup by simply copying it?
  99. Why isn’t my imported database showing up? install.php pops up and adds new tables to the database
  100. Why are no posts showing despite my apparently correct DB restoration?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)