PostgreSQL is an advanced database management system used for storing structured or non-structured data. It supports both SQL (relational) and JSON (non-relational) querying, which makes it more advance than other traditional databases. In this beginners tutorial, you will learn about basic PostgreSQL commands and SQL statements. We have tried to include all basic commands, required for beginners to start working with it. Also, I request all our readers to send their valuable suggestions to improve this article. This tutorial doesn’t cover the installation of the PostgreSQL server. You can visit here to install the PostgreSQL server as per your operating…
Author: Rahul
Rahul
I, Rahul Kumar am the founder and chief editor of TecAdmin.net. I am a Red Hat Certified Engineer (RHCE) and working as an IT professional since 2009..
Read More
Rsyslog is an enhanced version of Linux syslog utility. It provides a very efficient way to setup centralized log server in hosting environment. This article will help you to save log files to MySQL database with easy steps. If you have already configured centralized log server, then you can simply setup database on your central log server. This article is created in two parts, In this page you will find setup of Rsyslog integration with MySQL database. In the next article helps you to install and integrate LogAnalyzer with this setup. Step 1: Install MySQL, Apache and PHP First we…
Rsyslog is logging server used in Linux systems. Its an enhanced version of Syslog. Rsyslog also support databases ( MySQL, PostgreSQL ) to store logs. It is default logging server used from CentOS/RHEL 6 release. Rsyslog is an enhanced version os syslog service in Linux. This article is for configuring Centralized Logging Server in our hosting environment. This article will help you to install Rsyslog service on CentOS/RHEL 5 and configure Rsyslog to send all logs to a central server. Our main aim is that all of our log files should be at on location from where we can easily…
Install PHP Ioncube Loaders . Ioncube is used as encryption/decryption utility for PHP applications by which we can keep safe our data. It also can restrict PHP application to execute unauthorized. It also assists in speeding up the pages that are served. IonCube loaders are used for decoding encoded files while running on the webserver. read more details on official site. This tutorial will help you to install the PHP Ioncube Loaders module in CentOS/RHEL 7/6/5 system. How to Install Ioncube Loader in WHM/cPanel Step 1 – Download ionCube Loader Download latest ioncube loaders on your system from ioncube from…
IonCube are used as encryption/decryption utility for PHP applications by which we can keep safe our data. It also can restrict PHP application to execute unauthorized. It also assists in speeding up the pages that are served. IonCube loaders are used for decoding encoded files while running on a web server. read more details on official site. This tutorial will help you to install IonCube Loaders in cPanel server without recompiling Apache/PHP on cPanel server. If you are not running cPanel server, read article Install IonCube Loader in CentOS/RHEL (non cPanel Server). Install IonCube Loaders in cPanel To install ioncube…
WHM/cPanel is best hosting control panel i used ever. It provides an easy way to manage your server. cPanel provides scripts for most of tasks which can be done using web interface. This article will help you to how to take manual backup of cPanel/WHM user account and restore on other cPanel/WHM server using command line. 1. Backup Account using Commnad Line cPanel provides a command line script to take backup of entire user and there data in an compressed file. For example we need to take backup of cpanel account “myuser”, use following command as root login. # /scripts/pkgacct…
Ubuntu 14.04 LTS (TrustyTahr) released its first Alpha-1 edition on December 19, 2013.This version has been released with Latest stable Linux kernel 3.12 and Firefox 26. For final release we still have to wait for few months. In between of this Ubuntu will release alpha and beta releases. You can find below schedule to releases. Ubuntu 14.04 LTS Release Schedule As per Release schedule of Ubuntu 14.04 LTS the final release is coming on April 17th. The other beta and alpha released dates are as following as per ReleaseSchedule by ubuntu. S.No Release Date 14.04 LTS Release Event 1 December…
The KDE community has released new version 4.12 on December 18, 2013. This release of KDE Platform has been released with few bugfixes and minor optimizations and features. About 20 bug fixes as well as several optimizations have been made to various subsystems of KDE. Changes in KDE 4.12 1. Kate the most advanced Linux graphical text editor has again received work on code completion. Kate also gets initial Vim macro support. 2. Okular the document viewer is now has support of audio and video for epub. 3. KWebKit adds the ability for matching resolution automatically by scaling content. 4.…
Fedora is a Red Hat-Sponsored Community Project, Which has released it newer version Fedora 20 on December 17, 2013. Fedora 20 is live now with lots of changes and upgrades. Using this article, I have tried to explain few major changes in Fedora 20. Read Fedora 20 release notes to know more about it and changes made in this release. Whats New in Fedora 20 Below is the few list of changes/upgrades done in Fedora 20 release. 1. Changing Application Installer Fedora 20 will replace the existing gnome-packagekit frontends (gpk-update-viewer and gpk-application) by a new application. 2. Upgrading to Bluez…
Read Player is one of most popular player for running Audio/Video files in Linux system. This how to guide will help you to install Real Player 11 on CentOS, RHEL, Fedora, Ubuntu and Debian Systems. Step 1: Install Required Packages First make sure you have properly installed required packages to install Real Player. CentOS, RHEL, Fedora Users: # yum install redhat-lsb redhat-lsb-core redhat-lsb-desktop Step 2: Download Real Player Use the following command to download Real Player 11 on your Linux systems, or click here to find latest version. CentOS, RHEL, Fedora Users: # wget http://client-software.real.com/free/unix/RealPlayer11GOLD.rpm Ubuntu Users: # wget http://client-software.real.com/free/unix/RealPlayer11GOLD.deb…