Import Database

From: Sathish Kumar <satcse88(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Import Database
Date: 2019-05-05 16:47:46
Message-ID: CANa_DOhNoHi9=6C9OanRR+AfshUovS7HCjNkqeykwm0o64srtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2019-05-05 16:56:41 Re: Import Database
Previous Message Igal Sapir 2019-05-05 03:05:31 Re: Connecting to NOTIFY with telnet