On 1/2/20 9:04 AM, Sonam Sharma wrote:
Thanks Adrian, it worked :)
What worked? Still not clear what was not working in the first place?
On Thu, Jan 2, 2020, 9:50 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:On 1/2/20 5:47 AM, Tom Lane wrote: > Sonam Sharma <sonams1209@xxxxxxxxx <mailto: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 Klaveradrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
