Setting Up PostgreSQL 14 Database Cluster Using Google Cloud Engine
Technologies   PostgreSQL  

Setting Up PostgreSQL 14 Database Cluster Using Google Cloud Engine

In our previous blog post, we have introduced steps and techniques how to install PostgreSQL 14 from source code on Google Cloud Engine. By doing this, we have only one standalone instance run...

25 Nov 2021 SETHA THAY 175
Installing PgBouncer as Connection Pool for PostgreSQL 14
Technologies   Tools   PostgreSQL  

Installing PgBouncer as Connection Pool for PostgreSQL 14

The short definition of PgBouncer is a connection pooler for PostgreSQL. Based on the official website, there are a few wonderful features for database administrator and system architecture fo...

13 Nov 2021 SETHA THAY 255
Using Ansible to Remote Manage Your Database Instance
Technologies   Tools   Automation   PostgreSQL  

Using Ansible to Remote Manage Your Database Instance

In the previous post, we have introduced an article about how to install PostgreSQL 14 on Ubuntu in Google Cloud Engine which acts as a single database instance. In fact, it's very easy to mana...

06 Nov 2021 SETHA THAY 255
How to Install PostgreSQL 14 on Ubuntu 20.04 from Source
Technologies   PostgreSQL  

How to Install PostgreSQL 14 on Ubuntu 20.04 from Source

PostgreSQL 14 has been officially released on 30 September 2021 with hundreds of improvements, fixes, and changes that have been mentioned in the release note on their official website. In this rel...

23 Oct 2021 SETHA THAY 276
Implementation of Full Text Search in PostgreSQL 13
New Trends   PostgreSQL  

Implementation of Full Text Search in PostgreSQL 13

INTRODUCTION Full-Text Search (FTS) is a method used by search engines to find results in a database. It can be utilized to bootstrap search results on websites like e-commerces, newsp...

20 Aug 2021 SETHA THAY 522
Installation and Configuration of Fake2DB Tool for Auto Generate Fake but Valid Data
General Knowledge   Tools   PostgreSQL  

Installation and Configuration of Fake2DB Tool for Auto Generate Fake but Valid Data

Data is way more expensive these days since we are in the modern digital era. Having data on your hand, you can perform experiments with various ways to explore the performance of servers, well pre...

12 Aug 2021 SETHA THAY 343
Database Design: Audit Log, Tracking Changes to Column Data Value in PostgreSQL (PART 2)
Technologies   PostgreSQL  

Database Design: Audit Log, Tracking Changes to Column Data Value in PostgreSQL (PART 2)

In part 1, we have introduced about audit log that you can tracking changes to the column data value and configuration steps of how you can achieve it. In this blog post, you will learn more about ...

02 Aug 2021 SETHA THAY 345
Database Design: Audit Log, Tracking Changes to Column Data Value in PostgreSQL (PART 1)
Technologies   PostgreSQL  

Database Design: Audit Log, Tracking Changes to Column Data Value in PostgreSQL (PART 1)

What is an Audit trail (also commonly called an Audit log)? It is basically a record-keeping of changes in the database. For instance, if a user updates a record, an audit log should record who mad...

31 Jul 2021 SETHA THAY 399

DigitalOcean Referral Badge

Scroll to Top