buy tb500

Archive for January, 2022

cluster_admin permission in OKD/Openshift

Sunday, January 30th, 2022

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

trace route with port

Sunday, January 30th, 2022

traceroute -T -p 22 alzwea.com

edit deployments in OKD/Openshift

Sunday, January 30th, 2022

oc edit deployments.apps announcement-portal

snnounvrmrnt-portal = service name

Show shared buffer in postgres

Friday, January 28th, 2022

show shared_buffers;

Show postgres file settings

Friday, January 28th, 2022

select * from pg_file_Settings;

reload postgres database

Friday, January 28th, 2022

select * from pg_reload_conf();

Backup all the databases in postgres

Saturday, January 15th, 2022
pg_dumpall > all_pg_dbs.sql

Backup database in postgres

Saturday, January 15th, 2022
pg_dump tecmintdb > tecmintdb.sql

Check database size in Postgres

Saturday, January 15th, 2022

SELECT pg_size_pretty(pg_database_size(‘CreatioProDB’));

or

you can run the following command

postgres=# \l+ forumdb