Questions tagged [centos-7]
55 questions
29
votes
6 answers
How to restart PostgreSQL server under CentOS 7
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), but I need to reload configuration or restart the server following a change in pg_hba.conf.
However,…
Sébastien Clément
- 1,825
- 3
- 19
- 28
18
votes
3 answers
PostgreSQL 11 error: column p.proisagg does not exist
Using phpPgAdmin v5.6 and PostgreSQL v11.2 on CentOS v7, when I try to access the Functions tab within the public schema, I get the following error:
ERROR: column p.proisagg does not exist
LINE 18: WHERE NOT p.proisagg
…
Sébastien Clément
- 1,825
- 3
- 19
- 28
10
votes
2 answers
Can't run rs.initiate() when do mongodb replication set
Using CentOS 7.
MongoDB version: 3.2.15
Hostname: node1
Make directory:
mkdir /mongo-metadata
/etc/mongod.conf
# mongod.conf
# for documentation of all options, see:
# http://docs.mongodb.org/manual/reference/configuration-options/
# where to…
cloud_cloud
- 353
- 2
- 6
- 12
10
votes
3 answers
Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS
Background
I am attempting to install Oracle 12c on CentOS 7 (deployed as a Hyper-V virtual machine) as outlined by this installation guide.
Problem
Everything with my installation goes well except for the Oracle Database Configuration…
Dodzi Dzakuma
- 275
- 1
- 2
- 15
3
votes
2 answers
mysql backup password without root home
What's the best way to provide a MySql root password (~/.my.cnf) to cron job without root to have the home folder?
the server I'm using is centos
Rait
- 47
- 5
3
votes
1 answer
Mysql showing 100% CPU usage
We are facing problem of high cpu usage for mysql process (almost 100%). Here is the information related to server
Server Infos:
VPS - CENTOS 7.9 kvm - 6 GB RAM - 4 Core CPU - 180 GB SSD - MariaDB
And recently cpu usage was really high,
# uptime
…
Mike Burgmuller
- 31
- 1
- 1
- 2
3
votes
0 answers
mysql 8 is failure to start after upgrade from 5.7
I've upgraded one of the slave server from mysql 5.6 to 5.7 and now 5.7 to 8.
But after up-gradation steps done when i use systemctl start mysqld.service or systemctl restart mysqld facing error and mysql is not starting.
In error log i am getting…
anand aundhekar
- 33
- 7
3
votes
2 answers
SQL Server 2016 - write output file to mapped Samba share (CentOS 7)
I have a stored proc that's going through the tables, getting data, and write the result into a csv file (mainly to provide up to date data for FTP customers).
When writing it to the local D: drive, everything runs fine. File writes as it should and…
Adam
- 41
- 3
3
votes
4 answers
How to best store pixels in a database?
When loading data into a table, I get the following error:
ERROR: row is too big: size 8680, maximum size 8160
The table has 1000+ columns in it, which appears to be the problem. The general internet advice is "refactor!" or "normalize!". For…
Lorem Ipsum
- 133
- 6
3
votes
4 answers
How to install pgcrypto extension in postgres 10 on CentOS 7
I'm in the process of creating a postgres database for production in CentOS 7. So I already installed (yum install postgresql10-server postgresql10 after adding the repos of course) and configured postgres 10. However, in my scripts I need to…
George
- 33
- 1
- 1
- 5
2
votes
1 answer
postgresql 9.3: two instances on same port and two different ip adresses don't work
i'm setting up multiple instances of postgres 9.3 on the same machine (centos 7). I have 2 virtual ip addresses, one instance is bound to first address and second is bound to second one. Same configuration is working on postgres 8.4 and very old red…
SUPERALEX
- 65
- 2
- 5
2
votes
1 answer
When changing the default port number from 5432 to 5332, why do I get a unix domain socket error?
I successfully followed the Postgres 11 installation instructions on Centos 7 found here. I am able to successfully create schemas / tables and insert data into the database over port 5432 with no problems.
Now I would like to change the default…
user1068636
- 453
- 3
- 6
- 13
2
votes
1 answer
MySQL InnoDB Cluster - Add instance issue with local port
I have an issue to add instance to MySQL InnoDB Cluster using MySQL Shell. Here are the steps that I have done:
Login to one DB-01 node
Run command: mysqlsh
shell.connect('username@ip-address:port');
cluster =…
Heril Muratovic
- 123
- 1
- 6
2
votes
1 answer
Cannot login to postgres with newly created users
I have created a number of users in postgres using createuser --interactive --password but whenever I run sudo -i -u newuser I receive the following error:
sudo: unknown user: staging
sudo: unable to initialize policy plugin
I then checked the user…
Brandon
- 235
- 5
- 12
2
votes
1 answer
Database Directory storage is full need to change link it to new Partition
My mysql Database Directory size is full. So I want to change it to another partition where there is large amount of space. The database version am using is MySQL 5.7.23 and OS is CentOS 7.
After searching internet i got 2 solutions. First one as…
Sunil Subramannian
- 23
- 2