Home > mailing lists

Import Database - Mailing list pgsql-general

From	Sathish Kumar
Subject	Import Database
Date	May 5, 2019 19:47:46
Msg-id	CANa_DOhNoHi9=6C9OanRR+AfshUovS7HCjNkqeykwm0o64srtQ@mail.gmail.com Whole thread Raw
Responses	Re: Import Database Re: Import Database
List	pgsql-general

Hi,

I am trying to import a database of size 300+gb to another server. It's taking a long time.

4vCPU

15GB RAM

psql -h newserver -U dbuser -d production -W < prod.sql

Is there a way to speed up the importing process by tweaking Postgresql config like maintenance_workmem, work_mem, shared_buffers etc.,

From: Igal Sapir
Date: 05 May 2019, 06:05:31
Subject: Re: Connecting to NOTIFY with telnet

From: Ravi Krishna
Date: 05 May 2019, 19:56:41
Subject: Re: Import Database