From the docs:
<quote>
-C
--create
Begin the output with a command to create the database itself and
reconnect to the created database. (With a script of this form, it
doesn't matter which database you connect to before running the script.)
This option is only meaningful for the plain-text format. For the
archive formats, you can specify the option when you call pg_restore.
</quote>
So it seems that you can't do it when using a non-text format - you'll
have to do a plain-text dump, and maybe pipe it to tar if you want that.
Ray.
Thanks Ray,
this is also what i found later after my post :-(
everything works well now.
