1

I've installed postgrSQL 9.0 successfully and I have separate database file (database.backup). Now I need to add this database into postgreSQL. I am new to this postgreSLQ. I would be much appreciated if anyone please be so kind enough to explain how to do such a thing.

Thanks a lot

Improve this question
3
  • @TimurSadykov I think you chose the wrong link there, it's completely unrelated to this question. Commented Dec 23, 2013 at 23:43
  • i would prefer to use 'completely unrelated' term to question about potatoes for example... :) but anyway, yes, I missed .backup in the question. So it looks worse than before :) a question without any research on the topic. Commented Dec 24, 2013 at 1:32
  • seem like it was pretty easy to miss .backup :)) Commented Dec 24, 2013 at 2:30

1 Answer 1

Reset to default
3

Use PgAdmin-III to restore the DB, or use the pg_restore command, which does the same thing at the command line.

See the PgAdmin-III docs.

I don't use PgAdmin-III, I work from the command line but from memory you need to:

  • Connect PgAdmin-III to the DB
  • Create a blank database
  • Right click on it
  • Choose "Restore...."
  • Pick the ".backup" file
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.