pg_stat_archiver summarizes archived WAL segments, failures, and when those statistics began accumulating.
How can you tell whether PostgreSQL is archiving its WAL files? The pg_stat_archiver view shows the most recently processed files, archiver failures, and when its counters were reset.
Continue reading “Check PostgreSQL WAL Archiving with pg_stat_archiver”
Review the image, entrypoint, and arguments configured in a Docker container so you can reproduce it or troubleshoot it from the terminal.
What command starts a Docker container? docker inspect lets you check the image and the Entrypoint and Cmd fields saved in its configuration.
Continue reading “Check a Docker container’s command with docker inspect”
Learn the basic UFW firewall operations in Ubuntu 16.04 and derivatives: check its status, enable or disable it, set default rules, and open or close ports.
The default firewall in Ubuntu 16.04 and derivatives is UFW – Uncomplicated Firewall.
In this post, we will see how to perform the most basic operations with this firewall: enable it, disable it, and open and close ports. Continue reading “Manage the Firewall in Ubuntu 16.04 (ufw)”
The default firewall in CentOS 7 / Red Hat Enterprise Linux 7 is firewalld.
In this post, we will look at how to perform the most common operations with this firewall. Continue reading “Manage the Firewall in CentOS 7 / RHEL 7 (firewalld)”
Install MySQL 5.7 on CentOS 7 or RHEL 7 by adding Oracle’s Yum repository, installing the server, enabling the service, and setting the initial administrator password.
MySQL is probably the most popular database engine and, together with Apache and PHP on Linux, forms what is commonly known as a LAMP server.
This article shows how to set up a MySQL Server 5.7 database server on CentOS 7 / RHEL 7. Continue reading “Install MySQL 5.7 on CentOS 7 / RHEL 7”
Install SQL Server 2017 on CentOS 7 / Red Hat Enterprise Linux 7, configure its repository and instance, and connect with SQLCMD.
Por fin podemos instalar SQL Server 2017 en servidores Linux. En esta entrada vemos cómo instalarlo en CentOS 7 / RHEL 7, desde el repositorio hasta la conexión con SQLCMD.
We previously covered installing SQL Server on Ubuntu 16.04; here we will install SQL Server on CentOS 7 / RHEL 7. Continue reading “Install SQL Server 2017 on CentOS 7 / RHEL 7”
