RE: upgrade to version 10.2 question - Mailing list pgsql-novice

From Stephen Froehlich
Subject RE: upgrade to version 10.2 question
Date
Msg-id CY1PR0601MB192790B660ABBBFD7F7CB69AE5CF0@CY1PR0601MB1927.namprd06.prod.outlook.com
Whole thread Raw
In response to Re: upgrade to version 10.2 question  (Stephen Frost <sfrost@snowman.net>)
List pgsql-novice
Stephen ... I think you have the installer prompts backwards and it is indicating that it is indeed doing a minor
upgradethat doesn't need a pg_dump / pg_restore. 

--Stephen

-----Original Message-----
From: Stephen Frost [mailto:sfrost@snowman.net]
Sent: Tuesday, February 20, 2018 10:58 AM
To: john snow <ofbizfanster@gmail.com>
Cc: pgsql-novice <pgsql-novice@postgresql.org>
Subject: Re: upgrade to version 10.2 question

Greetings,

* john snow (ofbizfanster@gmail.com) wrote:
> we currently have version 10.0 in our windows 10 64 bit machine. we
> are just doing development work right now so we have a still small database.
>
> the version 10.0 was installed using EnterpriseDB installer.
>
> we have downloaded version 10.2 EnterpriseDB installer.
>
> this later installer found the current version 10 folder, and informs
> us it will upgrade our current version.
> it also found the data folder.
>
> our question: is it safe to tell the installer to "upgrade" our
> version
> 10.0 using the same folder etc?  will our data be overwritten?

You would need to contact EDB regarding this issue, but it sounds like a bug in their installer to me, where it's
thinkingthat 10.2 is a different major version than 10.0. 

There's no need to "upgrade" a PostgreSQL 10.0 install to 10.2 as that's a minor version change.

Thanks!

Stephen


pgsql-novice by date:

Previous
From: Stephen Frost
Date:
Subject: Re: upgrade to version 10.2 question
Next
From: koimoi
Date:
Subject: Incremental and decremental count based on a date