Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.
#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration
Wochenrückblick, Ausgabe 68 (2024-47)
Themen:
Woodworking Level-Up: Drechselbank
CLI-Tool der Woche: lnav
European alternatives for popular services
Web Share API
FreeCAD 1.0.0
EpisodeHive
#Wochenrückblick #CLI #Shell #lnav #Drechseln #Holz #Woodworking #Woodturning #Europe #WebShareApi #FreeCAD #Onshape #Fusion360 #Autodesk #Episodehive #IMDB #TV #Techno
Cool, das kannte ich noch nicht: #lnav
https://www.cyberciti.biz/open-source/lnav-linux-unix-ncurses-terminal-log-file-viewer/
#lnav, short for Log File Navigator is a command-line tool designed to make log analysis more intuitive and efficient.
https://github.com/tstack/lnav
I like the functionality to execute SQL queries directly on log files and today I discover that I can visualize data using #Gantt charts 
You can test lnav from your terminal `ssh playground@demo.lnav.org` and there is also a tutorial `ssh tutorial1@demo.lnav.org`
lnav 0.12 Released with Gantt Chart View of Log files
https://debugpointnews.com/lnav-0-12/
@jschauma add a segment on #log parsing to your #systemadministration class (if you see fit). It's painful to learn from scratch with no guidance. The class is already wonderful, but I think that's something that I could have benefited from, given my current headache and work assignment.
My current solution is a combination of #ripgrep, #lnav, and profuse swearing and sweating! If that's the best anyone has figured out though, so be it!
@maxandersen If you forgive the shameless plug, may I recommend you also give @binjr a try for this kind of tasks?
It seems close to what #lnav does (didn't know about it before, btw, so thanks for the heads up!) with a few diffs: for one it is GUI based (but cross platform, built with #javafx) instead of command line, so that's one more option.
And it also offers visualization features beyond log files.
