Postgres Pro
Downloads
Home   >   mailing lists

Re: How to transfer databases form one server to other - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: How to transfer databases form one server to other
Date
Msg-id VisenaEmail.11.54410910399c6d03.16fe550d31c@tc7-visena
Whole thread Raw
In response to Re: How to transfer databases form one server to other  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: How to transfer databases form one server to other
List pgsql-general
Tree view
På mandag 27. januar 2020 kl. 03:26:59, skrev Ron <ronljohnsonjr@gmail.com>:
[..]
I ran uncompressed pg_dump on multiple TB+ sized databases from v8.4 servers across the LAN using 9.6 binaries on the remote server.  It was quite fast.  Threading was key.
 
the "directory format" is the only format which supports parallel dumps, if I'm not reading it wrong.
 
How did threading solve "between database" dump/restore for you? Did you dump to "directory format" first, then restore? If so, then that requires quite a bit of temp-space...
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Attachment

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: How to transfer databases form one server to other
Next
From: "Andrus"
Date:
Subject: Re: How to transfer databases form one server to other