Hi there,

Newbie to postgresql, I come from an Windows background with Backup Exec and Veritas GUI driven applications, I also have a Centos bacula background.

I now have a Windows Server with postgreSQL database and looking into how to back it up and restore it with Windows command line or pgAdmin III.

I have used the pg_dump dbname > output file, and restore with psql dbname < infile. I have seen the post with pg_dump does not include tablespaces, groups or users and pg_dump only dumps ONE of my databases in a cluster / instance.

I also use the pgAdmin III backup and restore

My questions are:

With the pg_dump are there better commands switches to backup individual databases or the whole sql file / all databases?

Can you schedule the pgAdmin III for nightly backups?

Thanks

TK