Re: PostgreSQL Upgrade with Replication managed via repmgr

2022年3月2日(水) 23:49 DAN LU : > > Hello, > > I am hoping someone can help me regarding upgrading PG to the latest release > that has replication setup via repmgr. > > Here is an example of my current setup: > Server A: PostgreSQL 12.1 serving as the "primary" role managed by repmgr 5.1 > (https://re

Power loss test

Hello For many years when I get a new server every time I tested the storage system with diskchecker.pl for power loss. I'm just curious if there is any other/newer tool to test ? Thanks Levi

Postgres Wal Full

Hi , I have a problem from pg_wal. I am using postgresql version 11 and taking backup and writing archive_command in postgresql.conf but did not archive wal and my disk ise full from pg_wal. I research why is my wal is full and dont found anything could you help me please ?

How to log to client (port native code to stored procedure)?

Dear Members! We have to port a native, complex Win32 code to a stored procedure. PGSQL: V9.6-V11. One of the problems is: how to log (to client and to server side)? In the native code we: 1. Open a transaction. 2. Start a complex process. 3. Make local (filesystem based) log in every important

PostgreSQL Upgrade with Replication managed via repmgr

Hello, I am hoping someone can help me regarding upgrading PG to the latest release that has replication setup via repmgr. Here is an example of my current setup: Server A: PostgreSQL 12.1 serving as the "primary" role managed by repmgr 5.1 (https://repmgr.org/) Server B: PostgreSQL 12.1 serving