Backup all the databases in postgres

January 15th, 2022 by ayad
pg_dumpall > all_pg_dbs.sql

Backup database in postgres

January 15th, 2022 by ayad
pg_dump tecmintdb > tecmintdb.sql

Check database size in Postgres

January 15th, 2022 by ayad

SELECT pg_size_pretty(pg_database_size(‘CreatioProDB’));


you can run the following command

postgres=# \l+ forumdb

June 20th, 2020 by ayad

If you received the following error

2020-06-15 09:09:48.816 [nioEventLoopGroup-3-1] tcp – Error in Netty pipeline: io.netty.handler.codec.DecoderException: error:100000c0:SSL routines:OPENSSL_internal:PEER_DID_NOT_RETURN_A_CERTI

you need to include this in the input  ssl_verify => false , refer to the screenshot

Pacemaker (pcs) commands

May 28th, 2020 by ayad

to delete cluster # pcs cluster destory

to remove node # pcs cluster node remove node

to cleanup errors in cluster # pcs resource cleanup

to list constraint # pcs constraint list –full

to remove constraint # pcs constraint remove constraintName for example pcs constraint remove cli-ban-test_sg-on-server01-cpn

to Add constraint

pcs constraint colocation add VirtualIP with HAProxy with mariadb score=INFINITY


pcs constraint colocation set VirtualIP HAProxy mariadb

invalid metric type “dictionary_file_words_count untyped”

April 5th, 2020 by ayad

This problem apparently caused to pluggin:
mysql> SHOW VARIABLES LIKE ‘%dictionary%’;
| Variable_name | Value |
| validate_password.dictionary_file | |
1 row in set (0.00 sec)
To resolve this problem, I disabled in the mysql:
mysql> SELECT @@plugin_dir;
| @@plugin_dir |
| /usr/lib64/mysql/plugin/ |
1 row in set (0.00 sec)
mysql> UNINSTALL COMPONENT ‘file://component_validate_password’;
Restart mysql and the mysqld_export connect to Prometheus.

Error codes explanations

March 12th, 2020 by ayad
The status code is always 3-digit. The first digit indicates a general status :
 - 1xx = informational message to be skipped (e.g. 100, 101)
 - 2xx = OK, content is following   (e.g. 200, 206)
 - 3xx = OK, no content following   (e.g. 302, 304)
 - 4xx = error caused by the client (e.g. 401, 403, 404)
 - 5xx = error caused by the server (e.g. 500, 502, 503)

pulling image error : Get https://docker-registry.default.svc:5000/v2/: http: server gave HTTP response to HTTPS client error: build error: unable to get

February 2nd, 2020 by ayad


 Add –insecure-registry in /etc/sysconfig/docker # vim /etc/sysconfig/docker … OPTIONS=’ –selinux-enabled –log-driver=journald –signature-verification=False –insecure-registry docker-registry.default.svc:5000 ‘ … — Restart docker service to take effect. # systemctl restart docker.service

Which service using which port – linux command

January 20th, 2020 by ayad

$ netstat -tulpn

wait for the sync daemonset to become ready and available

January 11th, 2020 by ayad


need to set this for each master node


refer to the screenshot