If you get the above error, please follow the below steps. Above error states that postgres is not running. Running pg_lsclusters will list all the postgres clusters running on your device. 2. Most probably the status will be down if we get the above error . Try restarting Postgres clusters and servicesystemctl… Continue Reading Is the server running locally and accepting connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?

Error: Unit mongodb.service is masked when starting the Mongodb Date: 22-03-2021 If you are trying to start the MongoDB service but it’s getting below error. 2. You can use following command to solve the error.# sudo systemctl unmask mongodb 3. Use below command to start the MongoDB service.# sudo systemctl… Continue Reading Error: Unit mongodb.service is masked when starting the Mongodb

If you face the error pg_dump: server version: 11.6 (Debian 11.6-1.pgdg90+1); pg_dump version: 10.10 (Ubuntu 10.10-0ubuntu0.18.04.1) and pg_dump: aborting because of server version mismatch, then you can fix it by upgrading your PostgreSQL client by following the below commands. sudo sh -c ‘echo “deb http://apt.postgresql.org/pub/repos/apt/ lsb_release -cs-pgdg main” >> /etc/apt/sources.list.d/pgdg.list’… Continue Reading How To Fix `pg_dump: aborting because of server version mismatch`

Please follow the below steps to backup the MongoDB.1) Install AWS CLI with the below command.pip install awscli –upgrade –user2) Configure AWS client with the below command.aws configure3) After running the above command it will ask for the below details which are related to IAM user. If you have not… Continue Reading How to backup our MongoDB and push the file into AWS S3 in Ubuntu

How to secure MongoDB databases Date: 22-12-2020 You must edit mongod.conf, MongoDB’s configuration file to enable authentication. Once you enabled it and restart the Mongo service, users will still be able to connect to the database without authenticating. However, they won’t be able to read or modify any data until… Continue Reading How to secure MongoDB databases

We got this Error when we upgraded Bugzilla. This is a normal database error as well. When we ran ./checksetup.pl, we got this error. After following the below steps we upgraded Bugzilla successfully. 1) First we need to check the database version.mysql –version2) If it is below 5.5 then we… Continue Reading The used table type doesn’t support FULLTEXT indexes

How to delete databases in Amazon RDS Date: 13-05-2020 Introduction: Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Amazon RDS Free Tier. It helps new AWS customers get started with a managed database service in the cloud for free. Step 1: Open Amazon RDS… Continue Reading How to delete databases in Amazon RDS

How to enable the mongo Database authentication method Date: 09/01/2020 Introduction Having an authentication for a database can not be a choice. Some may find it not necessary when it confined only use the database locally. It’s incredibly important to set up authentication if you are only using it locally.… Continue Reading How to enable the mongo Database authentication method

Solution to Fix the Character Encoding Mismatch Problem in WordPress Date posted: 29/10/2019 Introduction After switching my hosting account, therefore we might notice special / wired characters on our wordpress blog. This error is due to we have some issue with Database Character Sets in wordpress. If you are facing similar… Continue Reading Solution to Fix the Character Encoding Mismatch Problem in WordPress

MONGODB BASIC OPERATIONS Date posted :11/05/2019 INTRODUCTION: In this tutorial we are going to see about mongodb basic operations. 1)Start mongodb in port The following command used to start the mongodb with the port(27017). 2)Stop mongodb To stop the mongo services the following command used to stop the mongo services.… Continue Reading MONGODB BASIC OPERATIONS