Re: pg_dump / pgrestore question - cannot restore a single schema

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "S(dot)Bob" <sbob(at)quadratum-braccas(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump / pgrestore question - cannot restore a single schema
Date: 2020-03-24 00:40:09
Message-ID: CAKFQuwYx6OWRA2WF3RkHgB13RZTSrRU44LiGYcwb7+O-LWuUTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Mar 23, 2020 at 4:47 PM S.Bob <sbob(at)quadratum-braccas(dot)com> wrote:

> However if I try to restore only one of the schemas it does not work,
> seems like it does not create the schema first:
>
Since you have to know the schema name anyway in order to restore that
schema only just go ahead an create the schema before performing the
restore. It seems that since a schema is not "in itself" it doesn't get
restored. Doesn't seem like a problem.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2020-03-24 00:55:32 Re: pg_dump / pgrestore question - cannot restore a single schema
Previous Message S.Bob 2020-03-23 23:47:07 pg_dump / pgrestore question - cannot restore a single schema