We had a problem with our postgreSQL database server causing us to have to restore a backup of the database. The backup was a simple text pg_dump. When doing a restore using:
psql dbname < dump_file.sql
we ran into problems where one of the tables was not being restored. Further looking into caused us to figure out that the table in question had a some relation, which was being created before the table itself. This caused the "CREATE TABLE" to fail, leaving us without the table. Just moving the "CREATE TABLE" entry before this relation/sequence (dont know the correct word, please advise :) caused the restore to properly happen. The database is back now thankfully.