How to restore backup postgres database on windows machine

Question

I have tried on terminal:

psql -d test < .\backup_database.sql

At line:1 char:14
+ psql -d test < .\backup_database.sql
+              ~
The '<' operator is reserved for future use.
    + CategoryInfo          : ParserError: (:) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : RedirectionNotSupported

pg_dump command worked seamlessly on terminal. So where do i run psql command. Tried on dbshell-Not working, Manually adding on pgadmin 4 gives pg_restore: error: input file appears to be a text format dump. Please use psql.

user330315 · Accepted Answer · 2021-12-04 12:51:16Z

1

Don't use redirection on Windows, use the -f parameter to pass the file to be run:

psql -d test -f backup_database.sql

answered Dec 4, 2021 at 12:51

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to restore backup postgres database on windows machine

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related