November 8, 2020November 8, 2020uncategorized postgresql: find email domain from email SUBSTRING(email_clean_from, POSITION('@' in email_clean_from)+1),
November 5, 2020uncategorized unifi: powerbeam change network config through cli https://community.ui.com/questions/SSH-Command-for-changing-default-gateway/7577e1b9-74cc-4288-b8f4-5d2036f57350
November 5, 2020November 5, 2020uncategorized ubuntu: what process is eating my bandwidth? sudo nethogs
November 3, 2020uncategorized pgsql: restore on new server pg_restore -U user_name --create -d database_name --no-privileges --no-owner /home/XXXX/XXXX.sql
November 1, 2020uncategorized postgresql: users and roles On Ubuntu, pg uses the same users as the server.
November 1, 2020March 12, 2021uncategorized ubuntu 18.04: permanently change server host name If you're not happy with leaving an older version somewhere, then simply open the file at /var/lib/cloud/seed/nocloud-net/user-data, and change your hostname at the […]
October 23, 2020uncategorized windows update error Open Powershell SFC /scannow [RESOLVED] How to Fix Windows Update Error 0xc190012e
October 17, 2020uncategorized neo4j: the engine behind panama papers Nine essential tools from ICIJ’s data journalism and programming experts
October 13, 2020uncategorized elasticsearch: relevant commands root@malla:/var/lib# /etc/init.d/elasticsearch restart
October 9, 2020uncategorized win10: monitor outgoing ip connections Run CMD as Administrator netstat -anob