Most of the time the default location differs based on the operating system and sometimes depends on the version also the location may change, and also maybe depend on how you install the server. To get the location of postgresql.conf…
Read more here on WiredTiger Storage and the need of application consistency for the MongoDB Check here on adding your AWS account to Nimesa Nimesa supports pre and post script hooks to perform the specific operation before or after a backup,…
PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced…
Information managed by the MySQL server is stored under a directory known as the data directory. Data directory subdirectories. Each subdirectory of the data directory is a database directory and corresponds to a database managed by the server. All MySQL…
MongoDB is a cross-platform, document oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on concept of collection and document. Database Database is a physical container for collections. Each database gets its own set of files…
Recently i posted on Installing MariaDB on AWS EC2 instance and securing the installation. After securing the installation, the root user login is failing with error Access denied for user ‘root’@’localhost’ (using password: YES) The problem is the root user…
The SPOOL is a command causes SQLPlus to write the results to a file on the operating system. Once spool is set, SQLPlus will continue to spool the output until the command SPOOL OFF. Note that the file cannot be…
Day 2 activity of the DBA’s, after setting up the database server and configured all the required privileges and applying the patch, we will create a new database Developers and SysAdmins also should know to create database. Creating database from…
An Oracle database can run in one of two modes. By default, the database is created in NOARCHIVELOG mode. This command will check to see if you have altered your database to run in ARCHIVELOG mode. Set the environment variables…
AWS offers two main options for deploying SQL Server in the cloud – Elastic Compute Cloud and Relational Database Service. I lately read a few blogs and did some searches with both the types of deployment of SQL Server and…
