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...