Tag: postgresql

  • Using PostgreSQL: Software Architecture Overview

    PostgreSQL Overview No matter what you do, the chance is you need to store the data you serve to consumers, as well as to keep the data you receive from them. There’s hardly a system design that doesn’t involve a storage solution. Despite that almost every storage boils down to a file, the way you…

    PostgreSQL Software Architecture
  • 5 docker commands to install PostgreSQL (Postgis), MongoDB, MySQL, and Redis

    PostgreSQL where (you can change them on your choice): Hint: using  25432 (or any other rarely used) port prevents conflicts You also can install it directly to your machine using this guide PostgreSQL + Postgis Hint:  -d flag runs the container as a daemon: it starts in the background and you can continue working with the same terminal…

  • 7 steps after installing PostgresQL on Ubuntu Server 20.04

    Problem: After installation sudo apt install postgresql-12 you try to connect to your fresh PostgresQL 12 using psql, but it’s responding Solution: in newer versions it might be 5433 by default, so it causes problems find a string with  port = 5433 and change it to  port = 5432 Change 12 to your porstgresql version And…