Re: restore a dump db from tar file

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.

In response to

Browse pgsql-general by date

  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