oid2bytea v1.0 has been released

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)

Browse pgsql-announce by date

  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