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