Re: Upgrade to 12.2 using same data directory

2020-02-25 Thread Laurenz Albe
On Tue, 2020-02-25 at 11:58 +, Mihalidesová Jana wrote: > Is there possibility to upgrade from 10.6 to 12.2 using exact same data > directory? > First problem is with initialing of “new” cluster. Then pg_upgrade check fail. > > ./pg_upgrade -b $OLD/bin -B $NEWd/bin -d $OLD -D $OLD -k -c No,

Re: Upgrade to 12.2 using same data directory

2020-02-25 Thread Paul Förster
ruary 25, 2020 1:05 PM > To: Mihalidesová Jana > Cc: pgsql-general@lists.postgresql.org > Subject: Re: Upgrade to 12.2 using same data directory > > I think that's not possible. What's the reason to reuse old directory? > > út 25. 2. 2020 v 12:59 odesílatel M

Re: Upgrade to 12.2 using same data directory

2020-02-25 Thread Sushant Pawar
-- > > Checking cluster versions > > This utility can only upgrade to PostgreSQL version 12. > > Failure, exiting > > > > > > Jana > > > > *From:* Sushant Pawar > *Sent:* Tuesday, February 25, 2020 1:23 PM > *To:* Mihalidesová

Re: Upgrade to 12.2 using same data directory

2020-02-25 Thread Ray O'Donnell
On 25/02/2020 12:52, Mihalidesová Jana wrote: > I think it’s strange to change the data directory $PATH every time I > upgrade the software, when the data are the same. I have a specific > naming convention not using a db version. There's a lot to recommend keeping an untouched copy of your old da

RE: Upgrade to 12.2 using same data directory

2020-02-25 Thread Mihalidesová Jana
Yes, that’s what I though, but the pre-upgrade check will be done with downtime. Ok, Thanks. J From: Josef Šimánek Sent: Tuesday, February 25, 2020 1:54 PM To: Mihalidesová Jana Cc: pgsql-general@lists.postgresql.org Subject: Re: Upgrade to 12.2 using same data directory I think it should

RE: Upgrade to 12.2 using same data directory

2020-02-25 Thread Mihalidesová Jana
er versions This utility can only upgrade to PostgreSQL version 12. Failure, exiting Jana From: Sushant Pawar Sent: Tuesday, February 25, 2020 1:23 PM To: Mihalidesová Jana Cc: Josef Šimánek ; pgsql-general@lists.postgresql.org Subject: Re: Upgrade to 12.2 using same data directory Hi Miha

Re: Upgrade to 12.2 using same data directory

2020-02-25 Thread Josef Šimánek
> > > /alias/data/ > > > > J > > > > *From:* Josef Šimánek > *Sent:* Tuesday, February 25, 2020 1:05 PM > *To:* Mihalidesová Jana > *Cc:* pgsql-general@lists.postgresql.org > *Subject:* Re: Upgrade to 12.2 using same data directory > > > > I thin

RE: Upgrade to 12.2 using same data directory

2020-02-25 Thread Mihalidesová Jana
-general@lists.postgresql.org Subject: Re: Upgrade to 12.2 using same data directory I think that's not possible. What's the reason to reuse old directory? út 25. 2. 2020 v 12:59 odesílatel Mihalidesová Jana mailto:jana.mihalides...@cetin.cz>> napsal: Hi, Is there possibility to upgr

Re: Upgrade to 12.2 using same data directory

2020-02-25 Thread Sushant Pawar
Hi Mihalidesová, It should work with -k option. Can you share the error that you have received? You can execute pg_upgrade with -c option to identify any possible manual change required. Best Regards, *Sushant Pawar | Database Solution Consultant* *ASHNIK TECHNOLOGY SOLUTIONS PVT. LTD.* Skype

Re: Upgrade to 12.2 using same data directory

2020-02-25 Thread Josef Šimánek
I think that's not possible. What's the reason to reuse old directory? út 25. 2. 2020 v 12:59 odesílatel Mihalidesová Jana < jana.mihalides...@cetin.cz> napsal: > Hi, > > > > Is there possibility to upgrade from 10.6 to 12.2 using exact same data > directory? First problem is with initialing of “

Upgrade to 12.2 using same data directory

2020-02-25 Thread Mihalidesová Jana
Hi, Is there possibility to upgrade from 10.6 to 12.2 using exact same data directory? First problem is with initialing of "new" cluster. Then pg_upgrade check fail. ./pg_upgrade -b $OLD/bin -B $NEWd/bin -d $OLD -D $OLD -k -c Thx, Jana Obsah této zprávy má výlučně komunikační charakter. Ne