November 1, 2026 · Zwiegnet Consulting
Set up PostgreSQL 18 streaming replication on AlmaLinux 10 with a replication slot, verify it, then perform a switchover, an unplanned failover and rejoin the old primary with pg_rewind.
Read More
October 31, 2026 · Zwiegnet Consulting
Back up and restore PostgreSQL 18 on AlmaLinux 10 with pg_dump, pg_dumpall –globals-only and pg_basebackup, verify backups with pg_verifybackup, and schedule nightly dumps with a systemd timer.
Read More
October 30, 2026 · Zwiegnet Consulting
Build a least-privilege PostgreSQL 18 permission layout on AlmaLinux 10: owner, read-only and read-write group roles, login roles, CONNECT and schema grants, ALTER DEFAULT PRIVILEGES, pg_hba.conf group rules, and safely dropping roles.
Read More
October 29, 2026 · Zwiegnet Consulting
Install PostgreSQL 18 on AlmaLinux 10 from AppStream or the PGDG repo, run initdb, configure pg_hba.conf with scram-sha-256, and allow remote access through firewalld with SELinux enforcing.
Read More
October 14, 2026 · Zwiegnet Consulting
List all databases on a Microsoft SQL Server instance with SSMS, a sys.databases query, sp_databases, sqlcmd or PowerShell.
Read More
September 18, 2026 · Zwiegnet Consulting
Install Oracle Express Oracle Linux 6 Install Oracle Express Oracle Linux 6 Preparing Oracle Enterprise LinuxDisk/Swap Setup As you can see we have root VG for the OS (60GB)/home Volume…
Read More
September 13, 2026 · Zwiegnet Consulting
Index SQL Server Database Index SQL Server 2008R2 Database Every once in a while it’s a good idea to re-index your tables when you are using Microsoft SQL Server. Unlike…
Read More
August 30, 2026 · Zwiegnet Consulting
Mount SAN Volume Oracle Linux Mount SAN Volume Oracle Linux iSCSI is used as an alternative to FibreChannel San, and is relatively easy to setup and configure. This allows failover,…
Read More
August 14, 2026 · Zwiegnet Consulting
Create New Database SQL Server Create New Database SQL Server 2008R2 The first thing you need to do is open SQL Server Management Studio from here login with the necessary…
Read More
August 12, 2026 · Zwiegnet Consulting
Percona Live Amsterdam (September 9-11, 2026) brings together MySQL, PostgreSQL, Valkey, MongoDB and MariaDB users to talk about running open source databases in production.
Read More