psylogical.org

test

ahoj

Install required packages
apt install apt-file
apt-file update apt-file list package_name

List systemd service start time
systemd-analyze blame

Docker notes, related to docker-compose mostly

List running "physicall node"
docker node ls

List services on node
docker service ls

docker service ps SERVICE_ID

In order to log to running container

ansible hostname -m setup

File operators:

Posgtesql cheat sheet, use with caution, most compatible with mysql

connect to db
\c db_name;

create database
create database db_name;
list databases
\l

Turn off adding spaces to newline when copy to vim

:set paste

revert with
:set nopaste

How to clean postgresql db without actually dropping it

connect to desired db
\c db_name

check db schema
\dn

delete tables
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;