SimpleBackupsSimpleBackups
/postgresql

postgresql

News, tips, guides and tools by the creators of SimpleBackups web

Mastering PostgreSQL Data Types: A Comprehensive Guide

Latest Post

Mastering PostgreSQL Data Types: A Comprehensive Guide

Mastering PostgreSQL Data Types: A Comprehensive Guide

Read more

How to find long-running queries in PostgreSQL

How to find long-running queries in PostgreSQL

November 23, 2023

Find slow & long-running postgreSQL queries, kill them and optimize your database.

How to List Indexes in PostgreSQL and Related Commands

How to List Indexes in PostgreSQL and Related Commands

November 23, 2023

Find out how to list indexes in PostgreSQL together with related commands and SQL queries.

How to List Schemas in PostgreSQL and Related Commands

How to List Schemas in PostgreSQL and Related Commands

November 22, 2023

Check PostgreSQL version on Linux and macOS with easy commands and SQL queries. Ensure compatibility and make informed decisions.

Understanding Postgres Roles & Privileges

Understanding Postgres Roles & Privileges

November 21, 2023

Check PostgreSQL version on Linux and macOS with easy commands and SQL queries. Ensure compatibility and make informed decisions.

How to check PostgreSQL version

How to check PostgreSQL version

November 21, 2023

Check PostgreSQL version on Linux and macOS with easy commands and SQL queries. Ensure compatibility and make informed decisions.

MySQL vs PostgreSQL: A Comprehensive Comparison of the Most Popular Databases

MySQL vs PostgreSQL: A Comprehensive Comparison of the Most Popular Databases

November 14, 2023

MySQL and PostgreSQL are popular relational database systems. how do they defer on performance, features, scalability, security, and more.

The Ultimate PostgreSQL Database Backup Guide

The Ultimate PostgreSQL Database Backup Guide

June 9, 2021

Automate Postgres backups and store them remotely. Complete guide, with scripts and examples.

PostgreSQL pg_dump & pg_restore Guide

PostgreSQL pg_dump & pg_restore Guide

December 1, 2020

Extensive guide about pg_dump and pg_restore commands, how to use them to back up and restore postgresql databases (pg_dump + pg_restore exa...

How to restore a PostgreSQL backup

How to restore a PostgreSQL backup

October 23, 2020

There are different types of database aside from the commonly used MySQL database. You might work on a project that uses another type of dat...