Re: Allowing parallel pg_restore from pipe

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Re: Allowing parallel pg_restore from pipe
Дата
Msg-id 51951B00.1090708@optionshouse.com
обсуждение исходный текст
Ответ на Allowing parallel pg_restore from pipe  (Timothy Garnett <tgarnett@panjiva.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: PostgreSQL 9.3 beta breaks some extensions "make install"
Следующее
От: Timothy Garnett
Дата:
Сообщение: Re: Allowing parallel pg_restore from pipe