How to Backup Postgresql

[taneujin]

Hi, I have postgresql running on RH7.2 I would like to know how I can do backups in the following ways:

1) A dump to a file

2) Using arcserve 7.

I am a very new to Arcserve and DBs. Pardon my ignorance.

 

[roycrom]

Postgresql can do dumps itself using the following -

pg_dump -f dumpfile databasename

you should do this as your postgres super user.

you may have to specify the host and port which you can do with the options -h and -p respectively

Not too sure about arcserve as I've never used that.