Encrypt Files CentOS Linux
Encrypt Files CentOS Linux Encrypt Files CentOS Linux One way to protect sensitive information on Linux, usually in the example of removable media, tape, flash drive, or removable hard drive…
Read More
Configure CUPS Printing on CentOS
Configure CUPS Printing on CentOS Configure CUPS Printing on CentOS when you need to setup a CentOS Linux print server, CUPS (Common UNIX Printing System)to the rescue! login to your server, and su…
PostgreSQL Performance Tuning on AlmaLinux 10: postgresql.conf, EXPLAIN ANALYZE, Indexes and Autovacuum
Tune PostgreSQL 18 on AlmaLinux 10: size shared_buffers, work_mem and WAL settings, enable pg_stat_statements, read EXPLAIN ANALYZE plans, add the right indexes and keep autovacuum ahead of the workload.
Zimbra Community Mailbox Size CentOS 6
Zimbra Community Mailbox Size CentOS 6 Zimbra Community Mailbox Size CentOS 6 To find the mailbox size of an individual user for Zimbra, you have to be logged into Zimbra…
PostgreSQL Streaming Replication on AlmaLinux 10: Primary/Standby Setup, Switchover and Failover
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.
Configure LDAP group for SUDO CentOS 6
Configure LDAP group for SUDO CentOS 6 Configure LDAP group for LOCAL SUDO CentOS 6 ** THERE IS A BETTER WAY TO DO THIS THAT YOU SHOULD CONSIDER** 389 Sudo…
PostgreSQL Backup and Restore on AlmaLinux 10: pg_dump, pg_dumpall and pg_basebackup
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.
Umask CentOS 6 Permissions
Umask CentOS 6 Permissions Umask CentOS 6 Permissions Let’s face it, the default perimssions for CentOS 6 are a pain. Basically only owner can do anything, it completely ignores basic…
PostgreSQL Users, Roles and Privileges on AlmaLinux 10: GRANT, Default Privileges and Group Roles
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.
Install PostgreSQL on AlmaLinux 10: PGDG vs AppStream, pg_hba.conf and Remote Access
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.