Question : My centOS 7 server had an unexpected shutdown. For some reason one of the mysql database shows that […]
Tag: centos-7
Change in bind_ip value is not reflecting
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
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
Question : I’m trying to setup a third node for my MariaDB cluster. I copied over the server.cnf file from […]
Can’t promote PostgreSQL warm standby server to start serving data
Question : Scenario: Two CentOS 7 machines, with ips 10.0.2.15 and 10.0.2.4 Both running PostgreSQL 9.4.6. First one (10.0.2.15) as […]
Binding specific ips with Mongodb
Question : I am using Mongodb 3.6.3 on Centos 7. I am running the below command: sudo mongod –storageEngine wiredTiger […]
No speedup using parallel restore with pg_restore
Question : I need a large database like 10TB-15TB in Postgresql for benchmarking. I’ve created a smaller ~100GB sample databases […]
How to debug trivial MariaDB query with simple execution plan which often runs really slowly?
Question : The query (with literal ? for dynamic query goodness): SELECT UNIX_TIMESTAMP(my_timestamp_field) AS my_name FROM my_table WHERE my_column=? This […]
PostgreSQL 11 error: column p.proisagg does not exist
Question : Using phpPgAdmin v5.6 and PostgreSQL v11.2 on CentOS v7, when I try to access the Functions tab within […]
Parse error in pg_hba.conf [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
- 1
- 2