Thread

1. update from 13 to16

   Martin Mueller <martinmueller@northwestern.edu> — 2023-09-15T16:55:59Z

   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  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
   

2. Re: update from 13 to16

   Adrian Klaver <adrian.klaver@aklaver.com> — 2023-09-15T17:01:06Z

   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
   >

3. Re: update from 13 to16

   Maciek Sakrejda <m.sakrejda@gmail.com> — 2023-09-16T19:01:15Z

   On Fri, Sep 15, 2023, 15:02 Adrian Klaver <adrian.klaver@aklaver.com> wrote:
   
   > 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
   >
   
   To elaborate on this, if you want to avoid copying the data, you may want
   to take a look at pg_upgrade in link mode.
   
   >