På mandag 27. januar 2020 kl. 03:26:59, skrev Ron <ronljohnso...@gmail.com <mailto:ronljohnso...@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.
According to the manual: https://www.postgresql.org/docs/12/app-pgdump.html <https://www.postgresql.org/docs/12/app-pgdump.html> 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 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>
