Tag: postgresql
-
Using PostgreSQL: Software Architecture Overview
The Direct Answer: What Problem Does PostgreSQL Actually Solve? When our marketplace’s daily analytics queries started timing out at 45 minutes during peak traffic, PostgreSQL’s advanced indexing and partitioning strategies became our lifeline for processing 2.8TB of transaction data across 15 million daily orders. After implementing PostgreSQL across three major e-commerce platform rebuilds, I’ve seen…
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
