Re: update from 13 to16

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
>