Search Postgresql Archives

Re: Dump all the indexes/constraints/roles

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

Subject: Re: Dump all the indexes/constraints/roles
From: Patrick B <patrickbakerbr@xxxxxxxxx>
Date: Wed, 19 Oct 2016 08:11:13 +1300
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAMkU=1yd9KyVEOKnUBduLAQTeHVyvJ+7MgG40i5qD1E9YiD0FQ@mail.gmail.com>
References: <CAJNY3iskEm1-E-sAqj4taY=g8kELEYf3myBMVfu8EB_q_7WZmw@mail.gmail.com> <CAMkU=1yd9KyVEOKnUBduLAQTeHVyvJ+7MgG40i5qD1E9YiD0FQ@mail.gmail.com>

Thank you guys... good to know that pg_dump does all the job for me :)

So.. If I only dump using the --schema-only option, it will dump all the schemas, constraints, indexes and tables?

Because probably, I'll have to import the data manually. NOt in a single pg_restore I mean. (AWS issue)

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

Follow-Ups:
- Re: Dump all the indexes/constraints/roles
  - From: Melvin Davidson

References:
- Dump all the indexes/constraints/roles
  - From: Patrick B
- Re: Dump all the indexes/constraints/roles
  - From: Jeff Janes

Prev by Date: Re: out-of-order XID insertion in KnownAssignedXids
Next by Date: Re: Dump all the indexes/constraints/roles
Previous by thread: Re: Dump all the indexes/constraints/roles
Next by thread: Re: Dump all the indexes/constraints/roles
Index(es):
- Date
- Thread

[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