"Phoenix Kiula" <phoenix.kiula@xxxxxxxxx> writes: > Then I tried this: > $ pg_restore -h localhost mydb.sql > This tells me: > pg_restore: [archiver] input file does not appear to be a valid archive No, you were right the first time: just feed the dump script to psql. regards, tom lane