Saturday, September 29, 2012

Backup/Restore postgresSQL database with pgAdmin

BACKUP

1. Choose database need to backup

image

2. Save to backup file, choose COMPRESS as default

image

The GUI actually calls pg_dump command to do the backup

image

Choose Done to complete. You can see the backup file in selected folder

The backup as COMPRESS, so it cannot be read with text editor

image

If you want the backup is readable, you can choose backup type is PLAIN

image

image

 

RESTORE

1. Create an empty database

2. Choose the created database, and choose Restore

image

3. Select the backup file

image

The GUI actually calls pg_restore command to do the restore

image

4. Click OK to get the task execute. Database is restored to a new one.

No comments:

Post a Comment

Oracle Query