Although it is getting warmer and warmer, I have found some time to explore Linux related podcasts and hand-picked thirteen interesting podcasts so everyone will find something that pleases their ears and engages mind.
You may be aware of the whole number of accounts registered in the system, but if you are wondering how to count only local users ignoring system accounts, then I will give you a concise and straight answer.
Today I will shortly describe the way in which you can remotely check PostgreSQL version, and use it inside shell scripts. This ability comes in handy at times, as it can be used to perform different tasks depending on the returned database version.
Most people use their computers without much thought as to what it is they are actually interacting with but they are called operating systems...
There are two ways to non interactively provide password for the
psql command which is a PostgreSQL interactive terminal. Each method allows to easily write shell scripts using terminal-based PostgreSQL utilities as you can provide user credentials from the password file or environment variables.