we have jasper server runnging with a postgres DB on a amazon RDS system.
Now I would like to backup the DB periodically. (I would like to use the backup for the TEST system which is updated from time to time)
Both systems run with jasper 6.4
Now my question is:
I know there are backup/restore scripts available in "buildomatic" and they are capable of taking over this job. (these are very helpful when migrating from 6.2 to 6.4)
But for me to understand: Would it be sufficient to pg_dump and pg_restore the entire database ? Means all data is kept within the database and nowhere else on the system.