Okay, I might be late to the party, but tutotials for tools over #ssh like #lnav (https://github.com/tstack/lnav) does are sooooo cool!

`lnav` is a fab tool for analysing logs. Today I used it for debugging a verbose `strace -f` log file to analyse what the problem was w/smth and it was cool

Tip: hit `<tab>` to edit, enable, and disable existing text filters added w/e.g. `:filter-in` and `:filter-out`.

#lnav #Linux #Logs #strace #debugging #ArchLinux #Tools #DebuggingTools #Sysadmin #CommandLine

Confused by `info: No log or text files are currently loaded` when not run as root · Issue #1519 · tstack/lnav

lnav version Latest, v0.12.4, built from source Describe the bug I am unable to open my PostgreSQL logs with lnav without root privileges. To Reproduce Currently, after navigating to the logs folde...

GitHub

So I'm googling+udm14 if someone has made an lnav format for minecraft (client + server) logs: "lnav minecraft log".

First link is the #lnav page, but without mentioning #minecraft.

Second link is from minecraft wiki:

"There are nine types of logs: oak, spruce, birch, jungle, acacia, dark oak, mangrove, cherry blossom, and pale oak; and two types of stems: crimson, and warped."

Right... I need to be more specific.

#unix

(Joke aside, it should be #log4j, but lnav doesn't recognize it.)

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 [email protected]` 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

https://www.youtube.com/watch?v=Su6aUb2yM1g&t=64s

Introduction to lnav

YouTube

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

https://www.marcusjaschen.de/blog/2024/2024-47/

Rückblick Kalenderwoche 2024-47

🪵 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

Marcus Jaschen