Rich Shepard <rshepard@xxxxxxxxxxxxxxx> writes: > psql -f /var/tmp/backup.sql > I see: > psql: FATAL: database "postgres" does not exist This looks like you are trying to use an 8.1 psql to talk to a 7.4 postmaster. Database "postgres" should exist by default in an 8.1 installation but it would not in 7.4. Better check which postmaster is really running. regards, tom lane