PostgreSQL

How To Set Up Continuous Archiving and Perform Point-In-Time-Recovery with PostgreSQL 12 on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Set Up Continuous Archiving and Perform Point-In-Time-Recovery with PostgreSQL 12 on Ubuntu 20.04

One method PostgreSQL uses to maintain ACID properties is Write-Ahead Logging (WAL). For example, a secondary database cluster can use the archived WAL file for replication purposes, but you can also use the files to perform point-in-time-recovery (PITR). In this tutorial, you will set up continuous archiving with a PostgreSQL 12 cluster on Ubuntu 20.04 and perform PITR on the cluster.

Read more
How To Build a REST API with Prisma and PostgreSQL — step-by-step Docker tutorial on Progressive Robot

How To Build a REST API with Prisma and PostgreSQL

Prisma is an open source database toolkit. In this tutorial, you will build a REST API for a small blogging application in TypeScript using Prisma and a PostgreSQL database. At the end of the tutorial, you will have a web server running locally on your machine that can respond to various HTTP requests and read and write data in the database.

Read more
How To Secure PostgreSQL on an Ubuntu VPS — step-by-step Linux tutorial on Progressive Robot

How To Secure PostgreSQL on an Ubuntu VPS

Database management systems are extremely useful for handling information from websites and applications. PostgreSQL is a popular database management system that is incredibly powerful. When using PostgreSQL, it is essential that you take proper precautions to secure your databases. This article is an introduction to security practices when using PostgreSQL

Read more
CHAT