Archives
now browsing by author
How to Log Long-running Queries in PostgreSQL and MySQL Databases
You are experiencing slow performance navigating the repository or opening ad hoc views or domains. You enable audit logging but do not see any signifcant long running queries. The problem may be hibernate queries but they do not appear in the audit reports. How do you log the query timesRead More
Howto run and execute a command using SSH on a remote machine
In this mini post, I’ll show you how to run and execute a command using ssh under UNIX, OS X, *BSD, and Linux operating systems on a remote machine. The SSH client program can be used for logging into a remote machine or server and for executing commands on aRead More
Where are PostgreSQL logs files?
When debugging a problem, it’s always frustrating to get sidetracked hunting down the relevant logs. PostgreSQL users can select any of several different ways to handle database logs, or even choose a combination. But especially for new users, or those getting used to an unfamiliar system, just finding the logsRead More
Drop a Specific IP Address and Port with iptables Firewall on Linux Systems
In this article, I’ll show you how to drop a specific IP address and port on Linux systems (RPM Family “Redhat / CentOS / Scientific Linux releases 7 / 6 / 5” and Debian Family “Debian releases 8 /7 /6 and Fedora and Ubuntu). This article will help you toRead More
List of Valid HTML Escape Characters
In this article, I will list almost all the valid escape characters used in HTML/XHTML. This topic may be seems odd as this web site is a Linux Technical blog, but I faced this issue when writing my articles web pages. Each time I write an option starting with “‐‐”Read More
Setup and Configure Basic Firewall Using FirewallD on CentOS 7 Linux System
In this article we will setup and configure the basic firewall using firewalld on Linux systems (RPM Family “Redhat 7/CentOS 7 /Scientific Linux 7”). We will cover how to set up a firewall for your server and show you the basics of managing the firewall. We will enable and startRead More
Howto rename a xen vm “domain” using xl and xm
In this mini post I’ll show you how to rename a xen virtual machine “domain” using either xl or xm management tools. suppose for any reason you want to rename a xen vm from ABC to DEF, we have two options to rename a xen domain “VM”. Option 1: UsingRead More
Howto remove “sudo: sorry, you must have a tty to run sudo” on Linux Systems
In this mini post I’ll show you how to enable sudo command to run remotely on Linux systems (RPM Family “Redhat / CentOS / Scientific Linux releases 7 / 6 / 5”). This mini post will solve this error message “sudo: sorry, you must have a tty to run sudo”Read More
Install and Configure PostgreSQL 9.5 on CentOS 7/6/5 Linux Systems
In this article we will install and configure postgresql 9.5 on Linux systems (RPM Family “Redhat /CentOS /Scientific Linux releases 7/6/5 and Fedora 23/22/21”). We will setup the required repositories then install and configure the postgresql service. PostgreSQL is an open source object-relational, highly scalable, SQL compliant database management system.Read More
Install and Configure PostgreSQL 9.4 on CentOS 7/6/5 Linux Systems
In this article we will install and configure postgresql 9.4 on Linux systems (RPM Family “Redhat /CentOS /Scientific Linux releases 7/6/5 and Fedora 21/20/19”). We will setup the required repositories then install and configure the postgresql service. PostgreSQL is an open source object-relational, highly scalable, SQL compliant database management system.Read More
