Newbie to postgresql, I come from an Windows background with Backup Exec and Veritas GUI driven applications, I also have a Centos bacula background.
If this is in the wrong forum, please move.
I have a Windows Server with a 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?