I did the following commands:
pg_dumpall --clean | gzip > db.gz gunzip db.gz psql < db
I expected the third command (loading the database back) to just run with zero errors, but I got some errors:
ERROR: multiple primary keys for table "pga_exception" are not allowed ERROR: multiple primary keys for table "pga_job" are not allowed
There are more errors than those listed, but they are a combination of primary key violations, constraints already existing, and triggers already existing. Why would recreating a database from a backup sql dump produce errors?