"JP Beaudry" <jbeaudry@cisco.com> writes:
> In long, I use the following command to generate the dump file against a
> database named "mystore":
> "pg_dump --clean --create --file=db_dump.txt --format p mystore"
> ...
> To restore the database, I have tried:
> "psql mystore < db_dump.txt"
> And this fails at the "Drop Database "mystore"" command.
--clean and --create are logically incompatible options. pg_dump
versions newer than about 7.1 will tell you so ... I think you are
overdue for an upgrade, but in the meantime don't use that combination.
regards, tom lane