Linux GREP

UNIQUE/DISTINCT select

grep ERROR postgresql-2020-05-13-00-00-00.log | grep -E "column c.relhasoids" | awk '{ print $6 }' | sort --unique

Поиск пользователей и IP в логах Postgres

grep -E '^.*@.*$' test.log | sed -E "s/^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2} EET ([a-z]{0,}@[a-z]{1,}) (.{0,}) ([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}){1,} [0-9]{2,6} .*$/\1 \2 \3/p" | grep -E '^[a-z].*$' | grep -vE "10.0.1.57|10.0.2.14|10.0.2.15|10.0.2.20|10.0.2.3|10.0.2.5" | sort --unique > 111.txt