Interview with Libelle IT Group
Any views or opinions represented or expressed in this interview belong solely to the interviewee and do not neccessarily represent those of the PGConf.EU 2022 organization, PostgreSQL Europe, or the wider PostgreSQL community, unless explicitly stated.
- In which areas do you expect PostgreSQL to grow most and how does your company contribute to and benefit from that growth?
Many companies are now migrating from other RDBMS to PostgreSQL. We offer a tool for these migrations called Libelle DataMigrating. WIth that you can migrate all of your data from a foreign RDBMS to PostgreSQL.
- What is your PostgreSQL centered product?
It is BusinessShadow/PostgreSQL. With BusinessShadow we create standby systems of production systems.
The standby system is created by an Initial-Copy job. After that all changes on the production system are continuously transferred by a logfile shipping mechanism to the standby system. After a defined delay (e.g. 4 hours) the changes are applied to the standby system. Also physical (tablespaces) changes are copied to the standby system and applied. We support several backup/replication modes: Backup-Only, Log-Shipping and Streaming Replication with Log-Shipping as a fallback. More complex replication scenarios like multi-target (A→B, A→C) and multi-tier (A→B, B→C) are also supported. It's also possible to add your own tasks to customize the different jobs and phases.
In case of an error you can Switch-Over to the standby system and make it available as the new production system. There are several Switch-Over scenarios available, that can handle:
- when production becomes unreachable or is fully destroyed
- when an operator made a bad transaction, to travel back in time on the standby system
- planned DR scenarios or migrations
- DR fire drills
- What is your company’s mission?
We make software for IT infrastructure professionals. Our tools are in the area of
- business continuity,
- test data management and
- migrations.