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: https:/
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 the
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 producti
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 s
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 1
