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! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
