Tuesday, May 15, 2007

Backup and Restore 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...

2 comments:

Gayan Balasooriya said...

Please visit my blog --gayanOnLine-- also.Thank You.

Gayan Balasooriya said...

Hey man I am looking fo a link to my blog

http://gayanonline.blogspot.com