Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
ohai.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A cozy, fast and secure Mastodon server where everyone is welcome. Run by the folks at ohai.is.

Administered by:

Server stats:

1.8K
active users

ohai.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.0-nightly.2025-04-15

Continued thread
Public
arabiccola

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
Continued thread
Public
arabiccola

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
Public
AnimeNewsDaily.us

📰 Panty & Stocking with Garterbelt: The Censored Return Under Reiwa's Strict Broadcast Codes

In an era where broadcast codes have become increasingly stringent, "Panty & Stocking with Garterbelt" makes a unique comeback, wrapped in censorship. This version, adorned with beep sounds and CENSORED marks, offers a rare viewing experience as it i...

🔗 Read more: animenewsdaily.us/articles/176

#AnimeNews #TRIGGER #Panty&StockingWithGarterbelt

Panty & Stocking with Garterbelt: The Censored Return Under Reiwa's Strict Broadcast Codes
Public
AnimeNewsDaily.us

📰 Celebrate the Return of Panty & Stocking with Garterbelt with Shibuya Station Ads!

Fans of the iconic anime "Panty & Stocking with Garterbelt" are in for a treat as Shibuya Station becomes the stage for a special advertising campaign. Marking the rebroadcast of this beloved series, from April 7th to April 13th, visitors to Shibuya ...

🔗 Read more: animenewsdaily.us/articles/172

#AnimeNews #TRIGGER #Panty&StockingWithGarterbelt

Celebrate the Return of Panty & Stocking with Garterbelt with Shibuya Station Ads!
ExploreLive feeds
About