Postgresql ReStore Command

Postgresql ReStore Commands

1, In Windows XP, Go to “All Programs” --> “Postgresql” --> “psql”

2, Accept default settings and you will get prompt like “postgres-#”

3, Postgresql has its own utility for Restore called “psql”.

The most common options used are :

1, -d --> database name

2, -U --> user of the database(default is postgres)

3, -f --> backup (*.dmp) file

Syntax : psql [options]

Ex: To restore “archive1.dmp” into a database “mydatabase”,

Run the commands below .

A, create database mydatabase

B, psql –d mydatabase –U postgres –f “E:\archive1.dmp”