We're backing up our database using pg_dump with compression. We're
selecting each database however when we tried running a pg_restore
everything cept for the roles were restored.
I'm digging through the pg_restore options, Is there an option I'm
forgetting to include?
Also we're restoring from an 8.3.8 database to a 9.0 database. Not sure
if that's part of our problem.
Digging through the docs we're doing 'pg_restore -C -d postgres data.dmp'
Am I missing something?
Thanks!