My Postgres environment

September 23, 2021
PostgreSQL

Last week, I gave my “psql is awesome” conf talk for the last time. Each time I explain how I love working with CLI and why having inputs and outputs in text format is great, some people come to ask me to explain how I use my terminal. So I think it’s time to explain how I work.

Tmux

First, I work with tmux as a terminal multiplexer. Tmux is so integrated with my terminal that I have added those lines into my .bashrc file to always start the terminal inside tmux. And before you say it, yes, I know I should switch to zsh, it’s on my todo.

# Tmux by default
if command -v tmux &> /dev/null && [ -n "$PS1" ] && [[ ! "$TERM" =~ screen ]] && [[ ! "$TERM" =~ tmux ]] && [ -z "$TMUX" ]; then
     exec tmux
fi

My .tmux.conf file

I customize my tmux configuration like this:

# window management {{{
unbind %
unbind \"
unbind s
bind | split-window -h
bind _ split-window -v
bind-key S command-prompt "attach-session -t '%%'"
bind-key s choose-session
# }}}

# Vi style bindings {{{
setw -g mode-keys vi
unbind Escape

bind h select-pane -L
bind j select-pane -D
bind k select-pane -U
bind l select-pane -R
bind-key Y run "tmux save-buffer - | xclip -i -selection clipboard &> /dev/null"
# }}}

# Resizing {{{
bind < resize-pane -L 5
bind > resize-pane -R 5
bind - resize-pane -D 5
bind + resize-pane -U 5
# }}}

# bind reload key
bind-key r source-file ~/.tmux.conf \; display-message "Config reloaded!"

# More history!
set -g history-limit 50000

Normally the comments should explain what they do. If you don’t know tmux, you’ll find great beginner’s guides on the internet.

The tmux-logging plugin

On top of tmux, I use a tmux plugin called tmux logging (available here). This plugin will allow you to start logging from the current pane to a text file. Each of my inputs and outputs will go into that file. If I forgot to trigger the plugin history from the beginning, I can trigger it afterward to save the whole history (hence my history setting to have more lines in memory).

Using psql

Normally, when I want to write some SQL query, I divide my terminal screen into two panes vertically, one with psql, so that I can query some data (column names, SQL syntax…) and one with vim to write down my query. I just need to use the \i <filename> command to execute my query.

Maybe it will be more clear with an image:

My tmux setup

3 ways to auto-increment with Postgres

September 30, 2021
Administration PostgreSQL

pglog, a flexible and simple log analyzer

September 17, 2021
Administration PostgreSQL

A Tip a day takes the GUI away!

April 4, 2021
Administration PostgreSQL