It is quite easy to install the latest version of Postgres on Ubuntu. First, declare Postgres repository, create the file /etc/apt/sources.list.d/pgdg.list like this :

Import the repository signing key, and update ubuntu package lists

Then install latest postgresql (actually version 11) and its latest GUI pgadmin (actually version 4) :

Postgresql is now running, you can check that by…

Continue Reading→

You know the following commands : more, grep, tail -f, vi : here is the command that does all that : lnav You can install lnav just by installing the corresponding package :

You get a listing which is dynamically refresh like tail -f does. You can search like vi by using / command, you can also filter with…

Continue Reading→

To monitor running processes, you already know the ‘top’ command, you will get such an output : Now there is the ‘htop’ command which provides much more features and detailed informations : You’ve got colors, text bars graph, commands with arguments : You can scroll up, down AND right and left, and the best : despite it is a text…

Continue Reading→