PS: I also discovered you can modify the `lnav` behaviour by only showing new logs at the time of using the SSH command above:
```
#!/usr/bin/env bash
export TZ='Europe/Berlin';
NOW="$(date -Iseconds | sed -e 's/+.*$//')"
LOG_FILE="$(ls -t ~/pgdata/data/logs/*.log | head -n 1)"
if [ "$1" = "now" ]; then
lnav "$LOG_FILE" -c ":hide-lines-before $NOW"
else
lnav "$LOG_FILE"
fi
```
#ssh #lnav #postgresql #postgres #trigger #debugging #troubelshooting #pg_net #supabase
I ended up adding an SSH user called `postgreslogs` which serves as a way to SSH directly into the logs using:
- A `ForceCommand` SSH daemon config for the user
- A `sudoer.d` config to allow postgreslogs to elevate (i.e. sudo) to postgres (the DB admin account) without a password
Works really nicely! All you need to do to see the logs is to `ssh postgrelogs@postgreshost.proxmox` or similar!
#ssh #lnav #postgresql #postgres #trigger #debugging #troubelshooting #pg_net #supabase
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
🔊 In dieser Woche gehört: Tommahawk, Lena Brysch
#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/
Log View Viewer für macOS ???
Es ist keine wirkliche Freude auf einer Sophos Firewall die Logfiles durchzustöbern. Zum Glück gibt es dort aber die Möglichkeit, besagtes Logfile sich runterzuladen. Nun war ich auf der Suche nach einer App, mit der man größere Logfiles einigermassen angenehm durchsuchen und darstellen kann. Ich habe aus dem Mac AppStore die App "
https://ostermeier.net/wordpress/2023/06/log-view-viewer-fuer-macos/
#macOS #lnav #LogViewer #LogfileViewer #macOS #SublimeText
@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.
Just a quick shoutout to the #lnav log analyzer. It makes my life so much better. It’s #FOSS for small #server setups and works on pretty much any #Unix system. If you’ve ever used #multitail, this is for you.
“Many logging tools, like Splunk, provide great features but are optimized for large-scale deployments. They require installing and configuring servers before they can be effectively used. There is still a need for a robust log file analyzer for the terminal.”
#lnav is a log file navigator.
lnav is a program which reads log files and displays their combined contents in chronological order. lnav highlights and colorizes relevant or important information, including actions and errors. lnav understands several log formats, can create timestamped logs from any program output, and can filter by regex or SQL.
Website 🔗️: https://lnav.org/
apt 📦️: lnav
Découverte de #lnav afin de simplifier la navigation dans les logs (compressés ou non). Plutôt sympa :)
https://github.com/tstack/lnav
#lnav – Un visualisateur de fichiers de logs libre et pratique #korben https://korben.info/lnav-un-visualisateur-de-fichiers-de-logs-libre-et-pratique.html
