From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_restore fails |
Date: | 2016-03-13 18:05:19 |
Message-ID: | CA+bJJby-mjGtw7KDLxS8cnLMwD6rdW38Hso59q_1vW3WUOUjvg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Karsten..
On Sun, Mar 13, 2016 at 12:09 AM, Karsten Hilbert
<Karsten(dot)Hilbert(at)gmx(dot)net> wrote:
> I am trying to pg_restore from a directory dump.
> However, despite using
>
> --clean
> --create
> --if-exists
>
> I am getting an error because schema PUBLIC already exists.
....snip, snip....
Have you tried the classic combo pg_restore -l > toc.dat,
your_favorite_editor toc.dat pg_restore -L toc.dat?
I've had great success with that in the past, even splitting the TOC
in several chunks to be able to make adjustements between them, but
I've never used the directory format for ( serious, I've tried all
when learning ) backups.
Francisco Olarte.
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2016-03-13 18:30:17 | Re: MongoDB 3.2 beating Postgres 9.5.1? |
Previous Message | Dane Foster | 2016-03-13 17:32:12 | Re: Full text search question: "01.Bez." --> "Erster Bezirk" |