Skip to content

ZFS

PostgreSQL Snapshot Backup and Restore with Proxmox ZFS (4/4)

In the blog series I previously wrote, I did not answer all the customer’s questions. The last one was the following: Can this also be applied to PostgreSQL? In short, yes, it is possible. Let’s see how. Here is the list of the previous blog posts: Partitioning and filesystem We will reuse the sqlpool ZFS pool created in the first… 

SQL Server Snapshot Backup and Restore with Proxmox ZFS – REST API with SQL Server 2025 (3/4)

The proposed architecture consists in adding a small internal REST API on the Proxmox server in order to expose a controlled ZFS snapshot operation. SQL Server 2025 can then call this API through sp_invoke_external_rest_endpoint, instead of running SSH commands directly or relying on an external tool. The role of the API is deliberately limited: it receives a snapshot request, checks… 

SQL Server Snapshot Backup and Restore with Proxmox ZFS (1/4)

We are currently working with clients on migrations to SQL Server 2022 and SQL Server 2025. During a discussion with one client, we reviewed some of the benefits introduced in the latest SQL Server 2022 and 2025 releases. Among the available features, starting with SQL Server 2022, we have: Starting with SQL Server 2025: The customer’s environment consists of a… 

Installing ZFS on OEL7 UEK4 for Docker storage

By Franck Pachot . The Oracle Database is fully supported on Docker according that Linux is Red Hat Enterprise Linux 7 or Oracle Enterprise Linux 7 with Unbreakable Enterprise 4. This is documented in MOS Note 2216342.1. Given the size of the Oracle database in GigaBytes even empty, the way it is installed at build with many file updates, and… 

Running PostgreSQL on ZFS on Linux – Compression

In the last posts in this little series we looked at how to get a ZFS file system up and running on a CentOS 7 host and how snapshots and clones can be used to simply processes such as testing and cloning PostgreSQL instances. In this post we’ll look at another feature of zfs: Compression. The current status of my… 

Running PostgreSQL on ZFS on Linux

ZFS for Solaris is around for several years now (since 2015). But there is also a project called OpenZFS which makes ZFS available on other operating systems. For Linux the announcement for ZFS being production ready was back in 2013. So why not run PostgreSQL on it? ZFS provides many cool features including compression, snapshots and build in volume management.…