From: | "Alain Roger" <raf(dot)news(at)gmail(dot)com> |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: restore a dump db from tar file |
Date: | 2008-10-06 16:53:26 |
Message-ID: | 75645bbb0810060953u4b5993evea67658e1978245d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | johnf | 2008-10-06 17:30:35 | on windows 8.3 many processes - is it normal? |
Previous Message | Gerfried Fuchs | 2008-10-06 16:39:56 | Re: [Pkg-postgresql-public] Postgres major version support policy on Debian |