pg_basebackup fails when data-checksums enables on master node.

[shahidullah79]

pg_basebackup fails when setting up replication.

pg_basebackup -D /var/lib/pgsql/16/standby1 -U replication -p 5434 -Xs -R -P
WARNING: aborting backup due to backend exiting before pg_backup_stop was called
pg_basebackup: error: COPY stream ended before last file was finished
pg_basebackup: removing data directory "/var/lib/pgsql/16/standby1"

Steps to reproduce the issue.

Set PATH variable & Environment variables for PGDATA and archive directories

export PATH=/usr/pgsql-16/bin:${PATH}
export WORKDIR=/var/lib/pgsql/16

MASTER_PGDATA=${WORKDIR}/master
STANDBY1_PGDATA=${WORKDIR}/standby1
STANDBY2_PGDATA=${WORKDIR}/standby2
ARCHIVE_DIR=${WORKDIR}/archive
SQL_FILE_DIR=$PWD
MASTER_PORT=5434
STANDBY1_PORT=5435
STANDBY2_PORT=5436

initdb --data-checksums -D ${MASTER_PGDATA}

Basic configuration of PostgreSQL

cat >> ${MASTER_PGDATA}/postgresql.conf <<EOF
archive_command = 'rsync -a %p ${ARCHIVE_DIR}/%f'
archive_mode = on
wal_level = replica
max_wal_senders = 10
min_wal_size = '80MB'
max_wal_size = '10GB'
hot_standby = on
wal_log_hints = on
listen_addresses = '*'
EOF

cat >> ${MASTER_PGDATA}/pg_hba.conf <<EOF
local replication replication trust
EOF

mkdir -p ${ARCHIVE_DIR}

pg_ctl -D ${MASTER_PGDATA} -l ${WORKDIR}/master.log -o "-p ${MASTER_PORT}" start

Create the replication user and populate encrypted data

psql -p ${MASTER_PORT} -c "CREATE USER replication WITH replication"
psql -p ${MASTER_PORT} -c "ALTER SYSTEM SET shared_preload_libraries = 'pg_tde';"
pg_ctl -D ${MASTER_PGDATA} -l ${WORKDIR}/master.log -o "-p ${MASTER_PORT}" restart

psql -p ${MASTER_PORT} -c "CREATE DATABASE db_tde"
psql -p ${MASTER_PORT} -d db_tde -f ${SQL_FILE_DIR}/tde-sample-schema.sql
psql -p ${MASTER_PORT} -d db_tde -f ${SQL_FILE_DIR}/tde-insert-data.sql

Create the first standby and the start the standby1 server

pg_basebackup -D ${STANDBY1_PGDATA} -U replication -p ${MASTER_PORT} -Xs -R -P

cat >> ${STANDBY1_PGDATA}/postgresql.conf <<EOF
port = ${STANDBY1_PORT}
EOF

pg_ctl -D ${STANDBY1_PGDATA} -l ${WORKDIR}/standby1.log start

Create the second standby and start the server

pg_basebackup -D ${STANDBY2_PGDATA} -U replication -p ${MASTER_PORT} -Xs -R -P

cat >> ${STANDBY2_PGDATA}/postgresql.conf <<EOF
port = ${STANDBY2_PORT}
EOF

pg_ctl -D ${STANDBY2_PGDATA} -l ${WORKDIR}/standby2.log start

[shahidullah79]

Shell Script to configure the environment and reproduce the issue.
replication_setup_pg.log

Sql files to populate database with encrypted data.
tde-sample-schema.log
tde-insert-data.log

Master node's server log.
postgresql-Thu.log