upgrade and migrate

Julie Nishimura <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <BYAPR08MB50145D4B77BBAFDEE7C0726BAC420@BYAPR08MB5014.namprd08.prod.outlook.com>
Hello, what is the best way to migrate from PostgreSQL 8.3.11 on x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gnu server, with minimal downtime?
The caveat is the source has about 80 databases overall almost 30 TB. I could migrate the smallest ones (up to 1 tb) using pg_dump and pg_restore, but the largest hot database is almost 17 tb, and I am not sure how to approach this effort in a better and efficient way?

Thank you!
-Julie N
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.