"Fran ..." <Bryan691@xxxxxxxxxxx> writes: > these are some of them: These look to be cascading damage from some earlier failure. I'd advise looking at the first one or two errors and solving them, then repeat as necessary. In general, though, pg_dump of a single database is not a complete representation of where you were: it lacks any information about global objects (roles and tablespaces). I suspect your problems ultimately trace back to not having created the right roles in the target installation before starting the restore. You might find "pg_dumpall -g" to be helpful. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general