On Wed, Aug 27, 2008 at 10:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> For pg_dumpall, you shouldn't even have created the
> databases, just start from a virgin installation.
Should I have CREATEd the db at least without the table structure?
I dropped the database locally. Entirely. Gone.
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
What gives?