Upgrade to 12.2 using same data directory

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

RE: Upgrade to 12.2 using same data directory

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. /alias/data/ J From: Josef Šimánek Sent: Tuesday, February 25, 2020 1:05 PM To: Mihalidesová Jana Cc: pgsql

RE: Upgrade to 12.2 using same data directory

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

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

[unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209}

Hi, I try to connect from oracle 11.2.0.4 to postgres but I still got. Do you have any idea what configuration should I check. What is wrong? ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,N

RE: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209}

| | | +---+ SQL> Thx a lot! J From: Pavel Stehule Sent: Thursday, January 3, 2019 12:26 PM To: Mihalidesová Jana Cc: pgsql-general@lists.postgresql.org Subject: Re: [unixODBC]Unrecognized

Oracke BLOB to Postgres BYTEA using ora2pg

Hi, We try to migrate from oracle to postgres using ora2pg but we hit some weird behavior of bytea. Or it's just our ignorance. Table migration were ok, but we are not able to read bytea data. What we did wrong. Thank you for your help, JM nipjd=> \d alf_node_properties_zaloha

RE: Oracke BLOB to Postgres BYTEA using ora2pg

d414a4f52', 'hex') (6 rows) So, how I convert bytea to text? Thanks, JM From: Pavel Stehule Sent: Tuesday, January 15, 2019 9:46 AM To: Mihalidesová Jana Cc: pgsql-general@lists.postgresql.org Subject: Re: Oracke BLOB to Postgres BYTEA using ora2pg Hi út 15. 1. 2019 v 9:40

Upgrade from 11.3 to 13.1 failed with out of memory

Open Hi, I have aproximetly 560GB large database and try to upgrade it from 11.3 to 13.1. I’ve successfully upgraded dev,test and ref environment but on the production pg_dump failed with out of memory. Yes, of course, the dev,test and ref are much much smaller then production database. We are

RE: Upgrade from 11.3 to 13.1 failed with out of memory

Open Hi, Thanks a lot for information. Best regards, Jana -Original Message- From: Magnus Hagander Sent: Tuesday, April 6, 2021 3:23 PM To: Mihalidesová Jana Cc: pgsql-general@lists.postgresql.org Subject: Re: Upgrade from 11.3 to 13.1 failed with out of memory On Tue, Apr 6, 2021