Re: update from 13 to16 - Mailing list pgsql-general

@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face {font-family:"Times New Roman \(Body CS\)"; panose-1:2 11 6 4 2 2 2 2 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ligatures:standardcontextual;}span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif;}div.WordSection1 {page:WordSection1;}

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