Ayad knowledge base

ALTER ROLE grafana_kms_srv WITH LOGIN;
GRANT SELECT ON ALL TABLES IN SCHEMA company_domain TO grafana_kms_srv;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO grafana_kms_srv;
GRANT USAGE ON SCHEMA public TO grafana_fms_srv;
GRANT USAGE ON SCHEMA company_domain TO grafana_fms_srv;

put the ssh public key of your PC in the following command and run it in any server want to access without password

echo ‘put the public key here’ >> /root/.ssh/authorized_keys

SELECT * FROM pg_available_extensions;
or 
run this in postgres
\dx

oc adm policy add-role-to-user cluster_admin ayad

traceroute -T -p 22 alzwea.com

oc edit deployments.apps announcement-portal

snnounvrmrnt-portal = service name

show shared_buffers;

select * from pg_file_Settings;

select * from pg_reload_conf();

pg_dumpall > all_pg_dbs.sql