Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [centos]

CentOS is a Linux operating system. Questions with this tag should be about administering a database management platform on the CentOS operating system.

CentOS (abbreviated from Community Enterprise Operating System) is a Linux distribution that attempts to provide a free, enterprise-class, community-supported computing platform which aims to be functionally compatible with its upstream source, Red Hat Enterprise Linux (RHEL).

156 questions
30
votes
8 answers

MariaDB Can't init tc log

I've tried every solution on the Internet but my MariaDb server continue to fail, continue to betray me, continue to destroy my tiny DevOps world. My attempts to smooth the situation included all sorts of satisfaction: changing permissions, configs,…
Sam Ivichuk
  • 365
  • 1
  • 3
  • 7
18
votes
3 answers

How to upgrade PostgreSQL from version 8.4 to 9.4?

I want to upgrade my PostgreSQL from version 8.4 to 9.4. The documentation is not very clear to me. Will I lose my old databases if I do the upgrade? How can I backup my old databases if I am to lose them after the upgrade? How can I upgrade my…
Ghasem
  • 549
  • 1
  • 5
  • 12
13
votes
4 answers

Setting root password in fresh mysql 5.7 installation

I am trying to install mysql in a serving having CentOS Linux release 7.2.1511. Take a look to the process installation: # sudo yum install mysql-server Output: Dependencies…
manix
  • 385
  • 1
  • 3
  • 11
12
votes
4 answers

postgresql-setup --initdb with custom data directory

I am trying to setup Postgres 12 on Centos 8. Postgres shall be installed in the default directory i.e. /var/lib/pgsql, however I want the data directory to be in /data/pgsql I want to use postgresql-setup as root, as I believe it will create…
zaidwaqi
  • 221
  • 1
  • 2
  • 3
9
votes
3 answers

How to quickly startup/shutdown Oracle 11?

I am wondering what is the quickest way to properly startup/shutdown a Oracle DB daemon (Oracle 11.2, installed on a test machine). I need it for C/C++ programs that use the OCI/Pro*C API. I want this because I am used to the startup speed of…
maxschlepzig
  • 563
  • 4
  • 6
  • 16
7
votes
2 answers

Mysql enable remote connection in centos,my.cnf does not have bind-address to comment out

I'm trying to make my MySQL Server running on CentOS to allow remote database connections. I'm reading this article that says I should comment out bind-address but bind address is not available in the my.conf, this line is available at…
user46420
7
votes
2 answers

Changing data directory for postgres on CentOS

I've got a postgres 9.2.18 installation on CentOS which used the standard installation path. Now I realised that on this particular partition, there isn't sufficient hard-disk space for some bigger queries. The default data_directory is…
Mayak
  • 181
  • 1
  • 1
  • 3
7
votes
3 answers

Improving RAM and CPU utilization by PostgreSQL 9.6

I've been running a function on the database that is going into each table, ALTER COLUMN on all columns of a certain data type, and CAST to remove trailing zeros. About 115 tables varying from a few thousand records to a few hundred thousand…
cheslijones
  • 413
  • 2
  • 7
  • 12
6
votes
0 answers

Understanding MongoDB Log warning

In my MongoDB log, I am seeing these lines of messages: 2016-04-05T00:03:42.904+0000 I COMMAND [ftdc] serverStatus was very slow: { after basic: 200, after asserts: 240, after backgroundFlushing: 380, after connections: 510, after dur: 650, after…
M T
  • 61
  • 3
6
votes
4 answers

encryption at rest for mysql

A MySQL database needs to contain highly sensitive data that cannot be left unencrypted at rest. But yet the database needs to remain searchable by an app. What are the options for encryption at rest with MySQL? I have looked into CryptDB but it…
CodeMed
  • 497
  • 4
  • 9
  • 15
5
votes
3 answers

mysql "can't create test file" error on Centos

When starting mysql on Centos servers with a custom data directory you might get an error similar to the following: 2014-10-15 10:23:56 17081 [Warning] Can't create test file /database/mysql/localhost.lower-test
Haluk
  • 619
  • 3
  • 12
  • 22
5
votes
1 answer

Receiving "General error: 1030 Got error 168 from storage engine"

I am not sure if this is the right Stack Exchange to post to or not (StackOverflow figured it belonged elsewhere, so maybe it will do better here?) but I keep receiving this MySQL error when I try to install Magento2 on a VPS (Centos6, MySQL…
Rasclatt
  • 155
  • 1
  • 1
  • 6
4
votes
1 answer

Postgres 13/14 JIT execution increase execution time of query considerably

I have a complex DB query that I run on different systems with identical specs, but different OS (CentOS7 vs. Debian 11). The Postgres version is 13.7, but I also tried with 14.4. I get vastly different execution times for the query on both systems…
spa
  • 223
  • 1
  • 2
  • 4
4
votes
2 answers

How do I uninstall the old version of Postgres on CentOS 7?

I just installed Postgres 9.6 on CentOS 7. However when I run [root@server tmp]# /usr/bin/psql --version psql (PostgreSQL) 9.2.23 It still seems to be pointing to my old version. How do I uninstall the old version (or figure out what its called)…
Dave
  • 753
  • 10
  • 22
  • 39
4
votes
3 answers

PostgreSQL service start failed on CentOS 7

Installed PostgreSQL using: sudo yum install postgresql-server postgresql-contrib PostgreSQL version: 9.2.18 When start service: sudo service postgresql start Got error: Redirecting to /bin/systemctl start postgresql.service Job for…
cloud_cloud
  • 353
  • 2
  • 6
  • 12
1
2 3
…
10 11