Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
TODO Archives - PostgreSQL Candies

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...