Search Postgresql Archives

Re: Schema dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Adrian, it worked :) 

On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 1/2/20 5:47 AM, Tom Lane wrote:
> Sonam Sharma <sonams1209@xxxxxxxxx> 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.klaver@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux