Technology Solutions

Stelo + PostgreSQL

Technology Pages Logo-Title Nodes_PostgreSQL

In a successful data ecosystem, data consistency and integrity are key. For PostgreSQL users, data informs direction, velocity, and momentum to help enterprises adapt, respond, and ultimately, thrive. Stelo is purpose built to deliver a robust data replication solution with a focus on data integrity.  

The Stelo solution provides reliable, high-speed, affordable bi-directional replication for PostgreSQL and any relational database accessible via ODBC and non-relational databases via Kafka, Delta Lakes and flat file formats. Deployments can keep up with the high-volume online transaction processing (OLTP) requirements. Easily replicate millions of transactions per hour and transfer data sets over 1TB.

Stelo takes full advantage of open standards such as DRDA, SQL, ODBC, and JDBC. to maximize compatibility and interoperability within an enterprise network. Because no application software is installed on the source system and all access is performed using industry-standard protocols, Stelo can work with PostgreSQL running on any supported platform (e.g. Windows, Linux, MacOS, Solaris, and cloud services such AWS RDS, AWS Aurora, and Azure Database for PostgreSQL). Experience enterprise power without the enterprise cost.

Related Resources





Connects to

Any-to-Any Pairings

Avoid vendor lock-in. Stelo uses heterogeneous replication for bi-directional support across all source and destination types. Our open-standards approach allows us to remain vendor-agnostic while providing highly flexible deployment models.

Split-Tier Deployment

Simultaneously replicate to both Cloud and On-Premise destinations, including Relational and NoSQL database compatibility. Multi-Threaded Loading enables high-speed bulk transfer across WANs with minimal production downtime.

Automated Modeling

Set it and forget it: Once running, our software automatically replicates schemas without requiring complex programming. It reliably operates in the background without needing dedicated engineering support to maintain and manage.

Near-Zero Footprint

Stelo is designed to have a minimal impact on PostgreSQL operations. Our process provides ultra-low CPU load (less than 1% typical) to minimize production impact and avoid operational disruption. No source or destination software installation required. Only transfer data you need thanks to Dataset Partitioning.

Unlimited Pairs

Avoid cost lock-in with a Load-Based Pricing Model: A single instance can support unlimited source and destination connections, allowing for the lowest total cost of ownership possible.

Automatic Recovery

If a connection is broken, then no data is lost. Stelo will automatically resume replication without needing to re-baseline in the event of a connectivity failure.

Strategies for Futureproofing Data Management

With outdated systems, companies risk reaching the limits of their data analysis capabilities, and they have a much harder time responding to dynamic market conditions, delivering innovative products and services, and maintaining customer satisfaction. In data management, futureproofing means establishing a system with agile architecture and loosely coupled software components. In short, futureproofing means anticipating change.

In this white paper, we’ll cover:
  • The importance of futureproofing your data ecosystem
  • Key opportunities to build reliability and versatility into your data management strategy
  • Data management and data messaging structure options that accommodate new tools and technologies




Is there any loss of transparency or loss of data type information in the replication?

No. Stelo accesses host data through the ODBC interface, which supports most host data types and ranges of data values directly. When you configure a replication operation, Stelo queries the source database and automatically communicates data type and attribute information to the target database along with the actual data. You can also configure custom conversions for exceptional cases.

Can Stelo handle high-volume requirements without breaking my bank?

PostgreSQL databases can generate large datasets, but Stelo can handle large-scale data replication with sub-second latency. A single instance can support multiple sources and destinations without additional licensing. The Stelo model is independent of the number of cores of either the source or destination—so you only pay for the capacity required to support the transaction volume. This cost-efficient method merges source data flows into one stream, and then it is applied to any number of subscribing destinations. Stelo delivers enterprise-level performance without enterprise-level cost.

Does Stelo create new users on the my source system?

When working with a PostgreSQL source, Stelo does not create any new users on the source system. Instead, it communicates with the source system using an existing userID supplied during agent creation. This user must either be a superuser or the owner of the files to be replicated and of the database itself and the replication role must be granted to the userID.

The user specified when configuring a source in Data Replicator Manager (for use by Stelo Apply) does not require any special privileges; it simply needs read access to the source tables to be replicated and to the schema and control tables created by Stelo Capture.

Can Stelo deploy on a Linux server?

Yes. The price of running open-source Linux servers is significantly lower than running Windows-based servers. Beyond the savings potential, Linux is well-suited for scaling server applications; with Linux container deployment, Stelo can be delivered as an appliance in about five minutes. In moving from a Windows-based architecture to an open-standard architecture that’s based on new inter-process communication, Google Remote Procedure Call (gRPC), Stelo can support Windows, Linux, or a mix of Windows clients.

Support Features

Solutions Icon_Green

Accessible Support

Quick support is available for training, troubleshooting, version updates, and data replication architecture. 24/7 Urgent Incident Support is included in annual subscriptions.
Solutions Icon_Green

Highly Experienced Team

Stelo’s technologists have 25+ years of experience in developing reliable data software. Whether you need basic support or have a tricky technical challenge, we can work with you to solve any problem.
Solutions Icon_Green

End-to-End Proficiency

Our team has detailed knowledge of every data platform we support and can troubleshoot end-to-end replication pairing in heterogeneous environments to ensure the pairings are working properly.

Solutions Icon_Green

Constant Evolution

Unlike some other solutions, Stelo won't go out of date. New source and target types are continuously added through active updates to stay compatible with emerging market requirements.

The Latest from Our Blog

How Stelo V6.3 Helps You Master Data Integration
How Stelo V6.3 Helps You Master Data Integration

How Stelo V6.3 Helps You Master Data Integration

Nov 28, 2023 7:45:00 AM 2 min read
Sunsetting: What to Do When Your Data Replication Tool is No Longer Supported
Sunsetting: What to Do When Your Data Replication Tool is No Longer Supported

Sunsetting: What to Do When Your Data Replication Tool is No Longer Supported

Aug 29, 2023 8:46:34 AM 3 min read
Unboxing Stelo V6.1: MERGE Support
MERGE Support

Unboxing Stelo V6.1: MERGE Support

Apr 25, 2023 10:03:00 AM 4 min read
Unboxing Stelo V6.1: PowerShell Scripting, Support for Linux and Container-Based Deployment
PowerShell Scripting, Support for Linux and Container-Based Deployment

Unboxing Stelo V6.1: PowerShell Scripting, Support for Linux and Container-Based Deployment

Apr 18, 2023 9:44:00 AM 3 min read

Get Started

These three steps will help you to ensure that Stelo works for your needs, then seamlessly deploy your solution.


Schedule a Demo

Our expert consultants will guide you through the functionality of Stelo, using your intended data stores.


Get a Free Trial

Test the full capability of the software in your own environment for 15 days. No obligations.


Go Live

When you're ready, we can deploy your Stelo instance in under 24 hours with no disruptions to your operations.