Usage of arrays in aggregations

If you get to know them you will simply love them – I mean ARRAYs in PostgreSQL. And also in some situations you simply cannot live without them – at least in PostgreSQL. Here are some examples how to use them in real life. (still in TODO) Aggregations...

Useful linux commands for PostgreSQL administrator

Also only some small hints (and also still in TODO): CommandExplanationDistro yum list postgresqlShow available packages (all)RedHat, CentOS yum search plproxysearch for available packagesRedHat, CentOS rpm -qa|grep postgresqlShows which postgresql packages are...

Linux commands for simple analysis of PostgreSQL logs

Just some simple hints:  (still in TODO…) CommandExplanation grep -i 'ERROR:' *.log|lessYou must be in directory with server logs. Command shows you lines with text "error:" (ignores big/small letters). Command "less" is used for pagination - you can list in...

How to check PostgreSQL processes from OS

On Linux: ps-ef |greppostgres | grep-v grep shows all postgres processes works on all Linux distros second grep pipe just filters out line with “grep postgres” command   you will see something like this – of course directories can be...