Search results

You can follow below steps to install and configure PostgreSQL. First you have to run below command to install. /usr/local/cpanel/scripts/installpostgres Now login to WHM and go to WHM >> Home >> SQL Services >> Configure PostgreSQL After that you have to click on “Install Config”, if you do...

If you have installed latest version of PostgreSQL and getting issue then you can easily revert tots previous version to make it working. You can run below commands: service postgresql stop mv /var/lib/pgsql /var/lib/directory_file_name mv /var/lib/pgsql.old /var/lib/pgsql service postgresql...

If you want to install latest version of PostgreSQL then first you have to take backup of your database and then try to install or update database. To take backup it is must to have access of root user, you can follow below steps: Login via SSH You can run below command to take backup of your...

You can follow below steps: Log into WHM. Here you will find “Service Configuration” option, you have to click on it. Now click on “Service Manager” option. You will find “Monitor” column checkbox, you have to deselect it. This option will prevent automatic restart of PostgreSQL service.

Memcached is an incredibly powerful caching tool that can significantly speed up your website. So it isn’t quite a surprise to know that many web hosting plans come with Memcached installed on the Linux server. But there are times when you’d want to get rid of it for an alternative, let’s say...

Your resource in the system has some limitations! It keeps an eye on each web server activity to inform when it crosses its limitation. You can even say it as behavior that happened unexpectedly! It crosses it's over limitation to inform you like a warning at starting stage. Later it forces the...

Do you want to set up CentOS 7 server? Co-join with the control panel for managing the graphical user interfaces web application and website at the same time. You might know more about WHM/cPanel! It is one of the best solutions for web hosting management. It gives you the perfect user-friendly...

Let us start with the question here! Between the processor and hardware of the computer, there comes the interface of the core component. What is the core interface between the processor and hardware? The core interface that operates in Linux operating system is Linux Kernel. Linux Kernel is the...

Linux administrators – The role of a Linux administrator is not an easy task! They take responsibility to manage the data, software and hardware. Of course! They need to protect from outsourcing hackers and monitor the performance on daily basis. Even Linux distribution has so many tools to...

How will you find that the server has been hacked? Do you know the traces to identify the hacked server? Yes! One of the providers or data centers may restrict you being entering into their circle. Your website shows traces of malware activity or services may get failure repeatedly. These are...

Animations make websites vibrant and user-friendly. If you’ve designed your website using Drupal 8, you might be wondering if you can create animated slideshows. The answer is, yes, you can. There are a few modules that allow you to create slideshows with ease. You’d be able to set image...

With MySQL governor we can set the limits of LVE for MySQL users and its provided by CloudLinux. You can use below command to install MySQL governor package: yum install governor-mysql Now we have to select the MySQL version and version should be one of the below...

If you want to DROP MySQL users manually then you can check this article. Sometime we need to DROP users to resolve the issue then here is the solution: You can run below command to DROP user: mysql mysql -e "DROP user '$USER'@'$HOST';" In this command you have to replace $USER with your...

You can lock MySQL user from MySQL database and also unlock them. You can only modify MySQL user with root privileges and that’s why it is must to have root access. You can login to MySQL as a root use this command: # mysql Now you have to run below command to lock user: ALTER USER...

If you want to use MySQL database remotely then you have to create MySQL user too. You can follow below steps to create MySQL remote user: Login to cpanel. Here click on “Remote MySQL” under Databases. Now you have to enter your IP address to allow MySQL server. Click on “Add Host”. You can...

Do you know to increase the security for Windows Internet Information Services? Yes! It is possible by doing three methods such as restricting IP address, issuing certificates for clients and configuration of authentication. This is specifically for people who work in the IT field because of the...

If you are using dynamic IP address to make connection with MySQL remotely, its little bit tricky to allow dynamic IP Address because it changes frequently. You can add wild card IP’s in Remote MySQL option. For Example: As we know whenever the IP address changes only its last 2 digits updates...

If you want to enable mysql error log then explicitly you have to enable option /etc/my.cnf file and after that you have to restart mysql service. You have to follow below steps: Login to server via SSH as root. Here check your /etc/my.cnf file and add below line in [mysqld] section...

If you are using MySQL 8 version then you must know that Event Scheduler is enabled by default. You have to modify etc/my.cnf file, you have to add below line under [mysqld] section. event_scheduler=off After that you have to restart mysql service to reflect the changes.

You can increase the max_allowed_packet in my.cnf file. You have to edit my.cnf file and add below line in my.cnf file. First you have to find [mysqldump] section in /etc/my.cnf file and then add below code : [mysqldump] max_allowed_packet=268435456 You can add value according to your choice.