Databases
How to Edit Magento Database Configuration File
Magento is a most popular eCommerce software program. In this article you will get details about Magento database configuration file.…
Category: Databases
MySQL, MariaDB, PostgreSQL, MongoDB, Redis and SQL Server: install, manage, back up and tune.
Databases
FATAL: Ident authentication failed for user "postgres"
The “FATAL: Ident authentication failed for user “postgres”” error typically occurs when you are trying to connect to a PostgreSQL…
Databases
Error installing mysql2 Gem on Linux
Error: I have faced following issues during installation of MySQL gem on Linux systems. # gem install mysql2 -v '0.3.18'…
Databases
PostgreSQL: Backup and Restore Database
In the world of database management, ensuring the safety and integrity of your data is paramount. PostgreSQL, with its robust…
Databases
How to Check Postgres Database & Table Size
This guide is designed to assist you in finding out the size of databases and tables on your PostgreSQL server,…
Databases
How to List Databases and Tables in PostgreSQL
PostgreSQL is a powerful open-source relational database management system, known for its robustness and extensibility. As a database administrator or…
Databases
Building a Multi-Node Elasticsearch Cluster on Ubuntu
In the ever-expanding world of big data, Elasticsearch has emerged as a front-runner in the search and analytics engine space.…
Databases
How to Install PostgreSQL 9.6 on CentOS/RHEL 7
PostgreSQL is an open source object-relational, highly scalable, SQL compliant database management system. PostgreSQL is developed at the University of…
Databases
How to Resolve “Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)” Error
If you’ve encountered the error message “Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)” while trying to connect…
Databases
Adding Users and Managing Permissions in MySQL
MySQL is a popular open-source relational database management system that is widely used for web development and data-driven applications. When…