> > 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.
