| 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: | Whole Thread | Raw Message | 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 |