Re: pg_restore man page question

Be advised, the --section option is only available from 9.2 and up.

On Mon, Mar 7, 2016 at 2:08 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 03/07/2016 10:22 AM, Karsten Hilbert wrote:
>
>> On Mon, Mar 07, 2016 at 11:03:39AM -0700, David G. Johnston wrote:
>>
>> The man page of pg_restore says
>>>>
>>>> --disable-triggers
>>>> This option is relevant only when performing a
>>>> data-only restore. It instructs pg_restore to execute
>>>> commands to temporarily disable triggers on the
>>>> target tables while the data is reloaded. [...]
>>>>
>>>> This hint seems overly narrow: when doing a restore of schema
>>>> PLUS data (IOW, not a schema-only restore) it should apply,
>>>> too, shouldn't it ?
>>>>
>>>> Otherwise it would suggest that pg_restore does this:
>>>>
>>>> - restore basic table structure
>>>> - restore data
>>>> - restore constraints and triggers and ...
>>>>
>>>>
>>> ... ​indexes​
>>>
>>>
>>> ​Why is the surprising?
>>>
>>
>> It's not surprising to me. I was making sure which way things
>> are because the documentation I consulted wasn't clear on
>> that for me. The way things turn out to be -- so much the
>> better !
>>
>
> Yeah, you have to dig into one of the switch definitions to get an answer:
>
> http://www.postgresql.org/docs/9.5/interactive/app-pgrestore.html
>
> --section=sectionname
>
> Only restore the named section. The section name can be pre-data,
> data, or post-data. This option can be specified more than once to select
> multiple sections. The default is to restore all sections.
>
> The data section contains actual table data as well as large-object
> definitions. Post-data items consist of definitions of indexes, triggers,
> rules and constraints other than validated check constraints. Pre-data
> items consist of all other data definition items.
>
>
>> Karsten
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.