Collectd PostgreSQL Plugin

I couldn't find this link when searching with google

https://www.collectd.org/documentation/manpages/collectd.conf.html#plugin-postgresql

Prepend line with line length with Linux command

 awk '{printf "%2d| %s\n",length,$0}' filename

Credit: https://www.baeldung.com/linux/print-longest-lines-in-file#introduction-to-the-problem

How to run packer on Apple Silicon machine to create an image targeting x86 server

Set this environment variable before running packer command. 

DOCKER_DEFAULT_PLATFORM=linux/amd64

How to set memory for Solr on MacOS (installed via homebrew)

Modify this file /opt/homebrew/Cellar/solr/X.XX/homebrew.mxcl.solr.plist to add these lines

<key>EnvironmentVariables</key>

<dict>

  <key>SOLR_JAVA_MEM</key>

  <string>-Xmx2g</string>

</dict>

Save and restart Solr

$ brew services restart solr

How to set Java version for lein

To select specific Java (JDK) to use for leiningen, set environment variable JAVA_CMD

For example,

JAVA_CMD=/path/to/bin/java lein repl

Credit: https://gist.github.com/camsaul/c982019fd915510677236cd4b720a583#gistcomment-3439527 

How to print the longest line in a file?

awk 'length > max_length { max_length = length; longest_line = $0 } END { print longest_line }' ./text

From: https://unix.stackexchange.com/a/24510

Links related to how force macOS to use integrated/discrete graphics

• How to Force Your MacBook Pro to Use Its Discrete Graphics Card When It’s Plugged In
• https://forums.macrumors.com/threads/good-gpu-switching-application-for-mpb-16.2220002/post-28149852

Copied from the above post in case the post is gone

sudo pmset -a gpuswitch 0

-b when on battery

-c when on AC power

-a always

0 iGPU only

1 dGPU only

2 automatic graphics switching

To reset everything back to default:

sudo pmset -a gpuswitch 2