OS commands for DBA As a Database Administrator (DBA), you may need to interact with the operating system (OS) to perform various tasks related to managing databases. Here are some common OS commands used by DBAs: 1. RAM SIZEĀ 2. Find3. SAR4. vmstat5. iostat6. swap7. uptime8. Top CPU users9. Top memory users10. Check disk space11. TOP…

Read More

Pglogical Replication

What is pglogical? pglogical is an extension for PostgreSQL that provides logical replication capabilities. It allows you to replicate data changes (inserts, updates, deletes) at the row level between PostgreSQL databases. Unlike physical replication, which replicates at the block level, logical replication works at a higher level, replicating changes based on database objects (tables, schemas)…

Read More

Configuring Apache Server and Performing Best Practices in Ubuntu and CentOS

Introduction Apache HTTP Server, commonly known as Apache, is a widely-used open-source web server software. It is known for its reliability, flexibility, and scalability, making it the most popular choice for hosting websites. In this article, we will discuss the process of configuring Apache server and implementing best practices in both Ubuntu and CentOS operating…

Read More

Postgresql – Create Database and Add Users.

To create a user in PostgreSQL and differentiate it between schemas, you’ll typically follow these steps: Create the User: You can create a new user in PostgreSQL using the CREATE ROLE statement. Here’s a basic example:

Replace username with the desired username and password with the password for the user. You can also specify…

Read More

PostgreSQL Database Creation and User Creation

Introduction to PostgreSQL PostgreSQL is a powerful, open-source relational database management system (RDBMS) known for its robustness, scalability, and extensibility. It offers a wide range of features that make it a popular choice for both small and large-scale applications. Creating a Database in PostgreSQL To create a database in PostgreSQL, you need to have administrative…

Read More
low-angle photography of metal structure

Understanding Networks: A Detailed Overview of Bits and Bytes

Networking Basics: A Beginner’s Guide for Engineering Students In today’s digital age, understanding the fundamentals of networking is crucial for any aspiring engineer. Whether you’re designing systems, troubleshooting issues, or optimizing network performance, having a solid grasp of networking concepts is essential. In this beginner’s guide, we’ll explore the basics of networking, including IP addresses,…

Read More