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…
Written by
-
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…
Written by
-
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…
Written by