Month: November 2016

Another article relate to Logical Volume Management discuss specifically how to display an information about existing or available logical volume in a server, workstation or a host with a specific command as one way to do it simply. The command itself must be executed in root privilege and it is generally typed in the bash prompt.

To display an information about existing or available volume groups in a server, workstation or a host, there is only one way to do it in a simple way. It is done by executing or typing the suitable command in a bash prompt.

Sometime, there is a certain need to check the timezone of a running PostgreSQL Database Server. The value of timezone configured or set in a running PostgreSQL Database Server will determine the value of the query retrieved by a person, a database administrator, applications even systems which is asking the current time accordingly to PostgreSQL Database Server as shown below :

select now()

When the above query executed in PostgreSQL Database Server as shown below :

In this article, change hostname in Linux operating system will be explained using command line. As long as the interface of the operating system itself can be accessed via CLI (Command Line Interface) as a root user, the purpose of changing the hostname can be achieved.

First, check the original hostname by typing the following command in the bash prompt :

This is an article which is made to solve problems on searching files or folders containing large files. After finding out that a server has its own space storage slowly running out, it is important to retrieve or to reclaim some space by searching unused or unimportant files, folders scattered in the server.

The method used for searching those files and folders is by executing the sort command from the top level directory and then re-execute it in the lower level directory which is indicated containing larger size folder or files.

In this article, there will be described several ways used to check the currently running MySQL Database Server. Before checking the version, there are several things before which is needed to be done.

1. The first step which is the most important step is to make sure whether MySQL Database Server has already installed or not. Depends on the package manager or utility used to administer package, program, files or utility used in the current Linux operating system used, the way to do it also vary. One of an example that can be used is taken from the article titled ‘Installing MySQL Server in Ubuntu 16.04‘.

2. After successfully installed MySQL Database Server. The next step is to check whether the service itself which in this context is MySQL Database Server’s service has already up and listening for incoming connection or request. The following article can be a reference to check the current service’s status titled ‘Check MySQL Service Status‘.

3. So, if the service is up and ready to listen for incoming connection, the version can be checked by typing the following command :

In this article, there will be a few commands which can be used to check harddisk size in Linux operating system. Since it is a command, it is obviously that it is done in a CLI (Command Line Interface) environment or in a text-mode display.

The command itself has been executed and tested in Ubuntu Linux 16.04 and most likely since the command itself is a general command available that exist in most of Linux distribution variant, it can also be executed in those Linux distribution variant operating system.

1. The first command is fdisk. This command is combined with a optional parameter -l. Below is the full command execution :