In a production environment, no matter how large or small your PostgreSQL database may be, regular back is an essential aspect of database management. In this article, you will learn how to backup and restore a PostgreSQL database. We assume that you already have a working installation of the PostgreSQL database system. If not, read
PostgreSQL - DesignLinux
How to Install PostgreSQL and pgAdmin in RHEL 8
Pgadmin4 is an opensource web-based management tool for managing PostgreSQL databases. It’s a Python-based web-application developed using the flask framework at the backend and HTML5, CSS3, and Bootstrap on the frontend. Pgadmin4 is a rewrite of Pgadmin 3 which is written in C++ and ships with the following notable features: Pgadmin4 Features Sleek and revamped
What is PostgreSQL? How Does MySQL Work?
PostgreSQL is the world’s most advanced enterprise-class open source database management system that is developed by the PostgreSQL Global Development Group. It is a powerful and highly-extensible object-relational SQL (Structured Query Language) database system popular for its reliability, feature robustness, and high performance. It is known to be highly scalable both in the amount of
How to Install PostgreSQL and pgAdmin in CentOS 8
PostgreSQL is a powerful, widely-used, open-source, multi-platform and advanced object-relational database system known for its proven architecture, reliability, data integrity, robust feature set, and extensibility. pgAdmin is an advanced, open-source, full-featured, and web-based administration and management tool for the PostgreSQL database server. In this article, you will learn how to install the PostgreSQL 12 database
How To Configure PostgreSQL 12 Streaming Replication in CentOS 8
PostgreSQL database supports several replication solutions to build high-availability, scalable, fault-tolerant applications, one of which is Write-Ahead Log (WAL) Shipping. This solution allows for a standby server to be implemented using file-based log shipping or streaming replication, or where possible, a combination of both approaches. With streaming replication, a standby (replication slave) database server is