Author: Rahul

If you are getting above error while restoring backup of database in postgresql. This error means you have taken backup in plain text format. Error: pg_restore: [archiver] input file does not appear to be a valid archive Solution: To restore plain text backup using below command. Backup filename: backup-db.txt Database name: mydb # cat backup-db.txt | psql mydb I hope it will help you.

CouchDB is an open source project and NoSQL, document oriented database server. It stored data with JSON documents. It also provides web interface to access documents online. Click here to read more details about CoutchDB This tutorial will help you to install Apache CouchDB server on CentOS, RedHat 7/6 servers. Step 1 – Enabel Yum Repositories First of all, use below command to install EPEL yum repository on your system. In case epel repository package not found, use this tutorial to install epel package. yum install epel-release-7-11.noarch.rpm Now create yum repository for Apache Couchdb. Create a file /etc/yum.repos.d/apache-couchdb.repo file using…

MySQL Master-Slave replication is to set up slave server to update immediately as soon as changes done in Master server. But it will not update Master if there are any changes done on slave server. Read this article to setup Master-Slave replication. This article will help you to set up Master-Master replication between MySQL servers. In this setup if any changes made on either server will update on an other one. Setup Details: Master-1: 192.168.1.15 Master-2: 192.168.1.16 Database: mydb If you are using different – different versions of MySQL on either servers use this link to check compatibility. Step 1.…

The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. Our earlier article about hadoop was describing to how to setup single node cluster. This article will help you for step by step installing and configuring Hadoop Multi-Node Cluster on CentOS/RHEL 6. Setup Details: Hadoop Master: 192.168.1.15 ( hadoop-master ) Hadoop Slave : 192.168.1.16 ( hadoop-slave-1 ) Hadoop Slave : 192.168.1.17 ( hadoop-slave-2 ) Step 1. Install Java Before installing hadoop make sure you have java installed on all nodes of hadoop cluster systems.…

In this tutorial, you will find a simple bash script for backing up a MySQL database. The script takes a backup of the MySQL database, archives the backup, and stores it on the local system. It also removes older backups to free up space. You can specify the number of days to keep the backup on the local disk. Additionally, you can use this tutorial to back up the MySQL database and store a copy on a remote FTP server. Create MySQL Backup Script Now, copy the following content in a script file (like: /backup/mysql-backup.sh) and save on your Linux…

MySQL replication is a process where a master server replicates its data to one or more slave servers. This can provide several benefits such as increased data availability, improved performance, and easier backups. One important aspect of replication is security, and in this article, we will explore how to configure MySQL master-slave replication with authentication using SSL certificates. By using SSL certificates, we can ensure that the data being replicated is secure and can only be accessed by authorized parties. Additionally, SSL certificates can also be used to authenticate the master and slave servers, providing an additional layer of security.…

As a programmer or developer, it’s common to encounter files with empty lines that need to be removed for better readability and code organization. While manually removing empty lines can be a tedious and time-consuming task, there are several techniques and tools available to streamline the process. In this article, we’ll explore the most effective ways to delete empty lines from files, making your file editing process faster and more efficient. Delete Empty Lines from a File Command-line tools are a powerful and flexible solution for automating file editing tasks. To remove empty lines using command-line tools, you can use…

Debugging is the process of finding and resolving bugs within a computer program. It provides a huge output at the runtime to analyze each part of the execution. Which helps to identify the root cause of any error in the script. In this tutorial, you will learn how to Debug a shell script on the Linux command line. We can debug a shell script in two ways. Either add the debugging instruction in the shell script by using “set -xv” or using -xv on command line while executing script. Adding Debug Instructions in Shell Script Let’s create a small script…

MAC-based filtering is useful for networks using DHCP to assign IP addresses to systems. As we know MAC is hard coded on NIC and can’t be changed but IP addresses assigned by DHCP may change on next IP assignment. This tutorial will help you to how to Configure Squid Proxy Server Mac Address Based Filtering. If you do not have Squid installed, Go to below link for installing squid on CentOS/RHEL/Fedora systems. Install and Configure SQUID Proxy Server on CentOS/RHEL Linux ACL rules are need to add in squid configuration file /etc/squid/squid.conf. Remember that squid Squid always applied first matching…

Squid is the most popular Proxy server for Linux systems. The squid proxy server is also useful for the web packet filtering. Most of the web hosting providers use the Squid proxy for caching the repetitive data to increase website speed. This article will help you to Install and Configure SQUID Proxy Server on CentOS, Redhat and Fedora Linux systems. Step 1 – Install Squid Squid packages are available in default yum repositories. Execute below command on your server to install SQUID proxy server. sudo yum install squid # On CentOS/RedHat Systems sudo dnf install squid # On Fedora Systems…