How to Recover Postgres DB from the text file redmine.sqlc

Added by Marco Gonçalves over 9 years ago

Hi guys,

I'm quite new on Redmine and Postgres SQL DB.
I made a recovery file from my Postgres DB using the recommended Command listed on the Upgrade Page:

/usr/bin/pg_dump -U <username> -Fc --file=redmine.sqlc <redmine_database>

I need to recover my database from this file. Can anyone tell me how can I make the recovery using this file?
I would appreciate any helpful answer very much.

Replies (1)

RE: How to Recover Postgres DB from the text file redmine.sqlc - Added by Marco Gonçalves over 9 years ago

Finally I found the command.

Don't need help anymore.

If anyone needs help on this the command is:

pq_restore -d <DB NAME> <FILENAME>

(1-1/1)

Project

General

Profile

Redmine