Re: Import Database

[Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>]

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