Richard's Log: PostgreSQL

Public notepad about stuff I am currently playing with...

Enable PostgreSQL connection from remote machine

Let’s continue in previous article and enable PostgreSQL connection from different machine in network. This allows Zabbix web interface to connect from another machine.

Let`s learn what is going on with Raspberry Pis in home network

Since I do have several Raspberry Pis at home, I figured out it would be cool to know how they`d perform while I am not using them. I decided to install Zabbix on one of them. If you don’t know what Zabbix is, it is an open source monitoring solution for networks and applications.

PostgreSQL: show tables, show databases, show columns, describe table

PostgreSQL is one of the best databases, which you can choose from when working on your project. If you are switching from MySQL, you will realise immediatelly that you are missing basic commands that you were used to in MySQL. Lets have a look at few basic commands.


  1. CentOS
  2. Mac OS X
  3. Nginx
  4. Conference
  5. Django
  6. Python
  7. virtualenv
  8. Zabbix
  9. Asuswrtn
  10. SNMP
  11. Raspbian
  12. EXT3
  13. Raspberry Pi
  14. PostgreSQL
  15. PHP
  16. git
  17. Ludolph
  18. Apache
  19. MySQL
  20. backups