Re: Allowing parallel pg_restore from pipe - Mailing list pgsql-hackers

From Shaun Thomas
Subject Re: Allowing parallel pg_restore from pipe
Date
Msg-id 51951B00.1090708@optionshouse.com
Whole thread Raw
In response to Allowing parallel pg_restore from pipe  (Timothy Garnett <tgarnett@panjiva.com>)
List pgsql-hackers
On 05/16/2013 12:16 PM, Timothy Garnett wrote:

> I think you'd have to be real careful around foreign key constraints
> for that to work.

Not especially. All you need to do is bootstrap the database with a 
bunch of empty table targets (no constraints, keys, etc), then restore 
with the xargs command. Then you can apply the constraints, keys, and 
indexes later by doing a schema-only parallel pg_restore.

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PostgreSQL 9.3 beta breaks some extensions "make install"
Next
From: Timothy Garnett
Date:
Subject: Re: Allowing parallel pg_restore from pipe