| From: | HexaCluster via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
|---|---|
| To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
| Subject: | oid2bytea v1.0 has been released |
| Date: | 2025-04-21 20:19:33 |
| Message-ID: | 174526677380.676.8349703113731922674@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
Antananarivo, Madagascar - April 19, 2025
## PostgreSQL large object to bytea converter
First release v1.0 of oid2bytea tool has been published. oid2bytea is a program
used to convert large objects columns in a PostgreSQL database into bytea.
oid2bytea will automatically detect the oid columns and process to their bytea
transformation automatically; parallel processing can be used to accelerate the
migration. Of course you can also choose which tables need to be processed or
filter on a schema.
Two migration modes are supported: `local` and `remote`. In `local` mode the
large objects data stored in the `pg_largeobject` table will be moved into a
newly created bytea column with the same name and the old oid column will be
removed. In `remote` mode oid2bytea will migrate the local oid columns to a
remote database with the same structure except that the oid columns have been
replaced by bytea columns of the same names.
## Links & Credits
oid2bytea is an open project under the PostgreSQL license maintained by [HexaCluster Corp](https://hexacluster.ai).
Any contribution to build a better tool is welcome. You can send your ideas, features requests or patches
using the GitHub tools.
**Links :**
* Download: [https://github.com/HexaCluster/oid2bytea/releases/](https://github.com/HexaCluster/oid2bytea/releases/)
* Support: use GitHub report tool at [https://github.com/HexaCluster/oid2bytea/issues](https://github.com/HexaCluster/oid2bytea/issues)
## About oid2bytea
The oid2bytea extension is an original work of [HexaCluster Corp](https://hexacluster.ai), the tool is developed and maintained by Gilles Darold at [HexaCluster Corp](https://hexacluster.ai). If you need more information about HexaCluster, please [contact us](https://hexacluster.ai/contact-us/).
Documentation at [https://github.com/HexaCluster/oid2bytea#readme](https://github.com/HexaCluster/oid2bytea#readme)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | HexaCluster via PostgreSQL Announce | 2025-04-21 20:19:43 | Ora2Pg v25.0 has been released |
| Previous Message | Hornetlabs Technology Inc via PostgreSQL Announce | 2025-04-21 14:31:04 | SynchDB 1.1 Released - Now with Oracle Support and Enhanced Data Transformation |