Here is some further data. I proceeded as before and I dumped the database to my_database_bkup. I broke the my_database_bkup file into 6 seperate files: load.1, load.2, load.3, load.4, load.5, and load.6.
The file load.1 has all the CREATE FUNCTION commands. The file load.2 has all the CREATE SEQUENCE and CREATE TABLE commands. The file load.3 has all the COPY commands. The file load.4 has all the index creation commands. File load.5 has all the CREATE CONSTRAINT TRIGGER commands. The remaining file load.6 has the CREATE RULE commands. With the exception of load.1 and load.2, which are reversed, this is the same order that the output appears in the dump file.
Loading load.1 through load.5 went fine with no errors. However, loading load.6 produced a number of errors. For example:
psql:load.6:9:ERROR: select rules target entry 7 has different size from attribute read_permission_p
This rule is called _RETgeneral_permissions_grid. Does anyone understand what is happening here?
