include packaging/Makefile.pkg

include packaging/Makefile.repo

include packaging/Makefile.test

`pg_probackup` is a utility to manage backup and recovery of PostgreSQL database clusters. It is designed to perform periodic backups of the PostgreSQL instance that enable you to restore the server in case of a failure.

The utility is compatible with:

* PostgreSQL 13, 14, 15, 16, 17

* PostgreSQL 13, 14, 15, 16, 17, 18

As compared to other backup solutions,`pg_probackup` offers the following benefits that can help you implement different backup strategies and deal with large amounts of data:

* Incremental backup: page-level incremental backup allows you to save disk space, speed up backup and restore. With three different incremental modes, you can plan the backup strategy in accordance with your data flow.

To compile`pg_probackup`, you must have a PostgreSQL installation and raw source tree.Execute this in the module's directory:

To compile`pg_probackup`, you must have a PostgreSQL installation and raw source tree.For versions under 18 execute this in the module's directory:

make USE_PGXS=1 PG_CONFIG=<path_to_pg_config> top_srcdir=<path_to_PostgreSQL_source_tree>

cd<path_to_PostgreSQL_source_tree>&& git clone https://github.com/postgrespro/pg_probackup contrib/pg_probackup&&cd contrib/pg_probackup&& make

For version 18 you have to apply PostgreSQL core patch (patches/REL_18_STABLE_pg_probackup.patch) first and recompile and reinstall PostgreSQL

Currently pg_probackup can be build using only MSVC 2013.

From 5809673569d3d95c7bce75ea0aa6f9723e303c7d Mon Sep 17 00:00:00 2001

From: Daria <d.lepikhova@postgrespro.ru>

Date: Mon, 17 Nov 2025 02:57:38 +0100

Subject: [PATCH] REL_18_STABLE_pg_probackup

src/backend/utils/hash/pg_crc.c | 2 ++

1 file changed, 2 insertions(+)

index e67a74ef852..6a474e804b5 100644

@@ -99,6 +99,7 @@ const uint32 pg_crc32_table[256] = {

0xB40BBE37, 0xC30C8EA1, 0x5A05DF1B, 0x2D02EF8D

};

/*

* SQL-callable functions

*/

@@ -128,3 +129,4 @@ crc32c_bytea(PG_FUNCTION_ARGS)

PG_RETURN_INT64(crc);

}

2.39.5 (Apple Git-154)

staticboolpg_is_checksum_enabled(PGconn*conn);

staticboolpg_is_in_recovery(PGconn*conn);

staticboolpg_is_superuser(PGconn*conn);

staticvoidcheck_server_version(PGconn*conn,PGNodeInfo*nodeInfo);

staticvoidconfirm_block_size(PGconn*conn,constchar*name,intblcksz);

staticvoidrewind_and_mark_cfs_datafiles(parray*files,constchar*root,char*relative,size_ti);

staticboolremove_excluded_files_criterion(void*value,void*exclude_args);

check_server_version(PGconn*conn,PGNodeInfo*nodeInfo)

{

PGresult*res=NULL;

intsegno;

pgFile**file_item;

pgFilef;

#ifPG_VERSION_NUM >=180000

RelPathStrrel_path_str=relpathperm(rnode,forknum);

rel_path=rel_path_str.str;

rel_path=relpathperm(rnode,forknum);

segno=blkno /RELSEG_SIZE;

blkno_inseg=blkno %RELSEG_SIZE;

rel_path=relpathperm(rnode,forknum);

if (segno>0)

f.rel_path=psprintf("%s.%u",rel_path,segno);

if (segno>0)

pg_free(f.rel_path);

pg_free(rel_path);

}

page_st->checksum=pg_checksum_page(page,absolute_blkno);

if (checksum_version)

if (checksum_version&& !skip_block_validation)

{

if (page_st->checksum!= ((PageHeader)page)->pd_checksum)

if (instance_config.pgdata!=NULL&&

(backup_subcmd!=ARCHIVE_GET_CMD&&backup_subcmd!=CATCHUP_CMD)&&

!is_absolute_path(instance_config.pgdata))

elog(ERROR,"-D, --pgdata must be an absolute path");

elog(ERROR,"-D, --pgdata must be an absolute path: %s",instance_config.pgdata);

#ifPG_VERSION_NUM >=110000

wal_file_path,wal_file_name,batch_size, !no_validate_wal);

break;

caseADD_INSTANCE_CMD:

{

PGNodeInfonodeInfo;

pgNodeInit(&nodeInfo);

instanceState->conn=pgut_connect(dbhost,dbport,dbname,dbuser);

check_server_version(instanceState->conn,&nodeInfo);

returndo_add_instance(instanceState,&instance_config);

}

returndo_add_instance(instanceState,&instance_config);

caseDELETE_INSTANCE_CMD:

returndo_delete_instance(instanceState);

caseINIT_CMD:

externlong unsignedintbase36dec(constchar*text);

externuint32parse_server_version(constchar*server_version_str);

externuint32parse_program_version(constchar*program_version);

voidcheck_server_version(PGconn*conn,PGNodeInfo*nodeInfo);

externboolparse_page(Pagepage,XLogRecPtr*lsn);

externint32do_compress(void*dst,size_tdst_size,voidconst*src,size_tsrc_size,

CompressAlgalg,intlevel,constchar**errormsg);

boolis_temporary,boolis_physical,

boolslot_exists_ok)

{

#ifPG_VERSION_NUM >=150000

#ifPG_VERSION_NUM >=180000

returnCreateReplicationSlot(conn,slot_name,plugin,is_temporary,is_physical,

/* reserve_wal = */ true,slot_exists_ok,/* two_phase = */ false,/* failover = */ false);

#elifPG_VERSION_NUM >=150000

returnCreateReplicationSlot(conn,slot_name,plugin,is_temporary,is_physical,

/* reserve_wal = */ true,slot_exists_ok,/* two_phase = */ false);

#elifPG_VERSION_NUM >=110000

if (size!=ControlFileSize)

{

if (size==16384)

elog(ERROR,"Unexpected control file size %d, expected %d. Probably you trying to connect Postgres Pro using %s built with PostgreSQL. ",

(int)size,ControlFileSize,PROGRAM_NAME);

elog(ERROR,"Unexpected control file size %d, expected %d",

(int)size,ControlFileSize);

}

memcpy(ControlFile,src,sizeof(ControlFileData));

init_cancel_handler(void)

{

oldhandler=pqsignal(SIGINT,handle_interrupt);

{

structsigactionact,oldact;

act.sa_handler=handle_interrupt;

sigemptyset(&act.sa_mask);

act.sa_flags=SA_RESTART;

if (sigaction(SIGINT,&act,&oldact)<0)

elog(ERROR,"sigaction(SIGINT) failed: %m");

oldhandler=oldact.sa_handler;

}

pqsignal(SIGQUIT,handle_interrupt);

pqsignal(SIGTERM,handle_interrupt);

pqsignal(SIGPIPE,handle_interrupt);