From: | Sonam Sharma <sonams1209(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Schema dump |
Date: | 2020-01-02 17:04:18 |
Message-ID: | CAM-M3TnY5SLoWOXnKBbYxhzfMnXLCD61vzWfH3M+rP0NR5RiFw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Adrian, it worked :)
On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 1/2/20 5:47 AM, Tom Lane wrote:
> > Sonam Sharma <sonams1209(at)gmail(dot)com> writes:
> >> I took a schema dump using : pg_dump -n schema dbname .
> >> When I restored this , it doesn't contain the constraints and indexes.
> Can
> >> someone please help how to take a dump including all
> >
> > Hmph ... works for me. Where by "works", I mean "the dump contains
> > constraints and indexes belonging to tables in the specified schema,
> > and not any others". Maybe you could provide a little more detail?
> >
> > (One thing I notice is that the dump doesn't contain a "CREATE
> > SCHEMA schema" command, so you have to do that manually before
> > you restore. I guess this fits with the definition of the switch
> > as selecting objects *in* the named schema, but it's still a
> > possible gotcha.)
>
> Caffeine kicked in, now I remember how the above happens:
>
> pg_restore -n utility -f pgrestore_utility.sql /production_12.out
>
> In pgrestore_utility.sql there is no CREATE SCHEMA.
>
> This came up in a previous thread:
>
> https://www.postgresql.org/message-id/6234.1569941612%40sss.pgh.pa.us
>
> >
> > regards, tom lane
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-01-02 17:10:12 | Re: Schema dump |
Previous Message | Adrian Klaver | 2020-01-02 16:20:19 | Re: Schema dump |