Category Linux

PostgreSQL 18 Streaming Replication
Linux, PostgreSQL

Streaming Replication with PostgreSQL 18 on RHEL 10

by jb

PostgreSQL continues to be one of the most popular open-source database platforms for enterprise workloads, and the release of PostgreSQL 18 brings further improvements in performance, scalability and reliability. When deploying PostgreSQL in production environments, high availability and data protection are key considerations, making streaming replication one of the most important technologies to implement.

In this blog post, we will walk through the installation of PostgreSQL 18 on two Red Hat Enterprise Linux 10 virtual machines and configure a primary/standby architecture using PostgreSQL streaming replication. The guide covers the complete setup process, including package installation, database initialization, replication configuration, creation of a standby server and validation of the replication environment.

By the end of this tutorial, you will have a fully functional PostgreSQL replication setup that can serve as the foundation for high-availability and disaster-recovery solutions in enterprise environments.

Read More

0
Debugging PostgreSQL with VS Code
Linux, PostgreSQL, Windows

Debugging PostgreSQL with Visual Studio Code

by jb

Debugging a database system often requires looking beyond SQL statements and configuration parameters. When investigating complex issues, understanding what happens inside the PostgreSQL source code can provide valuable insights into query execution, process behavior and internal database mechanisms. For developers, contributors and advanced database administrators, the ability to step through PostgreSQL code can significantly simplify troubleshooting and performance analysis.

Read More

0
Install Oracle APEX26.1
APEX, Linux, Oracle

Oracle APEX 26.1 Installation

by jb

Installing a modern Oracle application stack has become significantly more interesting with the introduction of the new Oracle Database AI Database 26ai release and the latest generation of Oracle development tools. Combining Oracle APEX 26.1, ORDS 26.1, GraalVM 21, GraalJS and Apache Tomcat 9 on Oracle Linux 9.7 provides a powerful and flexible platform for building modern low-code and data-driven web applications.

In this blog post, we will walk through the complete installation and configuration process of:

  • Oracle APEX 26.1
  • Oracle REST Data Services (ORDS) 26.1
  • GraalVM 21 and GraalJS
  • Apache Tomcat 9

The goal is to create a clean and production-ready APEX environment that leverages the latest Oracle technologies while remaining easy to manage and maintain.With Oracle increasingly integrating AI capabilities directly into the database platform, Oracle AI Database 26ai also opens interesting possibilities for future APEX applications involving vector search, AI-assisted workflows and modern data services.

This guide is intended for Oracle DBAs, developers and infrastructure engineers who want to deploy a modern Oracle APEX stack on Linux using current Oracle-supported components and best practices.

Read More

0