Re: Import Database - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Import Database
Date
Msg-id a7d90fc3-54fa-5a66-8f7e-15c608064669@a-kretschmer.de
Whole thread Raw
In response to Re: Import Database  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Import Database
List pgsql-general

Am 05.05.19 um 19:26 schrieb Ron:
> On 5/5/19 12:20 PM, Andreas Kretschmer wrote:
>>
>>
>> Am 05.05.19 um 18:47 schrieb Sathish Kumar:
>>> Is there a way to speed up the importing process by tweaking 
>>> Postgresql config like maintenance_workmem, work_mem, shared_buffers 
>>> etc.,
>>
>> sure, take the dump in custom-format and use pg_restore with -j 
>> <number_of_jobs>.
>
> Custom format or directory format?

both are possible for that.

Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com




pgsql-general by date:

Previous
From: Sathish Kumar
Date:
Subject: Re: [External] Re: Import Database
Next
From: Arup Rakshit
Date:
Subject: duplicate key value violates unique constraint"chinese_price_infos_pkey"