PostgresqlHelp

In this tutorial we will understand how to setup a Pivotal Greenplum 6 database cluster with following set up on Linux 6.

How to Install, Create and Configure Greenplum database 6.12 in Linux – Introduction IP Address Hostname Implementations-1 Implementations-2 192.168.1.51 m_node01 master 192.168.1.52 segnode01 gpseg0(primary) gpseg1(mirror), master standby 192.168.1.53 segnode02 gpseg1(primary) gpseg0(mirror)

I was reading the PostgreSQL official documentation and in every other page I read something like, foo and bar.

Foo, Bar and PostgreSQL

PostgreSQL documentation has 675 instances where the word foo is used.

Understanding the concept of database, PostgreSQL came up with the example.,

CREATE DATABASE foo WITH TEMPLATE template0;

Understanding the concept of creating table, PostgreSQL came up with the example.,

CREATE TABLE foo (fooid int, foosubid int, fooname text);

Even columns.,

From here we understand that PostgreSQL uses the feature called vacuum to clear dead tuples. More information about vacuum and dead tuples is already covered extensively in multiple posts.

“TIMELINES ARE THE DIVERGENT POINTS”

Let’s assume you did a point in time recovery after a wrong transaction, PostgreSQL branches to a new timeline and continue with the operations.

But what happens after you perform a point in time recovery, realized you made a mistake again?

That’s where recovery_target_timeline comes into picture.

In this post we are going to understand everything about recovery_target_timeline and timelines in PostgreSQL in general.

How to install PostgreSQL 13 in UBUNTU From Repository

PostgreSQL can be installed by means of two ways

1. Installing from source
2. Installing binary packages

Each method has its own advantages and disadvantages, however, we will limit this post to learn how to install PostgreSQL using binaries packages.

How to install PostgreSQL 13 in REHL 7 From Repository

PostgreSQL can be installed by means of two ways

1. Installing from source
2. Installing binary packages

Each method has its own advantages and disadvantages, however, we will limit this post to learn how to install PostgreSQL using binaries packages.