Обсуждение: update from 13 to16

Поиск
Список
Период
Сортировка

update from 13 to16

От
Martin Mueller
Дата:

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

Re: update from 13 to16

От
Adrian Klaver
Дата:


On 9/15/23 9:55 AM, Martin Mueller wrote:
@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

Re: update from 13 to16

От
Maciek Sakrejda
Дата:
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.