From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
---|---|
To: | Jethro Elmer Sanidad <jethroelmersanidad(at)gardenia(dot)com(dot)ph> |
Cc: | Christophe Pettus <xof(at)thebuild(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, umair(dot)shahid(at)gmail(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: [EXTERNAL] Oracle FDW version |
Date: | 2023-08-23 11:07:09 |
Message-ID: | CAB8KJ=i-oasXyBoXm71+3TLPb6NA0XGwYJFUDTLPMWJuZVsjNQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2023年8月23日(水) 15:10 Jethro Elmer Sanidad <jethroelmersanidad(at)gardenia(dot)com(dot)ph
>:
> Hello,
>
> Can you confirm in this email that our current version of PostgreSQL
> (9.2.24) is not compatible with any of oracle_fdw versions released? And
> you are recommending an upgrade? Thanks!
>
OK, here's the summary:
- oracle_fdw builds against *community* PostgreSQL 9.3 and later (I just
verfied that)
- it is likely not compatible with PostgreSQL forks such as Greenplum
- if you are running a version of PostgreSQL based on 9.2.x or 9.4.x it's
hopelessly
out-of-date and you should definitely upgrade anyway (but if it's a fork,
that still won't
that mean oracle_fdw will compile against it)
HTH
Ian Barwick
>
> On Wed, Aug 23, 2023 at 2:04 PM Ian Lawrence Barwick <barwick(at)gmail(dot)com>
> wrote:
>
>> 2023年8月23日(水) 12:47 Christophe Pettus <xof(at)thebuild(dot)com>:
>> >
>> >
>> >
>> > > On Aug 22, 2023, at 19:57, Jethro Elmer Sanidad <
>> jethroelmersanidad(at)gardenia(dot)com(dot)ph> wrote:
>> > >
>> > > Hello,
>> > >
>> > > I tried both the 1.5.0 and 2.0.0. Both returned error during 'make'
>> command. Please see below:
>> >
>> > The API between PostgreSQL and foreign data wrappers has changed
>> significantly since 9.4. As Tom mentioned, you need to upgrade your server
>> to something in-support.
>>
>> FWIW oracle_fdw should actually build against PostgreSQL as far back as
>> 9.3
>> (though finding packages would be a fruitless endeavour); the
>> documentation
>> does explicitly mention that it will likely not build against forks which
>> are
>> not compatible with the community code [1].
>>
>> [1] https://github.com/laurenz/oracle_fdw#5-installation-requirements
>>
>> Regards
>>
>> Ian Barwick
>>
>
>
> --
>
> [image: image.png] <http://www.gardenia.com.ph/>
>
> *Jethro Elmer T. Sanidad*
> Management Information Systems
> O: +63 2 8889 8890 loc. 1354 | M: +63 9686809253
> Gardenia Bakeries Philippines Incorporated | Laguna International
> Industrial Park (LIIP) | Binan 4024 | Laguna
>
> *CONFIDENTIALITY NOTICE:* This email is confidential and subject to legal
> rights of Gardenia Bakeries (Philippines), Inc. (“GBPI”). If you received
> this email by error, you must not use or disclose any information in it and
> immediately notify the sender by return email and permanently delete this
> email (and all attachments) without any use of its contents. To the extent
> legally permitted, GBPI has no liability of any kind arising out of or in
> connection with any virus transmitted by this email, attachments, and/or
> any errors or omissions in content including transmissions through
> unauthorised use or tampering of email system and/or the integrity of the
> email being compromised. Any personal statements or opinions in this
> communication are those of the individual sender and do not reflect the
> views of GBPI. GBPI will never consent to or authorize the publication of
> defamatory statements or infringement of intellectual property. Only
> individuals authorized by GBPI’s Board of Directors may sign and/or accept
> proposals, contracts, or agreements as well as waive any legal right of
> GBPI. Any personal information in this email must be handled in accordance
> with the Data Privacy Act of 2012 of the Philippines and its implementing
> rules and regulations.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rihad | 2023-08-23 14:06:43 | Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset? |
Previous Message | Avinash Vallarapu | 2023-08-23 11:05:22 | Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8 |