On 9/15/23 9:55 AM, Martin Mueller wrote:
I am thinking of upgrading from version 13 to version 16.
I think I can do this by leaving the data alone and just replacing the
software. My data are extremely simple and consist of several hundred
No you can't.
You will need to either use pg_upgrade:
https://www.postgresql.org/docs/16/pgupgrade.html
or do dump/restore using some combination of:
https://www.postgresql.org/docs/16/app-pgdump.html
https://www.postgresql.org/docs/16/app-pg-dumpall.html
and
https://www.postgresql.org/docs/16/app-pgrestore.html
https://www.postgresql.org/docs/16/app-psql.html
tables, some with close to ten million records. But their structure
is simple. I access the data via Aqua Data Studio, as if they were
very large spreadsheets.
Is that a correct analysis? I just want to make sure.
Martin Mueller
Professor emeritus of English and Classsics
Northwestern University
