mencargo

Useful PostgreSQL Queries & Commands

All sizes in MB, change /1024/1024 to /1024/1024/1024 for GB.

Databases sizes

Without system databases

select
datname as database,
(pg_database_size(datname)/1024/1024) as size

mencargo

Some useful Linux commands

Disk usage

df -h

Folder size

du -sh folder

Files created last week / past 12 hrs

mencargo

DNSmasq for local DNS service:

Config file usualy in /etc/dnsmasq.conf

no-resolv
user=root
server=8.8.8.8
server=1.1.1.1
server=9.9.9.9
cache-size=6400

mencargo

Cleanup

clear all logs of CP

rm -rf /usr/local/lsws/logs/*

clear OpenLiteSpeed cache folder

rm -rf /usr/local/lsws/cachedata

remove old CyberPanel versions

mencargo

cPanel

mkdir -p /root/cpanel_profile && echo "mysql-version=10.3" > /root/cpanel_profile/cpanel.config
cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest

Delete garbage files

mencargo

BASH (~/.bashrc)

# Simple git prompt
COLOR_GIT_CLEAN='\[\033[1;30m\]'
COLOR_GIT_MODIFIED='\[\033[0;33m\]'
COLOR_GIT_STAGED='\[\033[0;36m\]'
COLOR_RESET='\[\033[0m\]'

function git_prompt() {

mencargo

List available official WSL distros:

> wsl --update
> wsl --list --online

Update locale inside debian:

$ sudo update-locale LANG=en_US.UTF8