Menu

▼

Postgres Pages

▼
Thursday, April 20, 2023

Postgres: ERROR: this node should be a standby

›
On a standby node, while performing a clone. I am receiving an error. So, I am on Standby and nothing's incorrectly done on the repmgr.c...

Postgresql: Setup and configuring Postgresql Replication Manager (Repmgr)

›
Continue from the first part of Create Hot Standby blog.  https://postgresdesk.blogspot.com/2023/04/postgresql-creating-hot-standby.html Dow...
Monday, April 10, 2023

Postgresql: Creating Hot Standby

›
  Create hot standby As a fictitious example, I will assign them 2 IPs, 192.168.1.11 as centos-1 and 192.168.1.12 as centos-1. This can be a...
Tuesday, July 7, 2020

postgresql: corruption: invalid primary checkpoint record

›
Corruptions are very common with PostgreSQL. It can easily be triggered on outages, shutting down the VM before shutting down the database g...
Friday, January 17, 2020

postgresql: Looking at the detail of wal file.

›
Using pg_xlogdump to look at the contents of a wal file. root@photon-machine [ /storage/archive/vpostgres ]# /opt/vmware/vpostgres/9.6...

postgresql: Purging WAL files with pg_archivecleanup in VC Appliance.

›
Purging wall files with pg_archivecleanup in VC Appliance. Essentially, this is similar to "rm" except, it detects dependency o...
Friday, November 16, 2018

postgres corruption: ERROR: invalid page in block

›
Certain select queries will hit the following error. It has something to do with physical disk issue/corruption/outage where the table res...
2 comments: