Postgres Pro
Downloads
Home   >   mailing lists

Thread: upgrade to version 10.2 question

upgrade to version 10.2 question

From
john snow
Date:
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? 

sorry for the very basic question but we thought it's better to be making mistakes at a time when the cost is not high yet :-)

thanks for helping!

Re: upgrade to version 10.2 question

From
"David G. Johnston"
Date:
On Monday, February 19, 2018, john snow <ofbizfanster@gmail.com> wrote:
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? 


David J.

Re: upgrade to version 10.2 question

From
Stephen Frost
Date:
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 thinking that 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
Attachment

RE: upgrade to version 10.2 question

From
Stephen Froehlich
Date:
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