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

by

From the pg_dump documentation:

Examples

To dump a database called mydb into a SQL-script file:

$ pg_dump mydb > db.sql

To reload such a script into a (freshly created) database named newdb:

$ psql -d newdb -f db.sql

To dump a database into a custom-format archive file:

$ pg_dump -Fc mydb > db.dump

To dump a database into a directory-format archive:

$ pg_dump -Fd mydb -f dumpdir

To reload an archive file into a (freshly created) database named newdb:

$ pg_restore -d newdb db.dump

From the pg_restore documentation:

Examples

Assume we have dumped a database called mydb into a custom-format dump file:

$ pg_dump -Fc mydb > db.dump

To drop the database and recreate it from the dump:

$ dropdb mydb
$ pg_restore -C -d postgres db.dump

More Related Contents:

  1. Restore a postgres backup file using the command line?
  2. What to do with null values when modeling and normalizing?
  3. Postgres: INSERT if does not exist already
  4. Truncating all tables in a Postgres database
  5. How can I drop all the tables in a PostgreSQL database?
  6. How to change PostgreSQL user password?
  7. How to get the count of current month Sunday’s in psql?
  8. How to close idle connections in PostgreSQL automatically?
  9. Refresh a materialized view automatically using a rule or notify
  10. postgresql – replace all instances of a string within text field
  11. Is it possible to have autoincrement number without it being an ID?
  12. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  13. PostgreSQL error ‘Could not connect to server: No such file or directory’
  14. Insert if not exists, else return id in postgresql
  15. function returns multiple columns as a single column instead of multiple columns
  16. Sequences not affected by transactions?
  17. Postgres: check if array field contains value?
  18. Dynamic pivot query using PostgreSQL 9.3
  19. PostgreSQL ERROR: canceling statement due to conflict with recovery
  20. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  21. eliminate duplicate array values in postgres
  22. Find Parent Recursively using Query
  23. Is there a way to disable updates/deletes but still allow triggers to perform them?
  24. Error: Column does not exist in postgresql for update [duplicate]
  25. How to see the CREATE VIEW code for a view in PostgreSQL?
  26. PostgreSQL disable more output
  27. PostgreSQL array_agg order
  28. Postgres table column name restrictions?
  29. How do I get min, median and max from my query in postgresql?
  30. Syntax error at end of input in PostgreSQL

Leave a Comment