Backup and Restore PostgreSQL Database

There are three approaches to backing up Postgresql database..

1.SQL dump
2.File system level backups
3.On-line backups

1.SQL dump

First log as postgres user..

#su - postgres or su -l postgres

After that you have issue these ..

#pg_dump dname > dump_name

"dname" is the database name,you are going to backup.

"dump_name" is dump name.

2.File system level backups
3.On-line backups

comming soon...