Show running process in postgres I mostly use the MySQL server and very much familiar with its commands and how it works. Today I was checking How to check the running process in Postgresql. In MySQL we use show processlist; command. In Postgresql,to show running process in postgres use below given command Step 1: Login…
Set group password,its use and check which group after newgrp command in linux As per the title of my post it has 3 questions: (1) How to set group password in Linux ? (2) What is its use ? (3) How to know you are using which group after using command newgrp ? How to…
How to set -m option as default in useradd command in linux Using -m option with useradd command create the user’s home directory . In Debian and Ubuntu when we simply use useradd command without any option bydefault it do not create user’s home directory in /home whereas in CentOS and Red Hat when you…
While working today on setting Amavisd-new,Clamav and spamassasin in Ubuntu 12.04 LTS,I got the below given error. Jul 23 12:20:47 mail postfix/qmgr[18020]: 0D1AF61F95: from=, size=739, nrcpt=1 (queue active) Jul 23 12:20:48 mail amavis[18032]: (18032-02) (!)run_av (ClamAV-clamd) FAILED – unexpected , output=”/var/lib/amavis/tmp/amavis-20130723T122047-18032-utKqe6rf/parts: lstat() failed: Permission denied. ERRORn” Jul 23 12:20:48 mail amavis[18032]: (18032-02) (!)ClamAV-clamd av-scanner FAILED:…
Set hostname and FQDN in Ubuntu without reboot I will first start with definition of FQDN because many people have confusion over it. Hostname and FQDN both are little bit different.It is best to give the reference from wikipedia so that there should be no dispute. FQDN or Fully Qualified Domain Name: With reference form…
In this post we will learn How to set DHCP offered ip address to particular ethernet in freebsd. I freshly installed the freebsd 9.0-RELEASE in Virtual box. I added two ethernet or NIC to virtual machine. After restart I found only my first ethernet has the ip address. The second ethernet does’not have any ip….
Error: Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-9.0-release/Latest/vim.tbz This was my first encounter with problem while working in freebsd after doing fresh install.I was trying to install vim in freebsd by using the command pkg_add -r vim I got this below given Error: Error: Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-9.0-release/Latest/vim.tbz: File unavailable (e.g., file not found, no access) pkg_add: unable…
Setup Master Slave DNS in CentOS 6 or Red Hat 6 In this tutorial we will learn about how to setup Master Slave DNS in CentOS 6 or Red Hat 6. DNS is a big concept and the Internet World run on it.In this post I tried to write the how to as simple as…
While reinstalling the owncloud in Ubuntu I got this error message on screen when I hit the URL of owncloud – “Your data directory and files are probably accessible from the internet because the .htaccess file does not work”. To solve this issue. We have to only correct our apache configuration file. In owncloud.conf file…
create and delete user examples in Red Hat and CentOS In this tutorial we will learn about creating and deleting the user in Red Hat and CentOS. In this post we will explore the useradd and userdel commands. Basic command to create user In Red Hat and CentOS,create a user and set password as per…
How to use email id of Gmail for sending nagios email alerts In this tutorial we will learn about how to use email id of Gmail for sending nagios email alerts. Requirement: (1): Create one email id of gmail for sending emails from nagios server eg. nagiosalerts@gmail.com (2): Using ssmtp package . As per man…
Swap space can be a dedicated swap partition , a swap file or a combination of swap partitions and swap files. In this article, we will learn to find swap partition or swap file in the Linux Operating System. Methods to find the swap partition / file The given below are the mostly used methods…
In this post, learn how to convert video file into gif file through command line in linux. For converting the video file into gif file there are many methods. We tried most of the methods. We used some software package like mplayer and image-magick. Image-magick has one issue that is related to memory allocation. With…
ISO file is known for archive file of optical disc like CD/DVD . ISO name has been taken from ISO 9660.The .iso file extention is mostly used for disc images. In Linux you can also create .iso image of directory.The method will help to take archive of desired directory in filesystem. It has one more…
Learn tar command and know about its precaution Tar(Tap Archive) command is used in Unix like operating system for archiving the files. Archive is a file which has number of files and these files can be extracted to its original format with the help of extraction programmes. These archived files are called tarballs. If you…