Different types of availability options Azure offers different types of availability options which includes. 1. No infrastructure redundancy required. 2. Availability zone 3. Virtual machine scale set 4. Availability set 1. No infrastructure redundancy required. • This does not provide any redundancy. • When you… Read More
KILLING SESSIONS: In PostgreSQL, you can terminate or “kill” a session using the pg_terminate_backend function. This function allows you to forcefully terminate a specific session, which can be helpful in scenarios where a session is unresponsive or causing issues. We can kill PostgreSQL session in… Read More
How to create the azure account Step-1: Go to google browser and search for portal azure login. Step 2: It will open Microsoft Azure Portal in that select sign in. Step 3: It will open like this, click on to start free for access. Step… Read More
Creation of Image for a VM in Azure Before the creation of an image of the virtual machine install all the software that you want to be installed in all the virtual machines that you want to create with the help of the image you… Read More
Contrib Modules: In PostgreSQL, “contrib” stands for “contributed modules”. These are additional functionalities and features developed by the community that are not part of the core PostgreSQL distribution, but can be easily added to enhance the capabilities of the database. Contributed modules are distributed separately… Read More
Roles In MongoDB Part – 2 User-Defined roles: MongoDB provides many built-in roles to manage the access to the database.but when the built-in roles did not meet your requirement privileges then you can go for creating your own roles. Creation of user-Defined role: To create… Read More
Logging mechanism in PostgreSQL: Logging is the process of recording events, actions, and error messages in a systematic manner for future analysis and reference. In PostgreSQL, the logging mechanism helps track various activities like SQL statements executed, connection attempts, query performance, and errors encountered during… Read More
Roles in MongoDB MongoDB uses Role Based Access Control (RABC) to provide access to any MongoDB system. MongoDB supports multiple authentication methods like x.509 Certificate Kerberos Authentication and may like these authentication methods and the access to the database granted through the role-based authorization. There… Read More
Replication In MongoDB ♦ Replication is the process of creating and maintaining the multiple copies of data across the different servers and also ensuring the copy of the data remains consistent and updated. ♦ Replica set is one of the ways of implementing the replication… Read More
Remote connection from pgadmin4 to a Linux server running PostgreSQL: To establish a remote connection from pgadmin4 to a Linux server running PostgreSQL, Follow the below steps: 1. Install Pgadmin4: First install pgadmin4 on your local machine. You can download it from the official website… Read More
