PostgreSQL Source Code git master
Loading...
Searching...
No Matches
pg_basebackup.c
Go to the documentation of this file.
1/*-------------------------------------------------------------------------
2 *
3 * pg_basebackup.c - receive a base backup using streaming replication protocol
4 *
5 * Author: Magnus Hagander <magnus@hagander.net>
6 *
7 * Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group
8 *
9 * IDENTIFICATION
10 * src/bin/pg_basebackup/pg_basebackup.c
11 *-------------------------------------------------------------------------
12 */
13
14#include "postgres_fe.h"
15
16#include <unistd.h>
17#include <dirent.h>
18#include <limits.h>
19#include <sys/select.h>
20#include <sys/stat.h>
21#include <sys/wait.h>
22#include <signal.h>
23#include <time.h>
24#ifdef HAVE_LIBZ
25#include <zlib.h>
26#endif
27
29#include "astreamer_inject.h"
30#include "backup/basebackup.h"
31#include "common/compression.h"
32#include "common/file_perm.h"
33#include "common/file_utils.h"
34#include "common/logging.h"
37#include "getopt_long.h"
38#include "libpq/protocol.h"
39#include "receivelog.h"
40#include "streamutil.h"
41
42#define ERRCODE_DATA_CORRUPTED "XX001"
43
50
56
67
73
79
80typedef void (*WriteDataCallback) (size_t nbytes, char *buf,
81 void *callback_data);
82
83/*
84 * pg_xlog has been renamed to pg_wal in version 10. This version number
85 * should be compared with PQserverVersion().
86 */
87#define MINIMUM_VERSION_FOR_PG_WAL 100000
88
89/*
90 * Temporary replication slots are supported from version 10.
91 */
92#define MINIMUM_VERSION_FOR_TEMP_SLOTS 100000
93
94/*
95 * Backup manifests are supported from version 13.
96 */
97#define MINIMUM_VERSION_FOR_MANIFESTS 130000
98
99/*
100 * Before v15, tar files received from the server will be improperly
101 * terminated.
102 */
103#define MINIMUM_VERSION_FOR_TERMINATED_TARFILE 150000
104
105/*
106 * pg_wal/summaries exists beginning with version 17.
107 */
108#define MINIMUM_VERSION_FOR_WAL_SUMMARIES 170000
109
110/*
111 * Different ways to include WAL
112 */
119
120/*
121 * Different places to perform compression
122 */
129
130/* Global options */
131static char *basedir = NULL;
133static char *xlog_dir = NULL;
134static char format = '\0'; /* p(lain)/t(ar) */
135static char *label = "pg_basebackup base backup";
136static bool noclean = false;
137static bool checksum_failure = false;
138static bool showprogress = false;
139static bool estimatesize = true;
140static int verbose = 0;
142static bool fastcheckpoint = false;
143static bool writerecoveryconf = false;
144static bool do_sync = true;
145static int standby_message_timeout = 10 * 1000; /* 10 sec = default */
147static int32 maxrate = 0; /* no limit by default */
148static char *replication_slot = NULL;
149static bool temp_replication_slot = true;
150static char *backup_target = NULL;
151static bool create_slot = false;
152static bool no_slot = false;
153static bool verify_checksums = true;
154static bool manifest = true;
155static bool manifest_force_encode = false;
158
159static bool success = false;
160static bool made_new_pgdata = false;
161static bool found_existing_pgdata = false;
162static bool made_new_xlogdir = false;
163static bool found_existing_xlogdir = false;
164static bool made_tablespace_dirs = false;
165static bool found_tablespace_dirs = false;
166
167/* Progress indicators */
171static char *progress_filename = NULL;
172
173/* Pipe to communicate with background wal receiver process */
174#ifndef WIN32
175static int bgpipe[2] = {-1, -1};
176#endif
177
178/* Handle to child process */
179static pid_t bgchild = -1;
180static bool in_log_streamer = false;
181
182/* Flag to indicate if child process exited unexpectedly */
183static volatile sig_atomic_t bgchild_exited = false;
184
185/* End position for xlog streaming, empty string if unknown yet */
187
188#ifndef WIN32
189static int has_xlogendptr = 0;
190#else
191static volatile LONG has_xlogendptr = 0;
192#endif
193
194/* Contents of configuration file to be generated */
196
197/* Function headers */
198static void usage(void);
199static void verify_dir_is_empty_or_create(char *dirname, bool *created, bool *found);
200static void progress_update_filename(const char *filename);
201static void progress_report(int tablespacenum, bool force, bool finished);
202
203static astreamer *CreateBackupStreamer(char *archive_name, char *spclocation,
205 bool is_recovery_guc_supported,
207 pg_compress_specification *compress);
208static void ReceiveArchiveStreamChunk(size_t r, char *copybuf,
209 void *callback_data);
210static char GetCopyDataByte(size_t r, char *copybuf, size_t *cursor);
211static char *GetCopyDataString(size_t r, char *copybuf, size_t *cursor);
212static uint64 GetCopyDataUInt64(size_t r, char *copybuf, size_t *cursor);
213static void GetCopyDataEnd(size_t r, char *copybuf, size_t cursor);
214static void ReportCopyDataParseError(size_t r, char *copybuf);
215static void ReceiveTarFile(PGconn *conn, char *archive_name, char *spclocation,
216 bool tablespacenum, pg_compress_specification *compress);
217static void ReceiveTarCopyChunk(size_t r, char *copybuf, void *callback_data);
218static void ReceiveBackupManifest(PGconn *conn);
219static void ReceiveBackupManifestChunk(size_t r, char *copybuf,
220 void *callback_data);
222static void ReceiveBackupManifestInMemoryChunk(size_t r, char *copybuf,
223 void *callback_data);
228
229static bool reached_end_position(XLogRecPtr segendpos, uint32 timeline,
230 bool segment_finished);
231
232static const char *get_tablespace_mapping(const char *dir);
233static void tablespace_list_append(const char *arg);
234
235
236static void
238{
240 return;
241
242 if (!noclean && !checksum_failure)
243 {
244 if (made_new_pgdata)
245 {
246 pg_log_info("removing data directory \"%s\"", basedir);
247 if (!rmtree(basedir, true))
248 pg_log_error("failed to remove data directory");
249 }
250 else if (found_existing_pgdata)
251 {
252 pg_log_info("removing contents of data directory \"%s\"", basedir);
253 if (!rmtree(basedir, false))
254 pg_log_error("failed to remove contents of data directory");
255 }
256
258 {
259 pg_log_info("removing WAL directory \"%s\"", xlog_dir);
260 if (!rmtree(xlog_dir, true))
261 pg_log_error("failed to remove WAL directory");
262 }
263 else if (found_existing_xlogdir)
264 {
265 pg_log_info("removing contents of WAL directory \"%s\"", xlog_dir);
266 if (!rmtree(xlog_dir, false))
267 pg_log_error("failed to remove contents of WAL directory");
268 }
269 }
270 else
271 {
273 pg_log_info("data directory \"%s\" not removed at user's request", basedir);
274
276 pg_log_info("WAL directory \"%s\" not removed at user's request", xlog_dir);
277 }
278
280 pg_log_info("changes to tablespace directories will not be undone");
281}
282
283static void
285{
286 if (conn != NULL)
287 PQfinish(conn);
288}
289
290#ifndef WIN32
291/*
292 * If the bgchild exits prematurely and raises a SIGCHLD signal, we can abort
293 * processing rather than wait until the backup has finished and error out at
294 * that time. On Windows, we use a background thread which can communicate
295 * without the need for a signal handler.
296 */
297static void
302
303/*
304 * On windows, our background thread dies along with the process. But on
305 * Unix, if we have started a subprocess, we want to kill it off so it
306 * doesn't remain running trying to stream data.
307 */
308static void
310{
311 if (bgchild > 0 && !bgchild_exited)
313}
314#endif
315
316/*
317 * Split argument into old_dir and new_dir and append to tablespace mapping
318 * list.
319 */
320static void
322{
324 char *dst;
325 char *dst_ptr;
326 const char *arg_ptr;
327
328 dst_ptr = dst = cell->old_dir;
329 for (arg_ptr = arg; *arg_ptr; arg_ptr++)
330 {
331 if (dst_ptr - dst >= MAXPGPATH)
332 pg_fatal("directory name too long");
333
334 if (*arg_ptr == '\\' && *(arg_ptr + 1) == '=')
335 ; /* skip backslash escaping = */
336 else if (*arg_ptr == '=' && (arg_ptr == arg || *(arg_ptr - 1) != '\\'))
337 {
338 if (*cell->new_dir)
339 pg_fatal("multiple \"=\" signs in tablespace mapping");
340 else
341 dst = dst_ptr = cell->new_dir;
342 }
343 else
344 *dst_ptr++ = *arg_ptr;
345 }
346
347 if (!*cell->old_dir || !*cell->new_dir)
348 pg_fatal("invalid tablespace mapping format \"%s\", must be \"OLDDIR=NEWDIR\"", arg);
349
350 /*
351 * All tablespaces are created with absolute directories, so specifying a
352 * non-absolute path here would just never match, possibly confusing
353 * users. Since we don't know whether the remote side is Windows or not,
354 * and it might be different than the local side, permit any path that
355 * could be absolute under either set of rules.
356 *
357 * (There is little practical risk of confusion here, because someone
358 * running entirely on Linux isn't likely to have a relative path that
359 * begins with a backslash or something that looks like a drive
360 * specification. If they do, and they also incorrectly believe that a
361 * relative path is acceptable here, we'll silently fail to warn them of
362 * their mistake, and the -T option will just not get applied, same as if
363 * they'd specified -T for a nonexistent tablespace.)
364 */
367 pg_fatal("old directory is not an absolute path in tablespace mapping: %s",
368 cell->old_dir);
369
370 if (!is_absolute_path(cell->new_dir))
371 pg_fatal("new directory is not an absolute path in tablespace mapping: %s",
372 cell->new_dir);
373
374 /*
375 * Comparisons done with these values should involve similarly
376 * canonicalized path values. This is particularly sensitive on Windows
377 * where path values may not necessarily use Unix slashes.
378 */
381
383 tablespace_dirs.tail->next = cell;
384 else
385 tablespace_dirs.head = cell;
386 tablespace_dirs.tail = cell;
387}
388
389
390static void
391usage(void)
392{
393 printf(_("%s takes a base backup of a running PostgreSQL server.\n\n"),
394 progname);
395 printf(_("Usage:\n"));
396 printf(_(" %s [OPTION]...\n"), progname);
397 printf(_("\nOptions controlling the output:\n"));
398 printf(_(" -D, --pgdata=DIRECTORY receive base backup into directory\n"));
399 printf(_(" -F, --format=p|t output format (plain (default), tar)\n"));
400 printf(_(" -i, --incremental=OLDMANIFEST\n"
401 " take incremental backup\n"));
402 printf(_(" -r, --max-rate=RATE maximum transfer rate to transfer data directory\n"
403 " (in kB/s, or use suffix \"k\" or \"M\")\n"));
404 printf(_(" -R, --write-recovery-conf\n"
405 " write configuration for replication\n"));
406 printf(_(" -t, --target=TARGET[:DETAIL]\n"
407 " backup target (if other than client)\n"));
408 printf(_(" -T, --tablespace-mapping=OLDDIR=NEWDIR\n"
409 " relocate tablespace in OLDDIR to NEWDIR\n"));
410 printf(_(" --waldir=WALDIR location for the write-ahead log directory\n"));
411 printf(_(" -X, --wal-method=none|fetch|stream\n"
412 " include required WAL files with specified method\n"));
413 printf(_(" -z, --gzip compress tar output\n"));
414 printf(_(" -Z, --compress=[{client|server}-]METHOD[:DETAIL]\n"
415 " compress on client or server as specified\n"));
416 printf(_(" -Z, --compress=none do not compress tar output\n"));
417 printf(_("\nGeneral options:\n"));
418 printf(_(" -c, --checkpoint=fast|spread\n"
419 " set fast or spread (default) checkpointing\n"));
420 printf(_(" -C, --create-slot create replication slot\n"));
421 printf(_(" -l, --label=LABEL set backup label\n"));
422 printf(_(" -n, --no-clean do not clean up after errors\n"));
423 printf(_(" -N, --no-sync do not wait for changes to be written safely to disk\n"));
424 printf(_(" -P, --progress show progress information\n"));
425 printf(_(" -S, --slot=SLOTNAME replication slot to use\n"));
426 printf(_(" -v, --verbose output verbose messages\n"));
427 printf(_(" -V, --version output version information, then exit\n"));
428 printf(_(" --manifest-checksums=SHA{224,256,384,512}|CRC32C|NONE\n"
429 " use algorithm for manifest checksums\n"));
430 printf(_(" --manifest-force-encode\n"
431 " hex encode all file names in manifest\n"));
432 printf(_(" --no-estimate-size do not estimate backup size in server side\n"));
433 printf(_(" --no-manifest suppress generation of backup manifest\n"));
434 printf(_(" --no-slot prevent creation of temporary replication slot\n"));
435 printf(_(" --no-verify-checksums\n"
436 " do not verify checksums\n"));
437 printf(_(" --sync-method=METHOD\n"
438 " set method for syncing files to disk\n"));
439 printf(_(" -?, --help show this help, then exit\n"));
440 printf(_("\nConnection options:\n"));
441 printf(_(" -d, --dbname=CONNSTR connection string\n"));
442 printf(_(" -h, --host=HOSTNAME database server host or socket directory\n"));
443 printf(_(" -p, --port=PORT database server port number\n"));
444 printf(_(" -s, --status-interval=INTERVAL\n"
445 " time between status packets sent to server (in seconds)\n"));
446 printf(_(" -U, --username=NAME connect as specified database user\n"));
447 printf(_(" -w, --no-password never prompt for password\n"));
448 printf(_(" -W, --password force password prompt (should happen automatically)\n"));
449 printf(_("\nReport bugs to <%s>.\n"), PACKAGE_BUGREPORT);
450 printf(_("%s home page: <%s>\n"), PACKAGE_NAME, PACKAGE_URL);
451}
452
453
454/*
455 * Called in the background process every time data is received.
456 * On Unix, we check to see if there is any data on our pipe
457 * (which would mean we have a stop position), and if it is, check if
458 * it is time to stop.
459 * On Windows, we are in a single process, so we can just check if it's
460 * time to stop.
461 */
462static bool
464 bool segment_finished)
465{
466 if (!has_xlogendptr)
467 {
468#ifndef WIN32
469 fd_set fds;
470 struct timeval tv = {0};
471 int r;
472
473 /*
474 * Don't have the end pointer yet - check our pipe to see if it has
475 * been sent yet.
476 */
477 FD_ZERO(&fds);
478 FD_SET(bgpipe[0], &fds);
479
480 r = select(bgpipe[0] + 1, &fds, NULL, NULL, &tv);
481 if (r == 1)
482 {
484 char xlogend[64] = {0};
485 uint32 hi,
486 lo;
487
488 nread = read(bgpipe[0], xlogend, sizeof(xlogend) - 1);
489 if (nread < 0)
490 pg_fatal("could not read from ready pipe: %m");
491
492 if (sscanf(xlogend, "%X/%08X", &hi, &lo) != 2)
493 pg_fatal("could not parse write-ahead log location \"%s\"",
494 xlogend);
495 xlogendptr = ((uint64) hi) << 32 | lo;
496 has_xlogendptr = 1;
497
498 /*
499 * Fall through to check if we've reached the point further
500 * already.
501 */
502 }
503 else
504 {
505 /*
506 * No data received on the pipe means we don't know the end
507 * position yet - so just say it's not time to stop yet.
508 */
509 return false;
510 }
511#else
512
513 /*
514 * On win32, has_xlogendptr is set by the main thread, so if it's not
515 * set here, we just go back and wait until it shows up.
516 */
517 return false;
518#endif
519 }
520
521 /*
522 * At this point we have an end pointer, so compare it to the current
523 * position to figure out if it's time to stop.
524 */
525 if (segendpos >= xlogendptr)
526 return true;
527
528 /*
529 * Have end pointer, but haven't reached it yet - so tell the caller to
530 * keep streaming.
531 */
532 return false;
533}
534
535typedef struct
536{
539 char xlog[MAXPGPATH]; /* directory or tarfile depending on mode */
545
546static int
548{
549 StreamCtl stream = {0};
550
551 in_log_streamer = true;
552
553 stream.startpos = param->startptr;
554 stream.timeline = param->timeline;
555 stream.sysidentifier = param->sysidentifier;
557#ifndef WIN32
558 stream.stop_socket = bgpipe[0];
559#else
561#endif
563 stream.synchronous = false;
564 /* fsync happens at the end of pg_basebackup for all data */
565 stream.do_sync = false;
566 stream.mark_done = true;
567 stream.partial_suffix = NULL;
569 if (format == 'p')
572 stream.do_sync);
573 else
574 stream.walmethod = CreateWalTarMethod(param->xlog,
576 param->wal_compress_level,
577 stream.do_sync);
578
579 if (!ReceiveXlogStream(param->bgconn, &stream))
580 {
581 /*
582 * Any errors will already have been reported in the function process,
583 * but we need to tell the parent that we didn't shutdown in a nice
584 * way.
585 */
586#ifdef WIN32
587 /*
588 * In order to signal the main thread of an ungraceful exit we set the
589 * same flag that we use on Unix to signal SIGCHLD.
590 */
591 bgchild_exited = true;
592#endif
593 return 1;
594 }
595
596 if (!stream.walmethod->ops->finish(stream.walmethod))
597 {
598 pg_log_error("could not finish writing WAL files: %m");
599#ifdef WIN32
600 bgchild_exited = true;
601#endif
602 return 1;
603 }
604
605 PQfinish(param->bgconn);
606
607 stream.walmethod->ops->free(stream.walmethod);
608
609 return 0;
610}
611
612/*
613 * Initiate background process for receiving xlog during the backup.
614 * The background stream will use its own database connection so we can
615 * stream the logfile in parallel with the backups.
616 */
617static void
618StartLogStreamer(char *startpos, uint32 timeline, char *sysidentifier,
619 pg_compress_algorithm wal_compress_algorithm,
620 int wal_compress_level)
621{
622 logstreamer_param *param;
623 uint32 hi,
624 lo;
625 char statusdir[MAXPGPATH];
626
628 param->timeline = timeline;
629 param->sysidentifier = sysidentifier;
630 param->wal_compress_algorithm = wal_compress_algorithm;
631 param->wal_compress_level = wal_compress_level;
632
633 /* Convert the starting position */
634 if (sscanf(startpos, "%X/%08X", &hi, &lo) != 2)
635 pg_fatal("could not parse write-ahead log location \"%s\"",
636 startpos);
637 param->startptr = ((uint64) hi) << 32 | lo;
638 /* Round off to even segment position */
639 param->startptr -= XLogSegmentOffset(param->startptr, WalSegSz);
640
641#ifndef WIN32
642 /* Create our background pipe */
643 if (pipe(bgpipe) < 0)
644 pg_fatal("could not create pipe for background process: %m");
645#endif
646
647 /* Get a second connection */
648 param->bgconn = GetConnection();
649 if (!param->bgconn)
650 /* Error message already written in GetConnection() */
651 exit(1);
652
653 /* In post-10 cluster, pg_xlog has been renamed to pg_wal */
654 snprintf(param->xlog, sizeof(param->xlog), "%s/%s",
655 basedir,
657 "pg_xlog" : "pg_wal");
658
659 /* Temporary replication slots are only supported in 10 and newer */
661 temp_replication_slot = false;
662
663 /*
664 * Create replication slot if requested
665 */
667 replication_slot = psprintf("pg_basebackup_%u",
668 (unsigned int) PQbackendPID(param->bgconn));
670 {
672 temp_replication_slot, true, true, false,
673 false, false))
674 exit(1);
675
676 if (verbose)
677 {
679 pg_log_info("created temporary replication slot \"%s\"",
681 else
682 pg_log_info("created replication slot \"%s\"",
684 }
685 }
686
687 if (format == 'p')
688 {
689 /*
690 * Create pg_wal/archive_status or pg_xlog/archive_status (and thus
691 * pg_wal or pg_xlog) depending on the target server so we can write
692 * to basedir/pg_wal or basedir/pg_xlog as the directory entry in the
693 * tar file may arrive later.
694 */
695 snprintf(statusdir, sizeof(statusdir), "%s/%s/archive_status",
696 basedir,
698 "pg_xlog" : "pg_wal");
699
701 pg_fatal("could not create directory \"%s\": %m", statusdir);
702
703 /*
704 * For newer server versions, likewise create pg_wal/summaries
705 */
707 {
708 char summarydir[MAXPGPATH];
709
710 snprintf(summarydir, sizeof(summarydir), "%s/%s/summaries",
711 basedir, "pg_wal");
712
714 errno != EEXIST)
715 pg_fatal("could not create directory \"%s\": %m", summarydir);
716 }
717 }
718
719 /*
720 * Start a child process and tell it to start streaming. On Unix, this is
721 * a fork(). On Windows, we create a thread.
722 */
723#ifndef WIN32
724 bgchild = fork();
725 if (bgchild == 0)
726 {
727 /* in child process */
728 exit(LogStreamerMain(param));
729 }
730 else if (bgchild < 0)
731 pg_fatal("could not create background process: %m");
732
733 /*
734 * Else we are in the parent process and all is well.
735 */
737#else /* WIN32 */
738 bgchild = _beginthreadex(NULL, 0, (void *) LogStreamerMain, param, 0, NULL);
739 if (bgchild == 0)
740 pg_fatal("could not create background thread: %m");
741#endif
742}
743
744/*
745 * Verify that the given directory exists and is empty. If it does not
746 * exist, it is created. If it exists but is not empty, an error will
747 * be given and the process ended.
748 */
749static void
750verify_dir_is_empty_or_create(char *dirname, bool *created, bool *found)
751{
752 switch (pg_check_dir(dirname))
753 {
754 case 0:
755
756 /*
757 * Does not exist, so create
758 */
759 if (pg_mkdir_p(dirname, pg_dir_create_mode) == -1)
760 pg_fatal("could not create directory \"%s\": %m", dirname);
761 if (created)
762 *created = true;
763 return;
764 case 1:
765
766 /*
767 * Exists, empty
768 */
769 if (found)
770 *found = true;
771 return;
772 case 2:
773 case 3:
774 case 4:
775
776 /*
777 * Exists, not empty
778 */
779 pg_fatal("directory \"%s\" exists but is not empty", dirname);
780 case -1:
781
782 /*
783 * Access problem
784 */
785 pg_fatal("could not access directory \"%s\": %m", dirname);
786 }
787}
788
789/*
790 * Callback to update our notion of the current filename.
791 *
792 * No other code should modify progress_filename!
793 */
794static void
796{
797 /* We needn't maintain this variable if not doing verbose reports. */
798 if (showprogress && verbose)
799 {
801 if (filename)
803 else
805 }
806}
807
808/*
809 * Print a progress report based on the global variables. If verbose output
810 * is enabled, also print the current file name.
811 *
812 * Progress report is written at maximum once per second, unless the force
813 * parameter is set to true.
814 *
815 * If finished is set to true, this is the last progress report. The cursor
816 * is moved to the next line.
817 */
818static void
819progress_report(int tablespacenum, bool force, bool finished)
820{
821 int percent;
822 char totaldone_str[32];
823 char totalsize_str[32];
825
826 if (!showprogress)
827 return;
828
829 now = time(NULL);
830 if (now == last_progress_report && !force && !finished)
831 return; /* Max once per second */
832
834 percent = totalsize_kb ? (int) ((totaldone / 1024) * 100 / totalsize_kb) : 0;
835
836 /*
837 * Avoid overflowing past 100% or the full size. This may make the total
838 * size number change as we approach the end of the backup (the estimate
839 * will always be wrong if WAL is included), but that's better than having
840 * the done column be bigger than the total.
841 */
842 if (percent > 100)
843 percent = 100;
844 if (totaldone / 1024 > totalsize_kb)
845 totalsize_kb = totaldone / 1024;
846
848 totaldone / 1024);
850
851#define VERBOSE_FILENAME_LENGTH 35
852 if (verbose)
853 {
855
856 /*
857 * No filename given, so clear the status line (used for last
858 * call)
859 */
861 ngettext("%*s/%s kB (100%%), %d/%d tablespace %*s",
862 "%*s/%s kB (100%%), %d/%d tablespaces %*s",
864 (int) strlen(totalsize_str),
866 tablespacenum, tablespacecount,
868 else
869 {
871
873 ngettext("%*s/%s kB (%d%%), %d/%d tablespace (%s%-*.*s)",
874 "%*s/%s kB (%d%%), %d/%d tablespaces (%s%-*.*s)",
876 (int) strlen(totalsize_str),
878 tablespacenum, tablespacecount,
879 /* Prefix with "..." if we do leading truncation */
880 truncate ? "..." : "",
883 /* Truncate filename at beginning if it's too long */
885 }
886 }
887 else
889 ngettext("%*s/%s kB (%d%%), %d/%d tablespace",
890 "%*s/%s kB (%d%%), %d/%d tablespaces",
892 (int) strlen(totalsize_str),
894 tablespacenum, tablespacecount);
895
896 /*
897 * Stay on the same line if reporting to a terminal and we're not done
898 * yet.
899 */
900 fputc((!finished && isatty(fileno(stderr))) ? '\r' : '\n', stderr);
901}
902
903static int32
905{
906 double result;
907 char *after_num;
908 char *suffix = NULL;
909
910 errno = 0;
911 result = strtod(src, &after_num);
912 if (src == after_num)
913 pg_fatal("transfer rate \"%s\" is not a valid value", src);
914 if (errno != 0)
915 pg_fatal("invalid transfer rate \"%s\": %m", src);
916
917 if (result <= 0)
918 {
919 /*
920 * Reject obviously wrong values here.
921 */
922 pg_fatal("transfer rate must be greater than zero");
923 }
924
925 /*
926 * Evaluate suffix, after skipping over possible whitespace. Lack of
927 * suffix means kilobytes.
928 */
929 while (*after_num != '\0' && isspace((unsigned char) *after_num))
930 after_num++;
931
932 if (*after_num != '\0')
933 {
934 suffix = after_num;
935 if (*after_num == 'k')
936 {
937 /* kilobyte is the expected unit. */
938 after_num++;
939 }
940 else if (*after_num == 'M')
941 {
942 after_num++;
943 result *= 1024.0;
944 }
945 }
946
947 /* The rest can only consist of white space. */
948 while (*after_num != '\0' && isspace((unsigned char) *after_num))
949 after_num++;
950
951 if (*after_num != '\0')
952 pg_fatal("invalid --max-rate unit: \"%s\"", suffix);
953
954 /* Valid integer? */
955 if ((uint64) result != (uint64) ((uint32) result))
956 pg_fatal("transfer rate \"%s\" exceeds integer range", src);
957
958 /*
959 * The range is checked on the server side too, but avoid the server
960 * connection if a nonsensical value was passed.
961 */
963 pg_fatal("transfer rate \"%s\" is out of range", src);
964
965 return (int32) result;
966}
967
968/*
969 * Basic parsing of a value specified for -Z/--compress.
970 *
971 * We're not concerned here with understanding exactly what behavior the
972 * user wants, but we do need to know whether the user is requesting client
973 * or server side compression or leaving it unspecified, and we need to
974 * separate the name of the compression algorithm from the detail string.
975 *
976 * For instance, if the user writes --compress client-lz4:6, we want to
977 * separate that into (a) client-side compression, (b) algorithm "lz4",
978 * and (c) detail "6". Note, however, that all the client/server prefix is
979 * optional, and so is the detail. The algorithm name is required, unless
980 * the whole string is an integer, in which case we assume "gzip" as the
981 * algorithm and use the integer as the detail.
982 *
983 * We're not concerned with validation at this stage, so if the user writes
984 * --compress client-turkey:sandwich, the requested algorithm is "turkey"
985 * and the detail string is "sandwich". We'll sort out whether that's legal
986 * at a later stage.
987 */
988static void
989backup_parse_compress_options(char *option, char **algorithm, char **detail,
991{
992 /*
993 * Strip off any "client-" or "server-" prefix, calculating the location.
994 */
995 if (strncmp(option, "server-", 7) == 0)
996 {
998 option += 7;
999 }
1000 else if (strncmp(option, "client-", 7) == 0)
1001 {
1003 option += 7;
1004 }
1005 else
1007
1008 /* fallback to the common parsing for the algorithm and detail */
1009 parse_compress_options(option, algorithm, detail);
1010}
1011
1012/*
1013 * Read a stream of COPY data and invoke the provided callback for each
1014 * chunk.
1015 */
1016static void
1018 void *callback_data)
1019{
1020 PGresult *res;
1021
1022 /* Get the COPY data stream. */
1023 res = PQgetResult(conn);
1024 if (PQresultStatus(res) != PGRES_COPY_OUT)
1025 pg_fatal("could not get COPY data stream: %s",
1027 PQclear(res);
1028
1029 /* Loop over chunks until done. */
1030 while (1)
1031 {
1032 int r;
1033 char *copybuf;
1034
1035 r = PQgetCopyData(conn, &copybuf, 0);
1036 if (r == -1)
1037 {
1038 /* End of chunk. */
1039 break;
1040 }
1041 else if (r == -2)
1042 pg_fatal("could not read COPY data: %s",
1044
1045 if (bgchild_exited)
1046 pg_fatal("background process terminated unexpectedly");
1047
1048 (*callback) (r, copybuf, callback_data);
1049
1051 }
1052}
1053
1054/*
1055 * Figure out what to do with an archive received from the server based on
1056 * the options selected by the user. We may just write the results directly
1057 * to a file, or we might compress first, or we might extract the tar file
1058 * and write each member separately. This function doesn't do any of that
1059 * directly, but it works out what kind of astreamer we need to create so
1060 * that the right stuff happens when, down the road, we actually receive
1061 * the data.
1062 */
1063static astreamer *
1064CreateBackupStreamer(char *archive_name, char *spclocation,
1066 bool is_recovery_guc_supported,
1068 pg_compress_specification *compress)
1069{
1070 astreamer *streamer = NULL;
1071 astreamer *manifest_inject_streamer = NULL;
1072 bool inject_manifest;
1073 bool is_tar,
1076 bool must_parse_archive;
1077
1078 /*
1079 * Normally, we emit the backup manifest as a separate file, but when
1080 * we're writing a tarfile to stdout, we don't have that option, so
1081 * include it in the one tarfile we've got.
1082 */
1083 inject_manifest = (format == 't' && strcmp(basedir, "-") == 0 && manifest);
1084
1085 /* Check whether it is a tar archive and its compression type */
1086 is_tar = parse_tar_compress_algorithm(archive_name,
1088
1089 /* Is this any kind of compressed tar? */
1092
1093 /*
1094 * Injecting the manifest into a compressed tar file would be possible if
1095 * we decompressed it, parsed the tarfile, generated a new tarfile, and
1096 * recompressed it, but compressing and decompressing multiple times just
1097 * to inject the manifest seems inefficient enough that it's probably not
1098 * what the user wants. So, instead, reject the request and tell the user
1099 * to specify something more reasonable.
1100 */
1102 {
1103 pg_log_error("cannot inject manifest into a compressed tar file");
1104 pg_log_error_hint("Use client-side compression, send the output to a directory rather than standard output, or use %s.",
1105 "--no-manifest");
1106 exit(1);
1107 }
1108
1109 /*
1110 * We have to parse the archive if (1) we're suppose to extract it, or if
1111 * (2) we need to inject backup_manifest or recovery configuration into
1112 * it. However, we only know how to parse tar archives.
1113 */
1116
1117 /* At present, we only know how to parse tar archives. */
1118 if (must_parse_archive && !is_tar)
1119 {
1120 pg_log_error("cannot parse archive \"%s\"", archive_name);
1121 pg_log_error_detail("Only tar archives can be parsed.");
1122 if (format == 'p')
1123 pg_log_error_detail("Plain format requires pg_basebackup to parse the archive.");
1124 if (inject_manifest)
1125 pg_log_error_detail("Using - as the output directory requires pg_basebackup to parse the archive.");
1127 pg_log_error_detail("The -R option requires pg_basebackup to parse the archive.");
1128 exit(1);
1129 }
1130
1131 if (format == 'p')
1132 {
1133 const char *directory;
1134
1135 /*
1136 * In plain format, we must extract the archive. The data for the main
1137 * tablespace will be written to the base directory, and the data for
1138 * other tablespaces will be written to the directory where they're
1139 * located on the server, after applying any user-specified tablespace
1140 * mappings.
1141 *
1142 * In the case of an in-place tablespace, spclocation will be a
1143 * relative path. We just convert it to an absolute path by prepending
1144 * basedir.
1145 */
1146 if (spclocation == NULL)
1148 else if (!is_absolute_path(spclocation))
1150 else
1155 }
1156 else
1157 {
1160
1161 /*
1162 * In tar format, we just write the archive without extracting it.
1163 * Normally, we write it to the archive name provided by the caller,
1164 * but when the base directory is "-" that means we need to write to
1165 * standard output.
1166 */
1167 if (strcmp(basedir, "-") == 0)
1168 {
1170 archive_file = stdout;
1171 }
1172 else
1173 {
1175 "%s/%s", basedir, archive_name);
1177 }
1178
1179 if (compress->algorithm == PG_COMPRESSION_NONE)
1181 archive_file);
1182 else if (compress->algorithm == PG_COMPRESSION_GZIP)
1183 {
1184 strlcat(archive_filename, ".gz", sizeof(archive_filename));
1186 archive_file, compress);
1187 }
1188 else if (compress->algorithm == PG_COMPRESSION_LZ4)
1189 {
1190 strlcat(archive_filename, ".lz4", sizeof(archive_filename));
1192 archive_file);
1193 streamer = astreamer_lz4_compressor_new(streamer, compress);
1194 }
1195 else if (compress->algorithm == PG_COMPRESSION_ZSTD)
1196 {
1197 strlcat(archive_filename, ".zst", sizeof(archive_filename));
1199 archive_file);
1200 streamer = astreamer_zstd_compressor_new(streamer, compress);
1201 }
1202 else
1203 {
1204 Assert(false); /* not reachable */
1205 }
1206
1207 /*
1208 * If we need to parse the archive for whatever reason, then we'll
1209 * also need to re-archive, because, if the output format is tar, the
1210 * only point of parsing the archive is to be able to inject stuff
1211 * into it.
1212 */
1214 streamer = astreamer_tar_archiver_new(streamer);
1216 }
1217
1218 /*
1219 * If we're supposed to inject the backup manifest into the results, it
1220 * should be done here, so that the file content can be injected directly,
1221 * without worrying about the details of the tar format.
1222 */
1223 if (inject_manifest)
1224 manifest_inject_streamer = streamer;
1225
1226 /*
1227 * If this is the main tablespace and we're supposed to write recovery
1228 * information, arrange to do that.
1229 */
1231 {
1233 streamer = astreamer_recovery_injector_new(streamer,
1234 is_recovery_guc_supported,
1236 }
1237
1238 /*
1239 * If we're doing anything that involves understanding the contents of the
1240 * archive, we'll need to parse it. If not, we can skip parsing it, but
1241 * old versions of the server send improperly terminated tarfiles, so if
1242 * we're talking to such a server we'll need to add the terminator here.
1243 */
1245 streamer = astreamer_tar_parser_new(streamer);
1247 streamer = astreamer_tar_terminator_new(streamer);
1248
1249 /*
1250 * If the user has requested a server compressed archive along with
1251 * archive extraction at client then we need to decompress it.
1252 */
1253 if (format == 'p' && is_compressed_tar)
1254 {
1256 streamer = astreamer_gzip_decompressor_new(streamer);
1258 streamer = astreamer_lz4_decompressor_new(streamer);
1260 streamer = astreamer_zstd_decompressor_new(streamer);
1261 }
1262
1263 /* Return the results. */
1264 *manifest_inject_streamer_p = manifest_inject_streamer;
1265 return streamer;
1266}
1267
1268/*
1269 * Receive all of the archives the server wants to send - and the backup
1270 * manifest if present - as a single COPY stream.
1271 */
1272static void
1274{
1276
1277 /* Set up initial state. */
1278 memset(&state, 0, sizeof(state));
1279 state.tablespacenum = -1;
1280 state.compress = compress;
1281
1282 /* All the real work happens in ReceiveArchiveStreamChunk. */
1284
1285 /* If we wrote the backup manifest to a file, close the file. */
1286 if (state.manifest_file != NULL)
1287 {
1288 fclose(state.manifest_file);
1289 state.manifest_file = NULL;
1290 }
1291
1292 /*
1293 * If we buffered the backup manifest in order to inject it into the
1294 * output tarfile, do that now.
1295 */
1296 if (state.manifest_inject_streamer != NULL &&
1297 state.manifest_buffer != NULL)
1298 {
1299 astreamer_inject_file(state.manifest_inject_streamer,
1300 "backup_manifest",
1301 state.manifest_buffer->data,
1302 state.manifest_buffer->len);
1303 destroyPQExpBuffer(state.manifest_buffer);
1304 state.manifest_buffer = NULL;
1305 }
1306
1307 /* If there's still an archive in progress, end processing. */
1308 if (state.streamer != NULL)
1309 {
1310 astreamer_finalize(state.streamer);
1311 astreamer_free(state.streamer);
1312 state.streamer = NULL;
1313 }
1314}
1315
1316/*
1317 * Receive one chunk of data sent by the server as part of a single COPY
1318 * stream that includes all archives and the manifest.
1319 */
1320static void
1321ReceiveArchiveStreamChunk(size_t r, char *copybuf, void *callback_data)
1322{
1323 ArchiveStreamState *state = callback_data;
1324 size_t cursor = 0;
1325
1326 /* Each CopyData message begins with a type byte. */
1327 switch (GetCopyDataByte(r, copybuf, &cursor))
1328 {
1330 {
1331 /* New archive. */
1332 char *archive_name;
1333 char *spclocation;
1334
1335 /*
1336 * We force a progress report at the end of each tablespace. A
1337 * new tablespace starts when the previous one ends, except in
1338 * the case of the very first one.
1339 */
1340 if (++state->tablespacenum > 0)
1341 progress_report(state->tablespacenum, true, false);
1342
1343 /* Sanity check. */
1344 if (state->manifest_buffer != NULL ||
1345 state->manifest_file != NULL)
1346 pg_fatal("archives must precede manifest");
1347
1348 /* Parse the rest of the CopyData message. */
1349 archive_name = GetCopyDataString(r, copybuf, &cursor);
1352
1353 /*
1354 * Basic sanity checks on the archive name: it shouldn't be
1355 * empty, it shouldn't start with a dot, and it shouldn't
1356 * contain a path separator.
1357 */
1358 if (archive_name[0] == '\0' || archive_name[0] == '.' ||
1359 strchr(archive_name, '/') != NULL ||
1360 strchr(archive_name, '\\') != NULL)
1361 pg_fatal("invalid archive name: \"%s\"",
1362 archive_name);
1363
1364 /*
1365 * An empty spclocation is treated as NULL. We expect this
1366 * case to occur for the data directory itself, but not for
1367 * any archives that correspond to tablespaces.
1368 */
1369 if (spclocation[0] == '\0')
1370 spclocation = NULL;
1371
1372 /* End processing of any prior archive. */
1373 if (state->streamer != NULL)
1374 {
1375 astreamer_finalize(state->streamer);
1376 astreamer_free(state->streamer);
1377 state->streamer = NULL;
1378 }
1379
1380 /*
1381 * Create an appropriate backup streamer, unless a backup
1382 * target was specified. In that case, it's up to the server
1383 * to put the backup wherever it needs to go.
1384 */
1385 if (backup_target == NULL)
1386 {
1387 /*
1388 * We know that recovery GUCs are supported, because this
1389 * protocol can only be used on v15+.
1390 */
1391 state->streamer =
1392 CreateBackupStreamer(archive_name,
1394 &state->manifest_inject_streamer,
1395 true, false,
1396 state->compress);
1397 }
1398 break;
1399 }
1400
1401 case PqMsg_CopyData:
1402 {
1403 /* Archive or manifest data. */
1404 if (state->manifest_buffer != NULL)
1405 {
1406 /* Manifest data, buffer in memory. */
1407 appendPQExpBuffer(state->manifest_buffer, copybuf + 1,
1408 r - 1);
1409 }
1410 else if (state->manifest_file != NULL)
1411 {
1412 /* Manifest data, write to disk. */
1413 if (fwrite(copybuf + 1, r - 1, 1,
1414 state->manifest_file) != 1)
1415 {
1416 /*
1417 * If fwrite() didn't set errno, assume that the
1418 * problem is that we're out of disk space.
1419 */
1420 if (errno == 0)
1421 errno = ENOSPC;
1422 pg_fatal("could not write to file \"%s\": %m",
1423 state->manifest_filename);
1424 }
1425 }
1426 else if (state->streamer != NULL)
1427 {
1428 /* Archive data. */
1429 astreamer_content(state->streamer, NULL, copybuf + 1,
1430 r - 1, ASTREAMER_UNKNOWN);
1431 }
1432 else
1433 pg_fatal("unexpected payload data");
1434 break;
1435 }
1436
1438 {
1439 /*
1440 * Progress report.
1441 *
1442 * The remainder of the message is expected to be an 8-byte
1443 * count of bytes completed.
1444 */
1447
1448 /*
1449 * The server shouldn't send progress report messages too
1450 * often, so we force an update each time we receive one.
1451 */
1452 progress_report(state->tablespacenum, true, false);
1453 break;
1454 }
1455
1457 {
1458 /*
1459 * Manifest data will be sent next. This message is not
1460 * expected to have any further payload data.
1461 */
1463
1464 /*
1465 * If a backup target was specified, figuring out where to put
1466 * the manifest is the server's problem. Otherwise, we need to
1467 * deal with it.
1468 */
1469 if (backup_target == NULL)
1470 {
1471 /*
1472 * If we're supposed inject the manifest into the archive,
1473 * we prepare to buffer it in memory; otherwise, we
1474 * prepare to write it to a temporary file.
1475 */
1476 if (state->manifest_inject_streamer != NULL)
1477 state->manifest_buffer = createPQExpBuffer();
1478 else
1479 {
1480 snprintf(state->manifest_filename,
1481 sizeof(state->manifest_filename),
1482 "%s/backup_manifest.tmp", basedir);
1483 state->manifest_file =
1484 fopen(state->manifest_filename, "wb");
1485 if (state->manifest_file == NULL)
1486 pg_fatal("could not create file \"%s\": %m",
1487 state->manifest_filename);
1488 }
1489 }
1490 break;
1491 }
1492
1493 default:
1495 break;
1496 }
1497}
1498
1499/*
1500 * Get a single byte from a CopyData message.
1501 *
1502 * Bail out if none remain.
1503 */
1504static char
1505GetCopyDataByte(size_t r, char *copybuf, size_t *cursor)
1506{
1507 if (*cursor >= r)
1509
1510 return copybuf[(*cursor)++];
1511}
1512
1513/*
1514 * Get a NUL-terminated string from a CopyData message.
1515 *
1516 * Bail out if the terminating NUL cannot be found.
1517 */
1518static char *
1519GetCopyDataString(size_t r, char *copybuf, size_t *cursor)
1520{
1521 size_t startpos = *cursor;
1522 size_t endpos = startpos;
1523
1524 while (1)
1525 {
1526 if (endpos >= r)
1528 if (copybuf[endpos] == '\0')
1529 break;
1530 ++endpos;
1531 }
1532
1533 *cursor = endpos + 1;
1534 return &copybuf[startpos];
1535}
1536
1537/*
1538 * Get an unsigned 64-bit integer from a CopyData message.
1539 *
1540 * Bail out if there are not at least 8 bytes remaining.
1541 */
1542static uint64
1543GetCopyDataUInt64(size_t r, char *copybuf, size_t *cursor)
1544{
1545 uint64 result;
1546
1547 if (*cursor + sizeof(uint64) > r)
1549 memcpy(&result, &copybuf[*cursor], sizeof(uint64));
1550 *cursor += sizeof(uint64);
1551 return pg_ntoh64(result);
1552}
1553
1554/*
1555 * Bail out if we didn't parse the whole message.
1556 */
1557static void
1558GetCopyDataEnd(size_t r, char *copybuf, size_t cursor)
1559{
1560 if (r != cursor)
1562}
1563
1564/*
1565 * Report failure to parse a CopyData message from the server. Then exit.
1566 *
1567 * As a debugging aid, we try to give some hint about what kind of message
1568 * provoked the failure. Perhaps this is not detailed enough, but it's not
1569 * clear that it's worth expending any more code on what should be a
1570 * can't-happen case.
1571 */
1572static void
1574{
1575 if (r == 0)
1576 pg_fatal("empty COPY message");
1577 else
1578 pg_fatal("malformed COPY message of type %d, length %zu",
1579 copybuf[0], r);
1580}
1581
1582/*
1583 * Receive raw tar data from the server, and stream it to the appropriate
1584 * location. If we're writing a single tarfile to standard output, also
1585 * receive the backup manifest and inject it into that tarfile.
1586 */
1587static void
1588ReceiveTarFile(PGconn *conn, char *archive_name, char *spclocation,
1589 bool tablespacenum, pg_compress_specification *compress)
1590{
1592 astreamer *manifest_inject_streamer;
1593 bool is_recovery_guc_supported;
1595
1596 /* Pass all COPY data through to the backup streamer. */
1597 memset(&state, 0, sizeof(state));
1598 is_recovery_guc_supported =
1602 state.streamer = CreateBackupStreamer(archive_name, spclocation,
1603 &manifest_inject_streamer,
1604 is_recovery_guc_supported,
1606 compress);
1607 state.tablespacenum = tablespacenum;
1610
1611 /*
1612 * The decision as to whether we need to inject the backup manifest into
1613 * the output at this stage is made by CreateBackupStreamer; if that is
1614 * needed, manifest_inject_streamer will be non-NULL; otherwise, it will
1615 * be NULL.
1616 */
1617 if (manifest_inject_streamer != NULL)
1618 {
1620
1621 /* Slurp the entire backup manifest into a buffer. */
1625 pg_fatal("out of memory");
1626
1627 /* Inject it into the output tarfile. */
1628 astreamer_inject_file(manifest_inject_streamer, "backup_manifest",
1629 buf.data, buf.len);
1630
1631 /* Free memory. */
1633 }
1634
1635 /* Cleanup. */
1636 astreamer_finalize(state.streamer);
1637 astreamer_free(state.streamer);
1638
1639 progress_report(tablespacenum, true, false);
1640
1641 /*
1642 * Do not sync the resulting tar file yet, all files are synced once at
1643 * the end.
1644 */
1645}
1646
1647/*
1648 * Receive one chunk of tar-format data from the server.
1649 */
1650static void
1651ReceiveTarCopyChunk(size_t r, char *copybuf, void *callback_data)
1652{
1653 WriteTarState *state = callback_data;
1654
1656
1657 totaldone += r;
1658 progress_report(state->tablespacenum, false, false);
1659}
1660
1661
1662/*
1663 * Retrieve tablespace path, either relocated or original depending on whether
1664 * -T was passed or not.
1665 */
1666static const char *
1668{
1669 TablespaceListCell *cell;
1670 char canon_dir[MAXPGPATH];
1671
1672 /* Canonicalize path for comparison consistency */
1673 strlcpy(canon_dir, dir, sizeof(canon_dir));
1675
1676 for (cell = tablespace_dirs.head; cell; cell = cell->next)
1677 if (strcmp(canon_dir, cell->old_dir) == 0)
1678 return cell->new_dir;
1679
1680 return dir;
1681}
1682
1683/*
1684 * Receive the backup manifest file and write it out to a file.
1685 */
1686static void
1688{
1690
1691 snprintf(state.filename, sizeof(state.filename),
1692 "%s/backup_manifest.tmp", basedir);
1693 state.file = fopen(state.filename, "wb");
1694 if (state.file == NULL)
1695 pg_fatal("could not create file \"%s\": %m", state.filename);
1696
1698
1699 fclose(state.file);
1700}
1701
1702/*
1703 * Receive one chunk of the backup manifest file and write it out to a file.
1704 */
1705static void
1706ReceiveBackupManifestChunk(size_t r, char *copybuf, void *callback_data)
1707{
1708 WriteManifestState *state = callback_data;
1709
1710 errno = 0;
1711 if (fwrite(copybuf, r, 1, state->file) != 1)
1712 {
1713 /* if write didn't set errno, assume problem is no disk space */
1714 if (errno == 0)
1715 errno = ENOSPC;
1716 pg_fatal("could not write to file \"%s\": %m", state->filename);
1717 }
1718}
1719
1720/*
1721 * Receive the backup manifest file and write it out to a file.
1722 */
1723static void
1728
1729/*
1730 * Receive one chunk of the backup manifest file and write it out to a file.
1731 */
1732static void
1734 void *callback_data)
1735{
1736 PQExpBuffer buf = callback_data;
1737
1739}
1740
1741static void
1746{
1747 PGresult *res;
1748 char *sysidentifier;
1750 TimeLineID starttli;
1751 char *basebkp;
1752 int i;
1753 char xlogstart[64];
1754 char xlogend[64] = {0};
1755 int minServerMajor,
1757 int serverVersion,
1760 bool use_new_option_syntax = false;
1762
1763 Assert(conn != NULL);
1765
1766 /*
1767 * Check server version. BASE_BACKUP command was introduced in 9.1, so we
1768 * can't work with servers older than 9.1.
1769 */
1770 minServerMajor = 901;
1773 serverMajor = serverVersion / 100;
1775 {
1776 const char *serverver = PQparameterStatus(conn, "server_version");
1777
1778 pg_fatal("incompatible server version %s",
1779 serverver ? serverver : "'unknown'");
1780 }
1781 if (serverMajor >= 1500)
1782 use_new_option_syntax = true;
1783
1784 /*
1785 * If WAL streaming was requested, also check that the server is new
1786 * enough for that.
1787 */
1789 {
1790 /*
1791 * Error message already written in CheckServerVersionForStreaming(),
1792 * but add a hint about using -X none.
1793 */
1794 pg_log_error_hint("Use -X none or -X fetch to disable log streaming.");
1795 exit(1);
1796 }
1797
1798 /*
1799 * Build contents of configuration file if requested.
1800 *
1801 * Note that we don't use the dbname from key-value pair in conn as that
1802 * would have been filled by the default dbname (dbname=replication) in
1803 * case the user didn't specify the one. The dbname written in the config
1804 * file as part of primary_conninfo would be used by slotsync worker which
1805 * doesn't use a replication connection so the default won't work for it.
1806 */
1811
1812 /*
1813 * Run IDENTIFY_SYSTEM so we can get the timeline
1814 */
1815 if (!RunIdentifySystem(conn, &sysidentifier, &latesttli, NULL, NULL))
1816 exit(1);
1817
1818 /*
1819 * If the user wants an incremental backup, we must upload the manifest
1820 * for the previous backup upon which it is to be based.
1821 */
1823 {
1824 int fd;
1825 char mbuf[65536];
1826 ssize_t nbytes;
1827
1828 /* Reject if server is too old. */
1830 pg_fatal("server does not support incremental backup");
1831
1832 /* Open the file. */
1834 if (fd < 0)
1835 pg_fatal("could not open file \"%s\": %m", incremental_manifest);
1836
1837 /* Tell the server what we want to do. */
1838 if (PQsendQuery(conn, "UPLOAD_MANIFEST") == 0)
1839 pg_fatal("could not send replication command \"%s\": %s",
1840 "UPLOAD_MANIFEST", PQerrorMessage(conn));
1841 res = PQgetResult(conn);
1842 if (PQresultStatus(res) != PGRES_COPY_IN)
1843 {
1845 pg_fatal("could not upload manifest: %s",
1847 else
1848 pg_fatal("could not upload manifest: unexpected status %s",
1850 }
1851
1852 /* Loop, reading from the file and sending the data to the server. */
1853 while ((nbytes = read(fd, mbuf, sizeof mbuf)) > 0)
1854 {
1855 if (PQputCopyData(conn, mbuf, nbytes) < 0)
1856 pg_fatal("could not send COPY data: %s",
1858 }
1859
1860 /* Bail out if we exited the loop due to an error. */
1861 if (nbytes < 0)
1862 pg_fatal("could not read file \"%s\": %m", incremental_manifest);
1863
1864 /* End the COPY operation. */
1865 if (PQputCopyEnd(conn, NULL) < 0)
1866 pg_fatal("could not send end-of-COPY: %s",
1868
1869 /* See whether the server is happy with what we sent. */
1870 res = PQgetResult(conn);
1872 pg_fatal("could not upload manifest: %s",
1874 else if (PQresultStatus(res) != PGRES_COMMAND_OK)
1875 pg_fatal("could not upload manifest: unexpected status %s",
1877
1878 /* Consume ReadyForQuery message from server. */
1879 res = PQgetResult(conn);
1880 if (res != NULL)
1881 pg_fatal("unexpected extra result while sending manifest");
1882
1883 /* Add INCREMENTAL option to BASE_BACKUP command. */
1885 }
1886
1887 /*
1888 * Continue building up the options list for the BASE_BACKUP command.
1889 */
1891 if (estimatesize)
1893 if (includewal == FETCH_WAL)
1895 if (fastcheckpoint)
1896 {
1899 "CHECKPOINT", "fast");
1900 else
1902 }
1903 if (includewal != NO_WAL)
1904 {
1907 else
1909 }
1910 if (maxrate > 0)
1912 maxrate);
1913 if (format == 't')
1915 if (!verify_checksums)
1916 {
1919 "VERIFY_CHECKSUMS", 0);
1920 else
1922 "NOVERIFY_CHECKSUMS");
1923 }
1924
1925 if (manifest)
1926 {
1928 manifest_force_encode ? "force-encode" : "yes");
1929 if (manifest_checksums != NULL)
1931 "MANIFEST_CHECKSUMS", manifest_checksums);
1932 }
1933
1934 if (backup_target != NULL)
1935 {
1936 char *colon;
1937
1938 if (serverMajor < 1500)
1939 pg_fatal("backup targets are not supported by this server version");
1940
1942 pg_fatal("recovery configuration cannot be written when a backup target is used");
1943
1945
1946 if ((colon = strchr(backup_target, ':')) == NULL)
1947 {
1949 "TARGET", backup_target);
1950 }
1951 else
1952 {
1953 char *target;
1954
1957 "TARGET", target);
1959 "TARGET_DETAIL", colon + 1);
1960 }
1961 }
1962 else if (serverMajor >= 1500)
1964 "TARGET", "client");
1965
1967 {
1969 pg_fatal("server does not support server-side compression");
1971 "COMPRESSION", compression_algorithm);
1972 if (compression_detail != NULL)
1974 "COMPRESSION_DETAIL",
1976 }
1977
1978 if (verbose)
1979 pg_log_info("initiating base backup, waiting for checkpoint to complete");
1980
1981 if (showprogress && !verbose)
1982 {
1983 fprintf(stderr, _("waiting for checkpoint"));
1984 if (isatty(fileno(stderr)))
1985 fprintf(stderr, "\r");
1986 else
1987 fprintf(stderr, "\n");
1988 }
1989
1990 if (use_new_option_syntax && buf.len > 0)
1991 basebkp = psprintf("BASE_BACKUP (%s)", buf.data);
1992 else
1993 basebkp = psprintf("BASE_BACKUP %s", buf.data);
1994
1995 /* OK, try to start the backup. */
1996 if (PQsendQuery(conn, basebkp) == 0)
1997 pg_fatal("could not send replication command \"%s\": %s",
1998 "BASE_BACKUP", PQerrorMessage(conn));
1999
2000 /*
2001 * Get the starting WAL location
2002 */
2003 res = PQgetResult(conn);
2004 if (PQresultStatus(res) != PGRES_TUPLES_OK)
2005 pg_fatal("could not initiate base backup: %s",
2007 if (PQntuples(res) != 1)
2008 pg_fatal("server returned unexpected response to BASE_BACKUP command; got %d rows and %d fields, expected %d rows and %d fields",
2009 PQntuples(res), PQnfields(res), 1, 2);
2010
2011 strlcpy(xlogstart, PQgetvalue(res, 0, 0), sizeof(xlogstart));
2012
2013 if (verbose)
2014 pg_log_info("checkpoint completed");
2015
2016 /*
2017 * 9.3 and later sends the TLI of the starting point. With older servers,
2018 * assume it's the same as the latest timeline reported by
2019 * IDENTIFY_SYSTEM.
2020 */
2021 if (PQnfields(res) >= 2)
2022 starttli = atoi(PQgetvalue(res, 0, 1));
2023 else
2024 starttli = latesttli;
2025 PQclear(res);
2026
2027 if (verbose && includewal != NO_WAL)
2028 pg_log_info("write-ahead log start point: %s on timeline %u",
2029 xlogstart, starttli);
2030
2031 /*
2032 * Get the header
2033 */
2034 res = PQgetResult(conn);
2035 if (PQresultStatus(res) != PGRES_TUPLES_OK)
2036 pg_fatal("could not get backup header: %s",
2038 if (PQntuples(res) < 1)
2039 pg_fatal("no data returned from server");
2040
2041 /*
2042 * Sum up the total size, for progress reporting
2043 */
2044 totalsize_kb = totaldone = 0;
2046 for (i = 0; i < PQntuples(res); i++)
2047 {
2048 totalsize_kb += atoll(PQgetvalue(res, i, 2));
2049
2050 /*
2051 * Verify tablespace directories are empty. Don't bother with the
2052 * first once since it can be relocated, and it will be checked before
2053 * we do anything anyway.
2054 *
2055 * Note that this is skipped for tar format backups and backups that
2056 * the server is storing to a target location, since in that case we
2057 * won't be storing anything into these directories and thus should
2058 * not create them.
2059 */
2060 if (backup_target == NULL && format == 'p' && !PQgetisnull(res, i, 1))
2061 {
2062 char *path = PQgetvalue(res, i, 1);
2063
2064 if (is_absolute_path(path))
2065 path = unconstify(char *, get_tablespace_mapping(path));
2066 else
2067 {
2068 /* This is an in-place tablespace, so prepend basedir. */
2069 path = psprintf("%s/%s", basedir, path);
2070 }
2071
2073 }
2074 }
2075
2076 /*
2077 * When writing to stdout, require a single tablespace
2078 */
2079 writing_to_stdout = format == 't' && basedir != NULL &&
2080 strcmp(basedir, "-") == 0;
2081 if (writing_to_stdout && PQntuples(res) > 1)
2082 pg_fatal("can only write single tablespace to stdout, database has %d",
2083 PQntuples(res));
2084
2085 /*
2086 * If we're streaming WAL, start the streaming session before we start
2087 * receiving the actual data chunks.
2088 */
2089 if (includewal == STREAM_WAL)
2090 {
2091 pg_compress_algorithm wal_compress_algorithm;
2092 int wal_compress_level;
2093
2094 if (verbose)
2095 pg_log_info("starting background WAL receiver");
2096
2097 if (client_compress->algorithm == PG_COMPRESSION_GZIP)
2098 {
2099 wal_compress_algorithm = PG_COMPRESSION_GZIP;
2100 wal_compress_level = client_compress->level;
2101 }
2102 else
2103 {
2104 wal_compress_algorithm = PG_COMPRESSION_NONE;
2105 wal_compress_level = 0;
2106 }
2107
2108 StartLogStreamer(xlogstart, starttli, sysidentifier,
2109 wal_compress_algorithm,
2110 wal_compress_level);
2111 }
2112
2113 if (serverMajor >= 1500)
2114 {
2115 /* Receive a single tar stream with everything. */
2117 }
2118 else
2119 {
2120 /* Receive a tar file for each tablespace in turn */
2121 for (i = 0; i < PQntuples(res); i++)
2122 {
2123 char archive_name[MAXPGPATH];
2124 char *spclocation;
2125
2126 /*
2127 * If we write the data out to a tar file, it will be named
2128 * base.tar if it's the main data directory or <tablespaceoid>.tar
2129 * if it's for another tablespace. CreateBackupStreamer() will
2130 * arrange to add an extension to the archive name if
2131 * pg_basebackup is performing compression, depending on the
2132 * compression type.
2133 */
2134 if (PQgetisnull(res, i, 0))
2135 {
2136 strlcpy(archive_name, "base.tar", sizeof(archive_name));
2137 spclocation = NULL;
2138 }
2139 else
2140 {
2141 snprintf(archive_name, sizeof(archive_name),
2142 "%s.tar", PQgetvalue(res, i, 0));
2143 spclocation = PQgetvalue(res, i, 1);
2144 }
2145
2146 ReceiveTarFile(conn, archive_name, spclocation, i,
2148 }
2149
2150 /*
2151 * Now receive backup manifest, if appropriate.
2152 *
2153 * If we're writing a tarfile to stdout, ReceiveTarFile will have
2154 * already processed the backup manifest and included it in the output
2155 * tarfile. Such a configuration doesn't allow for writing multiple
2156 * files.
2157 *
2158 * If we're talking to an older server, it won't send a backup
2159 * manifest, so don't try to receive one.
2160 */
2163 }
2164
2165 if (showprogress)
2166 {
2168 progress_report(PQntuples(res), true, true);
2169 }
2170
2171 PQclear(res);
2172
2173 /*
2174 * Get the stop position
2175 */
2176 res = PQgetResult(conn);
2177 if (PQresultStatus(res) != PGRES_TUPLES_OK)
2178 pg_fatal("backup failed: %s",
2180 if (PQntuples(res) != 1)
2181 pg_fatal("no write-ahead log end position returned from server");
2182 strlcpy(xlogend, PQgetvalue(res, 0, 0), sizeof(xlogend));
2183 if (verbose && includewal != NO_WAL)
2184 pg_log_info("write-ahead log end point: %s", xlogend);
2185 PQclear(res);
2186
2187 res = PQgetResult(conn);
2188 if (PQresultStatus(res) != PGRES_COMMAND_OK)
2189 {
2190 const char *sqlstate = PQresultErrorField(res, PG_DIAG_SQLSTATE);
2191
2192 if (sqlstate &&
2193 strcmp(sqlstate, ERRCODE_DATA_CORRUPTED) == 0)
2194 {
2195 pg_log_error("checksum error occurred");
2196 checksum_failure = true;
2197 }
2198 else
2199 {
2200 pg_log_error("final receive failed: %s",
2202 }
2203 exit(1);
2204 }
2205
2206 if (bgchild > 0)
2207 {
2208#ifndef WIN32
2209 int status;
2210 pid_t r;
2211#else
2212 DWORD status;
2213
2214 /*
2215 * get a pointer sized version of bgchild to avoid warnings about
2216 * casting to a different size on WIN64.
2217 */
2219 uint32 hi,
2220 lo;
2221#endif
2222
2223 if (verbose)
2224 pg_log_info("waiting for background process to finish streaming ...");
2225
2226#ifndef WIN32
2228 pg_fatal("could not send command to background pipe: %m");
2229
2230 /* Just wait for the background process to exit */
2231 r = waitpid(bgchild, &status, 0);
2232 if (r == (pid_t) -1)
2233 pg_fatal("could not wait for child process: %m");
2234 if (r != bgchild)
2235 pg_fatal("child %d died, expected %d", (int) r, (int) bgchild);
2236 if (status != 0)
2237 pg_fatal("%s", wait_result_to_str(status));
2238 /* Exited normally, we're happy! */
2239#else /* WIN32 */
2240
2241 /*
2242 * On Windows, since we are in the same process, we can just store the
2243 * value directly in the variable, and then set the flag that says
2244 * it's there.
2245 */
2246 if (sscanf(xlogend, "%X/%08X", &hi, &lo) != 2)
2247 pg_fatal("could not parse write-ahead log location \"%s\"",
2248 xlogend);
2249 xlogendptr = ((uint64) hi) << 32 | lo;
2251
2252 /* First wait for the thread to exit */
2255 {
2257 pg_fatal("could not wait for child thread: %m");
2258 }
2259 if (GetExitCodeThread((HANDLE) bgchild_handle, &status) == 0)
2260 {
2262 pg_fatal("could not get child thread exit status: %m");
2263 }
2264 if (status != 0)
2265 pg_fatal("child thread exited with error %u",
2266 (unsigned int) status);
2267 /* Exited normally, we're happy */
2268#endif
2269 }
2270
2271 /* Free the configuration file contents */
2273
2274 /*
2275 * End of copy data. Final result is already checked inside the loop.
2276 */
2277 PQclear(res);
2278 PQfinish(conn);
2279 conn = NULL;
2280
2281 /*
2282 * Make data persistent on disk once backup is completed. For tar format
2283 * sync the parent directory and all its contents as each tar file was not
2284 * synced after being completed. In plain format, all the data of the
2285 * base directory is synced, taking into account all the tablespaces.
2286 * Errors are not considered fatal.
2287 *
2288 * If, however, there's a backup target, we're not writing anything
2289 * locally, so in that case we skip this step.
2290 */
2291 if (do_sync && backup_target == NULL)
2292 {
2293 if (verbose)
2294 pg_log_info("syncing data to disk ...");
2295 if (format == 't')
2296 {
2297 if (strcmp(basedir, "-") != 0)
2299 }
2300 else
2301 {
2303 }
2304 }
2305
2306 /*
2307 * After synchronizing data to disk, perform a durable rename of
2308 * backup_manifest.tmp to backup_manifest, if we wrote such a file. This
2309 * way, a failure or system crash before we reach this point will leave us
2310 * without a backup_manifest file, decreasing the chances that a directory
2311 * we leave behind will be mistaken for a valid backup.
2312 */
2314 {
2315 char tmp_filename[MAXPGPATH];
2316 char filename[MAXPGPATH];
2317
2318 if (verbose)
2319 pg_log_info("renaming backup_manifest.tmp to backup_manifest");
2320
2321 snprintf(tmp_filename, MAXPGPATH, "%s/backup_manifest.tmp", basedir);
2322 snprintf(filename, MAXPGPATH, "%s/backup_manifest", basedir);
2323
2324 if (do_sync)
2325 {
2326 /* durable_rename emits its own log message in case of failure */
2328 exit(1);
2329 }
2330 else
2331 {
2332 if (rename(tmp_filename, filename) != 0)
2333 pg_fatal("could not rename file \"%s\" to \"%s\": %m",
2335 }
2336 }
2337
2338 if (verbose)
2339 pg_log_info("base backup completed");
2340}
2341
2342
2343int
2344main(int argc, char **argv)
2345{
2346 static struct option long_options[] = {
2347 {"help", no_argument, NULL, '?'},
2348 {"version", no_argument, NULL, 'V'},
2349 {"pgdata", required_argument, NULL, 'D'},
2350 {"format", required_argument, NULL, 'F'},
2351 {"incremental", required_argument, NULL, 'i'},
2352 {"checkpoint", required_argument, NULL, 'c'},
2353 {"create-slot", no_argument, NULL, 'C'},
2354 {"max-rate", required_argument, NULL, 'r'},
2355 {"write-recovery-conf", no_argument, NULL, 'R'},
2356 {"slot", required_argument, NULL, 'S'},
2357 {"target", required_argument, NULL, 't'},
2358 {"tablespace-mapping", required_argument, NULL, 'T'},
2359 {"wal-method", required_argument, NULL, 'X'},
2360 {"gzip", no_argument, NULL, 'z'},
2361 {"compress", required_argument, NULL, 'Z'},
2362 {"label", required_argument, NULL, 'l'},
2363 {"no-clean", no_argument, NULL, 'n'},
2364 {"no-sync", no_argument, NULL, 'N'},
2365 {"dbname", required_argument, NULL, 'd'},
2366 {"host", required_argument, NULL, 'h'},
2367 {"port", required_argument, NULL, 'p'},
2368 {"username", required_argument, NULL, 'U'},
2369 {"no-password", no_argument, NULL, 'w'},
2370 {"password", no_argument, NULL, 'W'},
2371 {"status-interval", required_argument, NULL, 's'},
2372 {"verbose", no_argument, NULL, 'v'},
2373 {"progress", no_argument, NULL, 'P'},
2374 {"waldir", required_argument, NULL, 1},
2375 {"no-slot", no_argument, NULL, 2},
2376 {"no-verify-checksums", no_argument, NULL, 3},
2377 {"no-estimate-size", no_argument, NULL, 4},
2378 {"no-manifest", no_argument, NULL, 5},
2379 {"manifest-force-encode", no_argument, NULL, 6},
2380 {"manifest-checksums", required_argument, NULL, 7},
2381 {"sync-method", required_argument, NULL, 8},
2382 {NULL, 0, NULL, 0}
2383 };
2384 int c;
2385
2386 int option_index;
2387 char *compression_algorithm = "none";
2388 char *compression_detail = NULL;
2389 char *incremental_manifest = NULL;
2392
2393 pg_logging_init(argv[0]);
2394 progname = get_progname(argv[0]);
2395 set_pglocale_pgservice(argv[0], PG_TEXTDOMAIN("pg_basebackup"));
2396
2397 if (argc > 1)
2398 {
2399 if (strcmp(argv[1], "--help") == 0 || strcmp(argv[1], "-?") == 0)
2400 {
2401 usage();
2402 exit(0);
2403 }
2404 else if (strcmp(argv[1], "-V") == 0
2405 || strcmp(argv[1], "--version") == 0)
2406 {
2407 puts("pg_basebackup (PostgreSQL) " PG_VERSION);
2408 exit(0);
2409 }
2410 }
2411
2413
2414 while ((c = getopt_long(argc, argv, "c:Cd:D:F:h:i:l:nNp:Pr:Rs:S:t:T:U:vwWX:zZ:",
2415 long_options, &option_index)) != -1)
2416 {
2417 switch (c)
2418 {
2419 case 'c':
2420 if (pg_strcasecmp(optarg, "fast") == 0)
2421 fastcheckpoint = true;
2422 else if (pg_strcasecmp(optarg, "spread") == 0)
2423 fastcheckpoint = false;
2424 else
2425 pg_fatal("invalid checkpoint argument \"%s\", must be \"fast\" or \"spread\"",
2426 optarg);
2427 break;
2428 case 'C':
2429 create_slot = true;
2430 break;
2431 case 'd':
2433 break;
2434 case 'D':
2436 break;
2437 case 'F':
2438 if (strcmp(optarg, "p") == 0 || strcmp(optarg, "plain") == 0)
2439 format = 'p';
2440 else if (strcmp(optarg, "t") == 0 || strcmp(optarg, "tar") == 0)
2441 format = 't';
2442 else
2443 pg_fatal("invalid output format \"%s\", must be \"plain\" or \"tar\"",
2444 optarg);
2445 break;
2446 case 'h':
2448 break;
2449 case 'i':
2451 break;
2452 case 'l':
2454 break;
2455 case 'n':
2456 noclean = true;
2457 break;
2458 case 'N':
2459 do_sync = false;
2460 break;
2461 case 'p':
2463 break;
2464 case 'P':
2465 showprogress = true;
2466 break;
2467 case 'r':
2469 break;
2470 case 'R':
2471 writerecoveryconf = true;
2472 break;
2473 case 's':
2474 if (!option_parse_int(optarg, "-s/--status-interval", 0,
2475 INT_MAX / 1000,
2477 exit(1);
2479 break;
2480 case 'S':
2481
2482 /*
2483 * When specifying replication slot name, use a permanent
2484 * slot.
2485 */
2487 temp_replication_slot = false;
2488 break;
2489 case 't':
2491 break;
2492 case 'T':
2494 break;
2495 case 'U':
2497 break;
2498 case 'v':
2499 verbose++;
2500 break;
2501 case 'w':
2502 dbgetpassword = -1;
2503 break;
2504 case 'W':
2505 dbgetpassword = 1;
2506 break;
2507 case 'X':
2508 if (strcmp(optarg, "n") == 0 ||
2509 strcmp(optarg, "none") == 0)
2510 {
2512 }
2513 else if (strcmp(optarg, "f") == 0 ||
2514 strcmp(optarg, "fetch") == 0)
2515 {
2517 }
2518 else if (strcmp(optarg, "s") == 0 ||
2519 strcmp(optarg, "stream") == 0)
2520 {
2522 }
2523 else
2524 pg_fatal("invalid wal-method option \"%s\", must be \"fetch\", \"stream\", or \"none\"",
2525 optarg);
2526 break;
2527 case 'z':
2528 compression_algorithm = "gzip";
2531 break;
2532 case 'Z':
2535 break;
2536 case 1:
2538 break;
2539 case 2:
2540 no_slot = true;
2541 break;
2542 case 3:
2543 verify_checksums = false;
2544 break;
2545 case 4:
2546 estimatesize = false;
2547 break;
2548 case 5:
2549 manifest = false;
2550 break;
2551 case 6:
2552 manifest_force_encode = true;
2553 break;
2554 case 7:
2556 break;
2557 case 8:
2559 exit(1);
2560 break;
2561 default:
2562 /* getopt_long already emitted a complaint */
2563 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2564 exit(1);
2565 }
2566 }
2567
2568 /*
2569 * Any non-option arguments?
2570 */
2571 if (optind < argc)
2572 {
2573 pg_log_error("too many command-line arguments (first is \"%s\")",
2574 argv[optind]);
2575 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2576 exit(1);
2577 }
2578
2579 /*
2580 * Setting the backup target to 'client' is equivalent to leaving out the
2581 * option. This logic allows us to assume elsewhere that the backup is
2582 * being stored locally if and only if backup_target == NULL.
2583 */
2584 if (backup_target != NULL && strcmp(backup_target, "client") == 0)
2585 {
2588 }
2589
2590 /*
2591 * Can't use --format with --target. Without --target, default format is
2592 * tar.
2593 */
2594 if (backup_target != NULL && format != '\0')
2595 {
2596 pg_log_error("cannot specify both format and backup target");
2597 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2598 exit(1);
2599 }
2600 if (format == '\0')
2601 format = 'p';
2602
2603 /*
2604 * Either directory or backup target should be specified, but not both
2605 */
2606 if (basedir == NULL && backup_target == NULL)
2607 {
2608 pg_log_error("must specify output directory or backup target");
2609 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2610 exit(1);
2611 }
2612 if (basedir != NULL && backup_target != NULL)
2613 {
2614 pg_log_error("cannot specify both output directory and backup target");
2615 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2616 exit(1);
2617 }
2618
2619 /*
2620 * If the user has not specified where to perform backup compression,
2621 * default to the client, unless the user specified --target, in which
2622 * case the server is the only choice.
2623 */
2625 {
2626 if (backup_target == NULL)
2628 else
2630 }
2631
2632 /*
2633 * If any compression that we're doing is happening on the client side, we
2634 * must try to parse the compression algorithm and detail, but if it's all
2635 * on the server side, then we're just going to pass through whatever was
2636 * requested and let the server decide what to do.
2637 */
2639 {
2641 char *error_detail;
2642
2644 pg_fatal("unrecognized compression algorithm: \"%s\"",
2646
2649 if (error_detail != NULL)
2650 pg_fatal("invalid compression specification: %s",
2651 error_detail);
2652 }
2653 else
2654 {
2657 client_compress.options = 0;
2658 }
2659
2660 /*
2661 * Can't perform client-side compression if the backup is not being sent
2662 * to the client.
2663 */
2665 {
2666 pg_log_error("client-side compression is not possible when a backup target is specified");
2667 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2668 exit(1);
2669 }
2670
2671 /*
2672 * Client-side compression doesn't make sense unless tar format is in use.
2673 */
2674 if (format == 'p' && compressloc == COMPRESS_LOCATION_CLIENT &&
2676 {
2677 pg_log_error("only tar mode backups can be compressed");
2678 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2679 exit(1);
2680 }
2681
2682 /*
2683 * Sanity checks for WAL method.
2684 */
2686 {
2687 pg_log_error("WAL cannot be streamed when a backup target is specified");
2688 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2689 exit(1);
2690 }
2691 if (format == 't' && includewal == STREAM_WAL && strcmp(basedir, "-") == 0)
2692 {
2693 pg_log_error("cannot stream write-ahead logs in tar mode to stdout");
2694 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2695 exit(1);
2696 }
2697
2699 {
2700 pg_log_error("replication slots can only be used with WAL streaming");
2701 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2702 exit(1);
2703 }
2704
2705 /*
2706 * Sanity checks for replication slot options.
2707 */
2708 if (no_slot)
2709 {
2710 if (replication_slot)
2711 {
2712 pg_log_error("--no-slot cannot be used with slot name");
2713 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2714 exit(1);
2715 }
2716 temp_replication_slot = false;
2717 }
2718
2719 if (create_slot)
2720 {
2721 if (!replication_slot)
2722 {
2723 pg_log_error("%s needs a slot to be specified using --slot",
2724 "--create-slot");
2725 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2726 exit(1);
2727 }
2728
2729 if (no_slot)
2730 {
2731 pg_log_error("%s and %s are incompatible options",
2732 "--create-slot", "--no-slot");
2733 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2734 exit(1);
2735 }
2736 }
2737
2738 /*
2739 * Sanity checks on WAL directory.
2740 */
2741 if (xlog_dir)
2742 {
2743 if (backup_target != NULL)
2744 {
2745 pg_log_error("WAL directory location cannot be specified along with a backup target");
2746 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2747 exit(1);
2748 }
2749 if (format != 'p')
2750 {
2751 pg_log_error("WAL directory location can only be specified in plain mode");
2752 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2753 exit(1);
2754 }
2755
2756 /* clean up xlog directory name, check it's absolute */
2759 {
2760 pg_log_error("WAL directory location must be an absolute path");
2761 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2762 exit(1);
2763 }
2764 }
2765
2766 /*
2767 * Sanity checks for progress reporting options.
2768 */
2769 if (showprogress && !estimatesize)
2770 {
2771 pg_log_error("%s and %s are incompatible options",
2772 "--progress", "--no-estimate-size");
2773 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2774 exit(1);
2775 }
2776
2777 /*
2778 * Sanity checks for backup manifest options.
2779 */
2780 if (!manifest && manifest_checksums != NULL)
2781 {
2782 pg_log_error("%s and %s are incompatible options",
2783 "--no-manifest", "--manifest-checksums");
2784 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2785 exit(1);
2786 }
2787
2789 {
2790 pg_log_error("%s and %s are incompatible options",
2791 "--no-manifest", "--manifest-force-encode");
2792 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
2793 exit(1);
2794 }
2795
2796 /* connection in replication mode to server */
2797 conn = GetConnection();
2798 if (!conn)
2799 {
2800 /* Error message already written in GetConnection() */
2801 exit(1);
2802 }
2804
2805#ifndef WIN32
2806
2807 /*
2808 * Trap SIGCHLD to be able to handle the WAL stream process exiting. There
2809 * is no SIGCHLD on Windows, there we rely on the background thread
2810 * setting the signal variable on unexpected but graceful exit. If the WAL
2811 * stream thread crashes on Windows it will bring down the entire process
2812 * as it's a thread, so there is nothing to catch should that happen. A
2813 * crash on UNIX will be caught by the signal handler.
2814 */
2816#endif
2817
2818 /*
2819 * Set umask so that directories/files are created with the same
2820 * permissions as directories/files in the source data directory.
2821 *
2822 * pg_mode_mask is set to owner-only by default and then updated in
2823 * GetConnection() where we get the mode from the server-side with
2824 * RetrieveDataDirCreatePerm() and then call SetDataDirectoryCreatePerm().
2825 */
2827
2828 /* Backup manifests are supported in 13 and newer versions */
2830 manifest = false;
2831
2832 /*
2833 * If an output directory was specified, verify that it exists, or create
2834 * it. Note that for a tar backup, an output directory of "-" means we are
2835 * writing to stdout, so do nothing in that case.
2836 */
2837 if (basedir != NULL && (format == 'p' || strcmp(basedir, "-") != 0))
2839
2840 /* determine remote server's xlog segment size */
2842 exit(1);
2843
2844 /* Create pg_wal symlink, if required */
2845 if (xlog_dir)
2846 {
2847 char *linkloc;
2848
2850
2851 /*
2852 * Form name of the place where the symlink must go. pg_xlog has been
2853 * renamed to pg_wal in post-10 clusters.
2854 */
2855 linkloc = psprintf("%s/%s", basedir,
2857 "pg_xlog" : "pg_wal");
2858
2859 if (symlink(xlog_dir, linkloc) != 0)
2860 pg_fatal("could not create symbolic link \"%s\": %m", linkloc);
2861 pfree(linkloc);
2862 }
2863
2866
2867 success = true;
2868 return 0;
2869}
static void astreamer_free(astreamer *streamer)
Definition astreamer.h:155
static void astreamer_content(astreamer *streamer, astreamer_member *member, const char *data, int len, astreamer_archive_context context)
Definition astreamer.h:137
static void astreamer_finalize(astreamer *streamer)
Definition astreamer.h:147
@ ASTREAMER_UNKNOWN
Definition astreamer.h:64
astreamer * astreamer_plain_writer_new(char *pathname, FILE *file)
astreamer * astreamer_extractor_new(const char *basepath, const char *(*link_map)(const char *), void(*report_output_file)(const char *))
astreamer * astreamer_gzip_decompressor_new(astreamer *next)
astreamer * astreamer_gzip_writer_new(char *pathname, FILE *file, pg_compress_specification *compress)
astreamer * astreamer_recovery_injector_new(astreamer *next, bool is_recovery_guc_supported, PQExpBuffer recoveryconfcontents)
void astreamer_inject_file(astreamer *streamer, char *pathname, char *data, int len)
astreamer * astreamer_lz4_compressor_new(astreamer *next, pg_compress_specification *compress)
astreamer * astreamer_lz4_decompressor_new(astreamer *next)
astreamer * astreamer_tar_parser_new(astreamer *next)
astreamer * astreamer_tar_terminator_new(astreamer *next)
astreamer * astreamer_tar_archiver_new(astreamer *next)
astreamer * astreamer_zstd_compressor_new(astreamer *next, pg_compress_specification *compress)
astreamer * astreamer_zstd_decompressor_new(astreamer *next)
Datum now(PG_FUNCTION_ARGS)
Definition timestamp.c:1613
#define MAX_RATE_UPPER
Definition basebackup.h:21
#define unconstify(underlying_type, expr)
Definition c.h:1370
#define ngettext(s, p, n)
Definition c.h:1310
#define SIGNAL_ARGS
Definition c.h:1519
#define Assert(condition)
Definition c.h:1002
#define PG_TEXTDOMAIN(domain)
Definition c.h:1343
#define PG_BINARY
Definition c.h:1431
#define UINT64_FORMAT
Definition c.h:694
int32_t int32
Definition c.h:679
uint64_t uint64
Definition c.h:684
uint32_t uint32
Definition c.h:683
uint32 result
memcpy(sums, checksumBaseOffsets, sizeof(checksumBaseOffsets))
void set_pglocale_pgservice(const char *argv0, const char *app)
Definition exec.c:430
int main(void)
bool parse_tar_compress_algorithm(const char *fname, pg_compress_algorithm *algorithm)
Definition compression.c:49
char * validate_compress_specification(pg_compress_specification *spec)
bool parse_compress_algorithm(char *name, pg_compress_algorithm *algorithm)
Definition compression.c:79
void parse_compress_specification(pg_compress_algorithm algorithm, char *specification, pg_compress_specification *result)
pg_compress_algorithm
Definition compression.h:22
@ PG_COMPRESSION_GZIP
Definition compression.h:24
@ PG_COMPRESSION_LZ4
Definition compression.h:25
@ PG_COMPRESSION_NONE
Definition compression.h:23
@ PG_COMPRESSION_ZSTD
Definition compression.h:26
void parse_compress_options(const char *option, char **algorithm, char **detail)
#define fprintf(file, fmt, msg)
Definition cubescan.l:21
Datum arg
Definition elog.c:1323
#define _(x)
Definition elog.c:96
int durable_rename(const char *oldfile, const char *newfile, int elevel)
Definition fd.c:783
int PQserverVersion(const PGconn *conn)
const char * PQparameterStatus(const PGconn *conn, const char *paramName)
void PQfinish(PGconn *conn)
int PQbackendPID(const PGconn *conn)
char * PQerrorMessage(const PGconn *conn)
void PQfreemem(void *ptr)
Definition fe-exec.c:4068
int PQputCopyEnd(PGconn *conn, const char *errormsg)
Definition fe-exec.c:2766
int PQputCopyData(PGconn *conn, const char *buffer, int nbytes)
Definition fe-exec.c:2712
int PQsendQuery(PGconn *conn, const char *query)
Definition fe-exec.c:1433
char * PQresStatus(ExecStatusType status)
Definition fe-exec.c:3450
int PQgetCopyData(PGconn *conn, char **buffer, int async)
Definition fe-exec.c:2833
char * pg_strdup(const char *in)
Definition fe_memutils.c:91
void pg_free(void *ptr)
#define pg_malloc0_object(type)
Definition fe_memutils.h:61
int pg_mode_mask
Definition file_perm.c:25
int pg_dir_create_mode
Definition file_perm.c:18
DataDirSyncMethod
Definition file_utils.h:28
@ DATA_DIR_SYNC_METHOD_FSYNC
Definition file_utils.h:29
int getopt_long(int argc, char *const argv[], const char *optstring, const struct option *longopts, int *longindex)
Definition getopt_long.c:60
#define no_argument
Definition getopt_long.h:25
#define required_argument
Definition getopt_long.h:26
#define colon
#define write(a, b, c)
Definition win32.h:14
#define read(a, b, c)
Definition win32.h:13
int i
Definition isn.c:77
#define PQgetvalue
#define PQgetResult
#define PQclear
#define PQresultErrorField
#define PQnfields
#define PQresultStatus
#define PQgetisnull
#define PQntuples
@ PGRES_COPY_IN
Definition libpq-fe.h:138
@ PGRES_COMMAND_OK
Definition libpq-fe.h:131
@ PGRES_FATAL_ERROR
Definition libpq-fe.h:142
@ PGRES_COPY_OUT
Definition libpq-fe.h:137
@ PGRES_TUPLES_OK
Definition libpq-fe.h:134
void pg_logging_init(const char *argv0)
Definition logging.c:85
#define pg_log_error(...)
Definition logging.h:108
#define pg_log_error_hint(...)
Definition logging.h:114
#define pg_log_info(...)
Definition logging.h:126
#define pg_log_error_detail(...)
Definition logging.h:111
const char * progname
Definition main.c:44
void pfree(void *pointer)
Definition mcxt.c:1619
char * pnstrdup(const char *in, Size len)
Definition mcxt.c:1921
bool option_parse_int(const char *optarg, const char *optname, int min_range, int max_range, int *result)
bool parse_sync_method(const char *optarg, DataDirSyncMethod *sync_method)
#define pg_fatal(...)
static void BaseBackup(char *compression_algorithm, char *compression_detail, CompressionLocation compressloc, pg_compress_specification *client_compress, char *incremental_manifest)
static void ReceiveArchiveStreamChunk(size_t r, char *copybuf, void *callback_data)
static int verbose
static bool checksum_failure
void(* WriteDataCallback)(size_t nbytes, char *buf, void *callback_data)
static bool noclean
static bool estimatesize
static bool found_existing_pgdata
static bool manifest
static bool found_existing_xlogdir
#define MINIMUM_VERSION_FOR_TEMP_SLOTS
static int32 maxrate
static void ReceiveTarFile(PGconn *conn, char *archive_name, char *spclocation, bool tablespacenum, pg_compress_specification *compress)
static char * backup_target
static char format
static char * xlog_dir
static void ReceiveCopyData(PGconn *conn, WriteDataCallback callback, void *callback_data)
static void StartLogStreamer(char *startpos, uint32 timeline, char *sysidentifier, pg_compress_algorithm wal_compress_algorithm, int wal_compress_level)
static void ReceiveBackupManifestChunk(size_t r, char *copybuf, void *callback_data)
static char * GetCopyDataString(size_t r, char *copybuf, size_t *cursor)
static int32 parse_max_rate(char *src)
IncludeWal
@ STREAM_WAL
@ FETCH_WAL
@ NO_WAL
static volatile sig_atomic_t bgchild_exited
static int bgpipe[2]
static bool create_slot
static void ReceiveTarCopyChunk(size_t r, char *copybuf, void *callback_data)
static int LogStreamerMain(logstreamer_param *param)
static void ReceiveArchiveStream(PGconn *conn, pg_compress_specification *compress)
static void backup_parse_compress_options(char *option, char **algorithm, char **detail, CompressionLocation *locationres)
static PQExpBuffer recoveryconfcontents
static int tablespacecount
static void progress_update_filename(const char *filename)
static pid_t bgchild
CompressionLocation
@ COMPRESS_LOCATION_UNSPECIFIED
@ COMPRESS_LOCATION_CLIENT
@ COMPRESS_LOCATION_SERVER
static bool reached_end_position(XLogRecPtr segendpos, uint32 timeline, bool segment_finished)
static int has_xlogendptr
static void verify_dir_is_empty_or_create(char *dirname, bool *created, bool *found)
static char * progress_filename
static uint64 totalsize_kb
static pg_time_t last_progress_report
static bool verify_checksums
static char * replication_slot
static void GetCopyDataEnd(size_t r, char *copybuf, size_t cursor)
static bool success
static void ReceiveBackupManifest(PGconn *conn)
static uint64 totaldone
static void progress_report(int tablespacenum, bool force, bool finished)
static bool manifest_force_encode
static char * manifest_checksums
static astreamer * CreateBackupStreamer(char *archive_name, char *spclocation, astreamer **manifest_inject_streamer_p, bool is_recovery_guc_supported, bool expect_unterminated_tarfile, pg_compress_specification *compress)
#define MINIMUM_VERSION_FOR_TERMINATED_TARFILE
static TablespaceList tablespace_dirs
static bool found_tablespace_dirs
static bool in_log_streamer
static bool made_new_xlogdir
static IncludeWal includewal
static void ReportCopyDataParseError(size_t r, char *copybuf)
static bool do_sync
static bool writerecoveryconf
static void cleanup_directories_atexit(void)
static bool temp_replication_slot
#define MINIMUM_VERSION_FOR_MANIFESTS
static bool no_slot
static bool made_tablespace_dirs
static char GetCopyDataByte(size_t r, char *copybuf, size_t *cursor)
#define VERBOSE_FILENAME_LENGTH
static uint64 GetCopyDataUInt64(size_t r, char *copybuf, size_t *cursor)
static bool fastcheckpoint
static bool made_new_pgdata
static void kill_bgchild_atexit(void)
static DataDirSyncMethod sync_method
#define ERRCODE_DATA_CORRUPTED
static char * label
static void ReceiveBackupManifestInMemoryChunk(size_t r, char *copybuf, void *callback_data)
static bool showprogress
static void usage(void)
static void tablespace_list_append(const char *arg)
static const char * get_tablespace_mapping(const char *dir)
static char * basedir
static void disconnect_atexit(void)
static void ReceiveBackupManifestInMemory(PGconn *conn, PQExpBuffer buf)
static XLogRecPtr xlogendptr
#define MINIMUM_VERSION_FOR_PG_WAL
static int standby_message_timeout
#define MINIMUM_VERSION_FOR_WAL_SUMMARIES
static void sigchld_handler(SIGNAL_ARGS)
#define pg_ntoh64(x)
Definition pg_bswap.h:126
#define MAXPGPATH
static char * filename
Definition pg_dumpall.c:120
PGDLLIMPORT int optind
Definition getopt.c:47
PGDLLIMPORT char * optarg
Definition getopt.c:49
static pg_compress_algorithm compression_algorithm
static XLogRecPtr endpos
static XLogRecPtr startpos
static char buf[DEFAULT_XLOG_SEG_SIZE]
int64 pg_time_t
Definition pgtime.h:23
#define pqsignal
Definition port.h:548
int pg_mkdir_p(char *path, int omode)
Definition pgmkdirp.c:57
#define is_absolute_path(filename)
Definition port.h:105
int pg_strcasecmp(const char *s1, const char *s2)
void canonicalize_path(char *path)
Definition path.c:337
int pg_check_dir(const char *dir)
Definition pgcheckdir.c:33
#define snprintf
Definition port.h:261
#define PGINVALID_SOCKET
Definition port.h:31
const char * get_progname(const char *argv0)
Definition path.c:669
#define is_windows_absolute_path(filename)
Definition port.h:91
#define printf(...)
Definition port.h:267
size_t strlcat(char *dst, const char *src, size_t siz)
Definition strlcat.c:34
size_t strlcpy(char *dst, const char *src, size_t siz)
Definition strlcpy.c:45
#define is_nonwindows_absolute_path(filename)
Definition port.h:84
#define PG_DIAG_SQLSTATE
PQExpBuffer createPQExpBuffer(void)
Definition pqexpbuffer.c:72
void initPQExpBuffer(PQExpBuffer str)
Definition pqexpbuffer.c:90
void appendPQExpBuffer(PQExpBuffer str, const char *fmt,...)
void destroyPQExpBuffer(PQExpBuffer str)
void termPQExpBuffer(PQExpBuffer str)
#define PQExpBufferDataBroken(buf)
Definition pqexpbuffer.h:67
char * c
static int fd(const char *x, int i)
static int fb(int x)
#define PqMsg_CopyData
Definition protocol.h:65
#define PqBackupMsg_ProgressReport
Definition protocol.h:91
#define PqBackupMsg_NewArchive
Definition protocol.h:90
#define PqBackupMsg_Manifest
Definition protocol.h:89
char * psprintf(const char *fmt,...)
Definition psprintf.c:43
bool ReceiveXlogStream(PGconn *conn, StreamCtl *stream)
Definition receivelog.c:453
bool CheckServerVersionForStreaming(PGconn *conn)
Definition receivelog.c:375
PQExpBuffer GenerateRecoveryConfig(PGconn *pgconn, const char *replication_slot, char *dbname)
char * GetDbnameFromConnectionOptions(const char *connstr)
#define MINIMUM_VERSION_FOR_RECOVERY_GUC
bool rmtree(const char *path, bool rmtopdir)
Definition rmtree.c:50
int dbgetpassword
Definition streamutil.c:50
PGconn * GetConnection(void)
Definition streamutil.c:60
bool RetrieveWalSegSize(PGconn *conn)
Definition streamutil.c:276
int WalSegSz
Definition streamutil.c:32
char * dbhost
Definition streamutil.c:46
void AppendPlainCommandOption(PQExpBuffer buf, bool use_new_option_syntax, const char *option_name)
Definition streamutil.c:777
void AppendStringCommandOption(PQExpBuffer buf, bool use_new_option_syntax, const char *option_name, const char *option_value)
Definition streamutil.c:798
char * dbport
Definition streamutil.c:48
void AppendIntegerCommandOption(PQExpBuffer buf, bool use_new_option_syntax, const char *option_name, int32 option_value)
Definition streamutil.c:817
char * connection_string
Definition streamutil.c:45
PGconn * conn
Definition streamutil.c:52
bool RunIdentifySystem(PGconn *conn, char **sysid, TimeLineID *starttli, XLogRecPtr *startpos, char **db_name)
Definition streamutil.c:409
char * dbuser
Definition streamutil.c:47
char manifest_filename[MAXPGPATH]
pg_compress_specification * compress
astreamer * manifest_inject_streamer
astreamer * streamer
PQExpBuffer manifest_buffer
char * sysidentifier
Definition receivelog.h:33
TimeLineID timeline
Definition receivelog.h:32
stream_stop_callback stream_stop
Definition receivelog.h:41
char * replication_slot
Definition receivelog.h:48
XLogRecPtr startpos
Definition receivelog.h:31
bool do_sync
Definition receivelog.h:38
pgsocket stop_socket
Definition receivelog.h:43
int standby_message_timeout
Definition receivelog.h:35
WalWriteMethod * walmethod
Definition receivelog.h:46
bool mark_done
Definition receivelog.h:37
char * partial_suffix
Definition receivelog.h:47
bool synchronous
Definition receivelog.h:36
struct TablespaceListCell * next
char old_dir[MAXPGPATH]
char new_dir[MAXPGPATH]
TablespaceListCell * tail
TablespaceListCell * head
void(* free)(WalWriteMethod *wwmethod)
Definition walmethods.h:92
bool(* finish)(WalWriteMethod *wwmethod)
Definition walmethods.h:86
const WalWriteMethodOps * ops
Definition walmethods.h:105
char filename[MAXPGPATH]
astreamer * streamer
Definition type.h:139
pg_compress_algorithm wal_compress_algorithm
char xlog[MAXPGPATH]
pg_compress_algorithm algorithm
Definition compression.h:34
static StringInfo copybuf
Definition tablesync.c:129
static void callback(struct sockaddr *addr, struct sockaddr *mask, void *unused)
static char * error_detail
Definition validator.c:43
char * wait_result_to_str(int exitstatus)
Definition wait_error.c:33
WalWriteMethod * CreateWalTarMethod(const char *tarbase, pg_compress_algorithm compression_algorithm, int compression_level, bool sync)
WalWriteMethod * CreateWalDirectoryMethod(const char *basedir, pg_compress_algorithm compression_algorithm, int compression_level, bool sync)
Definition walmethods.c:640
static void CreateReplicationSlot(CreateReplicationSlotCmd *cmd)
Definition walsender.c:1265
#define SIGCHLD
Definition win32_port.h:168
void _dosmaperr(unsigned long)
Definition win32error.c:177
#define kill(pid, sig)
Definition win32_port.h:507
#define symlink(oldpath, newpath)
Definition win32_port.h:242
#define select(n, r, w, e, timeout)
Definition win32_port.h:517
#define XLogSegmentOffset(xlogptr, wal_segsz_bytes)
uint64 XLogRecPtr
Definition xlogdefs.h:21
uint32 TimeLineID
Definition xlogdefs.h:63
static const char * directory
Definition zic.c:1229