Re: How to transfer databases form one server to other

2020-01-26 Thread Andreas Joseph Krogh
På mandag 27. januar 2020 kl. 03:26:59, skrev Ron 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:

Re: How to transfer databases form one server to other

2020-01-26 Thread Ron
On 1/26/20 7:30 PM, Adrian Klaver wrote: On 1/26/20 2:47 PM, Andrus wrote: Hi! Before you do any of this I would check the Release Notes for the first release of each major release. Prior to version 10 that would be X.X.x where X is a major release. For 10+ that is X.x.  I would also test

Re: How to transfer databases form one server to other

2020-01-26 Thread Adrian Klaver
On 1/26/20 2:47 PM, Andrus wrote: Hi! Before you do any of this I would check the Release Notes for the first release of each major release. Prior to version 10 that would be X.X.x where X is a major release. For 10+ that is X.x.  I would also test the upgrade before doing it on your

Re: How to transfer databases form one server to other

2020-01-26 Thread Adrian Klaver
On 1/26/20 8:59 AM, Andrus wrote: Hi! VPS server has old Debian 6 Squeeze with Postgres 9.1 It has 24 databases. Every night backup copies are created using pg_dump to /root/backups directory for every database. This directory has 24 .backup files with total size 37 GB. I installed new VPS

How to transfer databases form one server to other

2020-01-26 Thread Andrus
Hi! VPS server has old Debian 6 Squeeze with Postgres 9.1 It has 24 databases. Every night backup copies are created using pg_dump to /root/backups directory for every database. This directory has 24 .backup files with total size 37 GB. I installed new VPS server with Debian 10 and Postgres