Jan Chrillesen <jan@chrillesen.dk> writes:
> I'm running 7.0.3 and want to upgrade to 7.1.1, but running pg_dumpall
> only dumps template1. Also psql -l only lists template1 - the same with
> \l
Hm. The most common reason for this sort of breakage is that you
deleted the users who owned databases, tables, etc --- pg_dump gets
confused when you do that. Look at the owner columns (datdba in
pg_database, relowner in pg_class, etc) and make sure you have pg_shadow
entries with matching usesysid values.
regards, tom lane