N
N
nixoman2014-08-12 21:40:26
PostgreSQL
nixoman, 2014-08-12 21:40:26

How to recover from a dump in PostgreSQL?

How to recover from a dump in PostgreSQL?
Before that, I used MySQL for about a year, but there it’s trite -uroot -ppassword db_name <dump.
The day before yesterday I installed PostreSQL, I'm getting used to it, from the archive without problems, but I couldn't with sql, I tried to run restore and psql through the console in the folder. Tested in windows 7.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
_
_ _, 2014-08-12
@AMar4enko

Well, what's the catch?
psql mydb <dump.sql

N
nixoman, 2014-08-12
@nixoman

I also tried this method from the reference manual of Vasiliev A.Yu.
The catch is that you can't restore it. The database is just a test.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question