Re: pg_restore new parameter request - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore new parameter request
Date
Msg-id 1825.1448290213@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore new parameter request  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
"Campbell, Lance" <lance@illinois.edu> writes:
> PostgreSQL pg_restore new feature request
> I did some testing last week to see how fast I could get pg_restore to reload data.  I found some settings that made
asignificant speed boost.  One request I have is the addition of two parameters to pg_restore. 

> --no-indexes
> When this parameter is used during a full restore of a database the indexes would not be applied.

> --only-indexes
> When this parameter is selected during a full restore of a database only the indexes would be applied.

This seems fairly redundant with the existing notion of "dump sections".
Have you experimented with "--section=post-data"?

            regards, tom lane


pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: pg_restore new parameter request
Next
From: "David G. Johnston"
Date:
Subject: Re: pg_restore new parameter request