Re: Dumping/Restoring with constraints? - Mailing list pgsql-general

From Tom Lane
Subject Re: Dumping/Restoring with constraints?
Date
Msg-id 23743.1219848802@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dumping/Restoring with constraints?  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: Dumping/Restoring with constraints?
List pgsql-general
"Phoenix Kiula" <phoenix.kiula@gmail.com> 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

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Re: Dumping/Restoring with constraints?
Next
From: Steve Clark
Date:
Subject: 8.3.1 query plan