Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: centos-7

Database Directory storage is full need to change link it to new Partition

By adminPosted on January 28, 2023

Question : My mysql Database Directory size is full. So I want to change it to another partition where there […]

Unable to Restart PostgreSQL after attempting to move pg_xlog to different partition

By adminPosted on December 20, 2022

Question : I am having problems getting PostgreSQL back up and running on my CentOS 7 server. Some Context: After […]

Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS

By adminPosted on December 12, 2022

Question : Background I am attempting to install Oracle 12c on CentOS 7 (deployed as a Hyper-V virtual machine) as […]

How to install pgcrypto extension in postgres 10 on CentOS 7

By adminPosted on November 28, 2022

Question : I’m in the process of creating a postgres database for production in CentOS 7. So I already installed […]

Oracle Database Client Installation 12c minimal install – Centos / Red Hat 7

By adminPosted on November 27, 2022

Question : I’m looking at reducing the Linux package prerequisites when installing the Oracle Database Client 12c on the below […]

Can’t run rs.initiate() when do mongodb replication set

By adminPosted on October 19, 2022

Question : Using CentOS 7. MongoDB version: 3.2.15 Hostname: node1 Make directory: mkdir /mongo-metadata /etc/mongod.conf # mongod.conf # for documentation […]

MySQL database not loading table data

By adminPosted on August 12, 2022

Question : My centOS 7 server had an unexpected shutdown. For some reason one of the mysql database shows that […]

Change in bind_ip value is not reflecting

By adminPosted on August 7, 2022

Question : I have mongo installed on Centos instance in AWS and I am connecting to the mongoDB server from […]

How to restart PostgreSQL server under CentOS 7

By adminPosted on June 21, 2022

Question : I installed PostgreSQL 10.1 under a CentOS 7.3 environment. The service is started (postmaster.pid file present under /var/lib/pgsql/10/data), […]

Node unable to join a MariaDB Galera Cluster

By adminPosted on April 22, 2022

Question : I’m trying to setup a third node for my MariaDB cluster. I copied over the server.cnf file from […]

  • 1
  • 2
  • 3

Recent Posts

  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]
  • Help to create indexes to improve query performance and reduce report generation time
  • Error while granting select privilege
  • Native checksum table says there’s a difference, pt-table-checksum does not
  • Row count from a certain table in multiple databases
  • postgres table sizing inconsistency
  • Preserving timezones explicitly in postgres
  • Handling manufacturer mergers
  • MSSQL Server XE column client_connection_id accessible through system view/table for auditing?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding