Foreman Maintain

Testing backup and restore. If postgres is local, it copies the data dir, otherwise it does a pg_dump. When performing a restore, the restore of the data dir doesn't work correctly. The database is basically empty, and there are some consistency errors (I get errors like "Can't find product "2""). However, I tested doing a pg_dump -c for each database (foreman, candlepin, and pulpcore), and restoring those files worked, the data is there, hammer commands (and ui) shows information. I haven't dug into how the data_dir backup and restore is done to say where the problem might lie.

An option would be to add a parameter specifying a pg_dump, regardless of whether db is local or not.

This ticket could track the fix of this, and possibly the addition of the parameter.