[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: Ora2Pg 24.3 have been released
From: HexaCluster via PostgreSQL Announce <announce-noreply () postgresql ! org>
Date: 2024-04-01 16:20:04
Message-ID: 171198840428.7102.14870112817363078559 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Bangkok, Thailand - March 29th, 2024
## Ora2Pg
Version 24.3 of Ora2Pg, a free and reliable tool used to migrate an
Oracle database to PostgreSQL, has been officially released and is
publicly available for download.
This release fixes several issues reported since last release and especially
a regression in GEOMETRY data export. As usual, it also adds some new featu=
res
and improvements.
* Add new configuration directive `ORACLE_FDW_PREFETCH` to control the "p=
refetch"
used by oracle_fdw COPY/INSERT. Prior to this change Ora2Pg uses the de=
fault "prefetch"
of oracle_fdw, which at the time of writing is 50. Allowing this to be =
controlled by an
Ora2Pg configuration/option gives the option of increased performance a=
t the cost of
some additional memory on the PostgreSQL side.
* Add new configuration directive `PGTT_NOSUPERUSER`. By default the pgtt
extension is loaded using the superuser privilege when `EXPORT_GTT` is
activated. Enabled it if you run the SQL scripts generated using a non
superuser user. It will use: `LOAD '$libdir/plugins/pgtt';` instead of
`LOAD 'pgtt';`
Backward compatibility changes:
* Modify the behavior of triggers export with `EXPORT_INVALID`. It used to
apply to `ENABLED` or `DISABLED` triggers instead of real `VALID` or `I=
NVALID`
triggers. Export of invalid triggers will be controlled by `EXPORT_INVA=
LID`
like others objects like functions, packages, etc. This mean that disab=
led
triggers that are valid will be exported by default now, this was not
the case before.
For a complete list of change see [https://github.com/darold/ora2pg/blob/ma=
ster/changelog](https://github.com/darold/ora2pg/blob/master/changelog)
## Links & Credits
I would like to thank all users who submitted patches and users
who reported bugs and feature requests, they are all cited
the changelog file.
Ora2Pg is an open project. Any contribution to build a better tool is
welcome. You just have to send your ideas, features requests or patches
using the GitHub tools or directly to ora2pg@darold.net.
Links:
- Website: [https://www.ora2pg.com/](https://www.ora2pg.com/)
- Download1: [https://github.com/darold/ora2pg/releases](https://github.com=
/darold/ora2pg/releases)
- Development: [https://github.com/darold/ora2pg](https://github.com/darold=
/ora2pg)
- ChangeLog: [https://github.com/darold/ora2pg/blob/master/changelog](https=
://github.com/darold/ora2pg/blob/master/changelog)
- Documentation: [https://github.com/darold/ora2pg/blob/master/README](http=
s://github.com/darold/ora2pg/blob/master/README)
--------------
**About Ora2Pg** :
Ora2Pg is an easy and reliable tool to migrate from Oracle to PostgreSQL.
It is developed since 2001 and can export most of the Oracle objects into
PostgreSQL compatible code.
Ora2Pg works on any platform and is available under the GPL v3 licence.
Docs, Download & Support at [http://www.ora2pg.com/](http://www.ora2pg.com/)
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Ora2Pg 24.3 have been released</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<h1 style="color: #000; font-family: sans-serif; line-height: 1.4; margin: 0; \
margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: center">Ora2Pg \
24.3 have been released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Bangkok, Thailand - March 29th, 2024</p> <h2 style="color: #000; \
font-family: sans-serif; font-weight: 400; line-height: 1.4; margin: 0; \
margin-bottom: 30px">Ora2Pg</h2> <p style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px">Version 24.3 of Ora2Pg, a free \
and reliable tool used to migrate an Oracle database to PostgreSQL, has been \
officially released and is publicly available for download.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">This release fixes several issues reported since last release \
and especially a regression in GEOMETRY data export. As usual, it also adds some new \
features and improvements.</p>
<ul style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: 5px">
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Add new configuration directive <code>ORACLE_FDW_PREFETCH</code> \
to control the "prefetch" used by oracle_fdw COPY/INSERT. Prior to this change \
Ora2Pg uses the default "prefetch" of oracle_fdw, which at the time of writing is \
50. Allowing this to be controlled by an Ora2Pg configuration/option gives the \
option of increased performance at the cost of some additional memory on the \
PostgreSQL side.</p> </li>
<li style="list-style-position: inside; margin-left: 5px">
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Add new configuration directive <code>PGTT_NOSUPERUSER</code>. \
By default the pgtt extension is loaded using the superuser privilege when \
<code>EXPORT_GTT</code> is activated. Enabled it if you run the SQL scripts \
generated using a non superuser user. It will use: <code>LOAD \
'$libdir/plugins/pgtt';</code> instead of <code>LOAD 'pgtt';</code></p>
</li>
</ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Backward compatibility changes:</p> <ul style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px"> \
<li style="list-style-position: inside; margin-left: 5px">Modify the behavior of \
triggers export with <code>EXPORT_INVALID</code>. It used to apply to \
<code>ENABLED</code> or <code>DISABLED</code> triggers instead of real \
<code>VALID</code> or <code>INVALID</code> triggers. Export of invalid triggers will \
be controlled by <code>EXPORT_INVALID</code> like others objects like functions, \
packages, etc. This mean that disabled triggers that are valid will be exported by \
default now, this was not the case before.</li>
</ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">For a complete list of change see <a \
href="https://github.com/darold/ora2pg/blob/master/changelog" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/ora2pg/blob/master/changelog</a></p>
<h2 style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Links & Credits</h2> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">I \
would like to thank all users who submitted patches and users who reported bugs and \
feature requests, they are all cited the changelog file.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Ora2Pg is an open project. Any contribution to build a better \
tool is welcome. You just have to send your ideas, features requests or patches
using the GitHub tools or directly to ora2pg@darold.net.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Links:</p> <ul style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px"> <li style="list-style-position: \
inside; margin-left: 5px">Website: <a href="https://www.ora2pg.com/" style="color: \
#3498db; text-decoration: underline">https://www.ora2pg.com/</a></li> <li \
style="list-style-position: inside; margin-left: 5px">Download1: <a \
href="https://github.com/darold/ora2pg/releases" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/ora2pg/releases</a></li> <li \
style="list-style-position: inside; margin-left: 5px">Development: <a \
href="https://github.com/darold/ora2pg" style="color: #3498db; text-decoration: \
underline">https://github.com/darold/ora2pg</a></li> <li style="list-style-position: \
inside; margin-left: 5px">ChangeLog: <a \
href="https://github.com/darold/ora2pg/blob/master/changelog" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/ora2pg/blob/master/changelog</a></li>
<li style="list-style-position: inside; margin-left: 5px">Documentation: <a \
href="https://github.com/darold/ora2pg/blob/master/README" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/ora2pg/blob/master/README</a></li>
</ul>
<hr/>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"><strong>About Ora2Pg</strong> :</p> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: \
15px">Ora2Pg is an easy and reliable tool to migrate from Oracle to PostgreSQL. It is \
developed since 2001 and can export most of the Oracle objects into PostgreSQL \
compatible code.</p> <p style="font-family: sans-serif; font-size: 14px; font-weight: \
normal; margin: 0; margin-bottom: 15px">Ora2Pg works on any platform and is available \
under the GPL v3 licence.</p> <p style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px">Docs, Download & Support at \
<a href="http://www.ora2pg.com/" style="color: #3498db; text-decoration: \
underline">http://www.ora2pg.com/</a></p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from HexaCluster. It was delivered \
on their behalf by the PostgreSQL project. Any questions about the content of the \
message should be sent to HexaCluster.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic