If you’re using Ubuntu based distro and you’re trying to install pgAdmin4 from the official site (https://www.pgadmin.org/download/pgadmin-4-apt/) do not just blindly copy and paste commands. One of them will add …
Category: PostgreSQL
Nothing provides perl(IPC::Run) needed by…
I wanted to update Postgresql 13 on my Rocky8 test server Simple dnf update postgresql13dnf update postgresql13 leaded to the next error Problem 1: cannot install the best update candidate …
PostgreSQL on CentOS 7 – Howto
In this post I’ll try to show you how to install PostgreSQL 9.6 on CentOS 7.3 which is the current versions of PostgreSQL and CentOS. The default PostgreSQL version on CentOS …
pgModeler – PostgreSQL Database Modeler
pgModeler is an open source tool for modeling PostgreSQL databases which is very similar to MySQL Workbench. The models created by the user can be exported to SQL code and …
PostgreSQL books which you should consider
Since the Oracle bought Sun (including MySQL), I wanted to improve my knowledge about other databases and to check the alternatives (in case “something” happens to MySQL). Luckily, MySQL is …
Why PostgreSQL is not so popular? (howto part 2)
So… After the first part (Link) where we talk about the installation, the next step would be to create root user and to change postgres and root password. [root@XTdata init.d]# …
Why PostgreSQL is not so popular?
Good tutorials about PostgreSQL can be found but not so easy like for MySQL. I decided to install PostgreSQL on my own server just to see what is the main …