PostgreSQL Source Code git master
Loading...
Searching...
No Matches
pg_recvlogical.c
Go to the documentation of this file.
1/*-------------------------------------------------------------------------
2 *
3 * pg_recvlogical.c - receive data from a logical decoding slot in a streaming
4 * fashion and write it to a local file.
5 *
6 * Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group
7 *
8 * IDENTIFICATION
9 * src/bin/pg_basebackup/pg_recvlogical.c
10 *-------------------------------------------------------------------------
11 */
12
13#include "postgres_fe.h"
14
15#include <dirent.h>
16#include <limits.h>
17#include <sys/select.h>
18#include <sys/stat.h>
19#include <unistd.h>
20
21#include "common/file_perm.h"
22#include "common/logging.h"
24#include "getopt_long.h"
25#include "libpq-fe.h"
26#include "libpq/pqsignal.h"
27#include "libpq/protocol.h"
28#include "pqexpbuffer.h"
29#include "streamutil.h"
30
31/* Time to sleep between reconnection attempts */
32#define RECONNECT_SLEEP_TIME 5
33
41
42/* Global Options */
43static char *outfile = NULL;
44static int verbose = 0;
45static bool two_phase = false; /* enable-two-phase option */
46static bool failover = false; /* enable-failover option */
47static int noloop = 0;
48static int standby_message_timeout = 10 * 1000; /* 10 sec = default */
49static int fsync_interval = 10 * 1000; /* 10 sec = default */
52static bool do_create_slot = false;
53static bool slot_exists_ok = false;
54static bool do_start_slot = false;
55static bool do_drop_slot = false;
56static char *replication_slot = NULL;
57
58/* filled pairwise with option, value. value may be NULL */
59static char **options;
60static size_t noptions = 0;
61static const char *plugin = "test_decoding";
62
63/* Global State */
64static int outfd = -1;
65static volatile sig_atomic_t time_to_abort = false;
67static volatile sig_atomic_t output_reopen = false;
68static bool output_isfile;
70static bool output_needs_fsync = false;
73
74static void usage(void);
75static void StreamLogicalLog(void);
78 StreamStopReason reason,
79 XLogRecPtr lsn);
80
81static void
82usage(void)
83{
84 printf(_("%s controls PostgreSQL logical decoding streams.\n\n"),
85 progname);
86 printf(_("Usage:\n"));
87 printf(_(" %s [OPTION]...\n"), progname);
88 printf(_("\nAction to be performed:\n"));
89 printf(_(" --create-slot create a new replication slot (for the slot's name see --slot)\n"));
90 printf(_(" --drop-slot drop the replication slot (for the slot's name see --slot)\n"));
91 printf(_(" --start start streaming in a replication slot (for the slot's name see --slot)\n"));
92 printf(_("\nOptions:\n"));
93 printf(_(" --enable-failover enable replication slot synchronization to standby servers when\n"
94 " creating a replication slot\n"));
95 printf(_(" -E, --endpos=LSN exit after receiving the specified LSN\n"));
96 printf(_(" -f, --file=FILE receive log into this file, - for stdout\n"));
97 printf(_(" -F --fsync-interval=SECS\n"
98 " time between fsyncs to the output file (default: %d)\n"), (fsync_interval / 1000));
99 printf(_(" --if-not-exists do not error if slot already exists when creating a slot\n"));
100 printf(_(" -I, --startpos=LSN where in an existing slot should the streaming start\n"));
101 printf(_(" -n, --no-loop do not loop on connection lost\n"));
102 printf(_(" -o, --option=NAME[=VALUE]\n"
103 " pass option NAME with optional value VALUE to the\n"
104 " output plugin\n"));
105 printf(_(" -P, --plugin=PLUGIN use output plugin PLUGIN (default: %s)\n"), plugin);
106 printf(_(" -s, --status-interval=SECS\n"
107 " time between status packets sent to server (default: %d)\n"), (standby_message_timeout / 1000));
108 printf(_(" -S, --slot=SLOTNAME name of the logical replication slot\n"));
109 printf(_(" -t, --enable-two-phase enable decoding of prepared transactions when creating a slot\n"));
110 printf(_(" --two-phase (same as --enable-two-phase, deprecated)\n"));
111 printf(_(" -v, --verbose output verbose messages\n"));
112 printf(_(" -V, --version output version information, then exit\n"));
113 printf(_(" -?, --help show this help, then exit\n"));
114 printf(_("\nConnection options:\n"));
115 printf(_(" -d, --dbname=DBNAME database to connect to\n"));
116 printf(_(" -h, --host=HOSTNAME database server host or socket directory\n"));
117 printf(_(" -p, --port=PORT database server port number\n"));
118 printf(_(" -U, --username=NAME connect as specified database user\n"));
119 printf(_(" -w, --no-password never prompt for password\n"));
120 printf(_(" -W, --password force password prompt (should happen automatically)\n"));
121 printf(_("\nReport bugs to <%s>.\n"), PACKAGE_BUGREPORT);
122 printf(_("%s home page: <%s>\n"), PACKAGE_NAME, PACKAGE_URL);
123}
124
125/*
126 * Send a Standby Status Update message to server.
127 */
128static bool
130{
133
134 char replybuf[1 + 8 + 8 + 8 + 8 + 1];
135 int len = 0;
136
137 /*
138 * we normally don't want to send superfluous feedback, but if it's
139 * because of a timeout we need to, otherwise wal_sender_timeout will kill
140 * us.
141 */
142 if (!force &&
145 return true;
146
147 if (verbose)
148 pg_log_info("confirming write up to %X/%08X, flush to %X/%08X (slot %s)",
152
154 len += 1;
156 len += 8;
158 len += 8;
160 len += 8;
161 fe_sendint64(now, &replybuf[len]); /* sendTime */
162 len += 8;
163 replybuf[len] = replyRequested ? 1 : 0; /* replyRequested */
164 len += 1;
165
169
170 if (PQputCopyData(conn, replybuf, len) <= 0 || PQflush(conn))
171 {
172 pg_log_error("could not send feedback packet: %s",
174 return false;
175 }
176
177 return true;
178}
179
180static void
182{
183 if (conn != NULL)
184 PQfinish(conn);
185}
186
187static void
189{
191
193
194 /*
195 * Save the last flushed position as the replication start point. On
196 * reconnect, replication resumes from there to avoid re-sending flushed
197 * data.
198 */
200
201 if (fsync_interval <= 0)
202 return;
203
205 return;
206
207 output_needs_fsync = false;
208
209 /* can only fsync if it's a regular file */
210 if (!output_isfile)
211 return;
212
213 if (fsync(outfd) != 0)
214 pg_fatal("could not fsync file \"%s\": %m", outfile);
215}
216
217/*
218 * Start the log streaming
219 */
220static void
222{
223 PGresult *res;
224 char *copybuf = NULL;
226 int i;
227 PQExpBuffer query;
229
231
232 /*
233 * Connect in replication mode to the server
234 */
235 if (!conn)
237 if (!conn)
238 /* Error message already written in GetConnection() */
239 return;
240
241 /*
242 * Start the replication
243 */
244 if (verbose)
245 pg_log_info("starting log streaming at %X/%08X (slot %s)",
248
249 /* Initiate the replication stream at specified location */
250 query = createPQExpBuffer();
251 appendPQExpBuffer(query, "START_REPLICATION SLOT \"%s\" LOGICAL %X/%08X",
253
254 /* print options if there are any */
255 if (noptions)
256 appendPQExpBufferStr(query, " (");
257
258 for (i = 0; i < noptions; i++)
259 {
260 /* separator */
261 if (i > 0)
262 appendPQExpBufferStr(query, ", ");
263
264 /* write option name */
265 appendPQExpBuffer(query, "\"%s\"", options[(i * 2)]);
266
267 /* write option value if specified */
268 if (options[(i * 2) + 1] != NULL)
269 appendPQExpBuffer(query, " '%s'", options[(i * 2) + 1]);
270 }
271
272 if (noptions)
273 appendPQExpBufferChar(query, ')');
274
275 res = PQexec(conn, query->data);
277 {
278 pg_log_error("could not send replication command \"%s\": %s",
279 query->data, PQresultErrorMessage(res));
280 PQclear(res);
281 goto error;
282 }
283 PQclear(res);
284 resetPQExpBuffer(query);
285
286 if (verbose)
287 pg_log_info("streaming initiated");
288
289 while (!time_to_abort)
290 {
291 int r;
292 int bytes_left;
293 int bytes_written;
295 int hdr_len;
296
298
299 if (copybuf != NULL)
300 {
302 copybuf = NULL;
303 }
304
305 /*
306 * Potentially send a status message to the primary.
307 */
309
310 if (outfd != -1 &&
314
315 if (standby_message_timeout > 0 &&
318 {
319 /* Time to send feedback! */
320 if (!sendFeedback(conn, now, true, false))
321 goto error;
322
324 }
325
326 /* got SIGHUP, close output file */
327 if (outfd != -1 && output_reopen && strcmp(outfile, "-") != 0)
328 {
331 close(outfd);
332 outfd = -1;
333 }
334 output_reopen = false;
335
336 /* open the output file, if not open yet */
337 if (outfd == -1)
338 {
339 struct stat statbuf;
340
341 if (strcmp(outfile, "-") == 0)
342 outfd = fileno(stdout);
343 else
345 S_IRUSR | S_IWUSR);
346 if (outfd == -1)
347 {
348 pg_log_error("could not open log file \"%s\": %m", outfile);
349 goto error;
350 }
351
352 if (fstat(outfd, &statbuf) != 0)
353 {
354 pg_log_error("could not stat file \"%s\": %m", outfile);
355 goto error;
356 }
357
358 output_isfile = S_ISREG(statbuf.st_mode) && !isatty(outfd);
359 }
360
361 r = PQgetCopyData(conn, &copybuf, 1);
362 if (r == 0)
363 {
364 /*
365 * In async mode, and no data available. We block on reading but
366 * not more than the specified timeout, so that we can send a
367 * response back to the client.
368 */
372 struct timeval timeout;
373 struct timeval *timeoutptr = NULL;
374
375 if (PQsocket(conn) < 0)
376 {
377 pg_log_error("invalid socket: %s", PQerrorMessage(conn));
378 goto error;
379 }
380
383
384 /* Compute when we need to wakeup to send a keepalive message. */
387 ((int64) 1000);
388
389 /* Compute when we need to wakeup to fsync the output file. */
392 ((int64) 1000);
393
394 /* Now compute when to wakeup. */
395 if (message_target > 0 || fsync_target > 0)
396 {
398 long secs;
399 int usecs;
400
402
405
408 &secs,
409 &usecs);
410 if (secs <= 0)
411 timeout.tv_sec = 1; /* Always sleep at least 1 sec */
412 else
413 timeout.tv_sec = secs;
414 timeout.tv_usec = usecs;
416 }
417
419 if (r == 0 || (r < 0 && errno == EINTR))
420 {
421 /*
422 * Got a timeout or signal. Continue the loop and either
423 * deliver a status packet to the server or just go back into
424 * blocking.
425 */
426 continue;
427 }
428 else if (r < 0)
429 {
430 pg_log_error("%s() failed: %m", "select");
431 goto error;
432 }
433
434 /* Else there is actually data on the socket */
435 if (PQconsumeInput(conn) == 0)
436 {
437 pg_log_error("could not receive data from WAL stream: %s",
439 goto error;
440 }
441 continue;
442 }
443
444 /* End of copy stream */
445 if (r == -1)
446 break;
447
448 /* Failure while reading the copy stream */
449 if (r == -2)
450 {
451 pg_log_error("could not read COPY data: %s",
453 goto error;
454 }
455
456 /* Check the message type. */
458 {
459 int pos;
460 bool replyRequested;
462 bool endposReached = false;
463
464 /*
465 * Parse the keepalive message, enclosed in the CopyData message.
466 * We just check if the server requested a reply, and ignore the
467 * rest.
468 */
469 pos = 1; /* skip msgtype PqReplMsg_Keepalive */
470 walEnd = fe_recvint64(&copybuf[pos]);
472
473 pos += 8; /* read walEnd */
474
475 pos += 8; /* skip sendTime */
476
477 if (r < pos + 1)
478 {
479 pg_log_error("streaming header too small: %d", r);
480 goto error;
481 }
482 replyRequested = copybuf[pos];
483
485 {
486 /*
487 * If there's nothing to read on the socket until a keepalive
488 * we know that the server has nothing to send us; and if
489 * walEnd has passed endpos, we know nothing else can have
490 * committed before endpos. So we can bail out now.
491 */
492 endposReached = true;
493 }
494
495 /* Send a reply, if necessary */
497 {
499 goto error;
501 }
502
503 if (endposReached)
504 {
506 time_to_abort = true;
507 break;
508 }
509
510 continue;
511 }
512 else if (copybuf[0] != PqReplMsg_WALData)
513 {
514 pg_log_error("unrecognized streaming header: \"%c\"",
515 copybuf[0]);
516 goto error;
517 }
518
519 /*
520 * Read the header of the WALData message, enclosed in the CopyData
521 * message. We only need the WAL location field (dataStart), the rest
522 * of the header is ignored.
523 */
524 hdr_len = 1; /* msgtype PqReplMsg_WALData */
525 hdr_len += 8; /* dataStart */
526 hdr_len += 8; /* walEnd */
527 hdr_len += 8; /* sendTime */
528 if (r < hdr_len + 1)
529 {
530 pg_log_error("streaming header too small: %d", r);
531 goto error;
532 }
533
534 /* Extract WAL location for this block */
536
538 {
539 /*
540 * We've read past our endpoint, so prepare to go away being
541 * cautious about what happens to our output data.
542 */
544 goto error;
546 time_to_abort = true;
547 break;
548 }
549
551
552 bytes_left = r - hdr_len;
553 bytes_written = 0;
554
555 /* signal that a fsync is needed */
556 output_needs_fsync = true;
557
558 while (bytes_left)
559 {
560 int ret;
561
562 ret = write(outfd,
564 bytes_left);
565
566 if (ret < 0)
567 {
568 pg_log_error("could not write %d bytes to log file \"%s\": %m",
570 goto error;
571 }
572
573 /* Write was successful, advance our position */
574 bytes_written += ret;
575 bytes_left -= ret;
576 }
577
578 if (write(outfd, "\n", 1) != 1)
579 {
580 pg_log_error("could not write %d bytes to log file \"%s\": %m",
581 1, outfile);
582 goto error;
583 }
584
586 {
587 /* endpos was exactly the record we just processed, we're done */
589 goto error;
591 time_to_abort = true;
592 break;
593 }
594 }
595
596 /* Clean up connection state if stream has been aborted */
597 if (time_to_abort)
599
600 res = PQgetResult(conn);
601 if (PQresultStatus(res) == PGRES_COPY_OUT)
602 {
603 PQclear(res);
604
605 /*
606 * We're doing a client-initiated clean exit and have sent CopyDone to
607 * the server. Drain any messages, so we don't miss a last-minute
608 * ErrorResponse. The walsender stops generating WALData records once
609 * it sees CopyDone, so expect this to finish quickly. After CopyDone,
610 * it's too late for sendFeedback(), even if this were to take a long
611 * time. Hence, use synchronous-mode PQgetCopyData().
612 */
613 while (1)
614 {
615 int r;
616
617 if (copybuf != NULL)
618 {
620 copybuf = NULL;
621 }
622 r = PQgetCopyData(conn, &copybuf, 0);
623 if (r == -1)
624 break;
625 if (r == -2)
626 {
627 pg_log_error("could not read COPY data: %s",
629 time_to_abort = false; /* unclean exit */
630 goto error;
631 }
632 }
633
634 res = PQgetResult(conn);
635 }
637 {
638 pg_log_error("unexpected termination of replication stream: %s",
640 PQclear(res);
641 goto error;
642 }
643 PQclear(res);
644
645 if (outfd != -1 && strcmp(outfile, "-") != 0)
646 {
648
649 OutputFsync(t);
650 if (close(outfd) != 0)
651 pg_log_error("could not close file \"%s\": %m", outfile);
652 }
653 outfd = -1;
654error:
655 if (copybuf != NULL)
656 {
658 copybuf = NULL;
659 }
660 destroyPQExpBuffer(query);
661 PQfinish(conn);
662 conn = NULL;
663}
664
665/*
666 * Unfortunately we can't do sensible signal handling on windows...
667 */
668#ifndef WIN32
669
670/*
671 * When SIGINT/SIGTERM are caught, just tell the system to exit at the next
672 * possible moment.
673 */
674static void
680
681/*
682 * Trigger the output file to be reopened.
683 */
684static void
689#endif
690
691
692int
693main(int argc, char **argv)
694{
695 static struct option long_options[] = {
696/* general options */
697 {"file", required_argument, NULL, 'f'},
698 {"fsync-interval", required_argument, NULL, 'F'},
699 {"no-loop", no_argument, NULL, 'n'},
700 {"enable-failover", no_argument, NULL, 5},
701 {"enable-two-phase", no_argument, NULL, 't'},
702 {"two-phase", no_argument, NULL, 't'}, /* deprecated */
703 {"verbose", no_argument, NULL, 'v'},
704 {"version", no_argument, NULL, 'V'},
705 {"help", no_argument, NULL, '?'},
706/* connection options */
707 {"dbname", required_argument, NULL, 'd'},
708 {"host", required_argument, NULL, 'h'},
709 {"port", required_argument, NULL, 'p'},
710 {"username", required_argument, NULL, 'U'},
711 {"no-password", no_argument, NULL, 'w'},
712 {"password", no_argument, NULL, 'W'},
713/* replication options */
714 {"startpos", required_argument, NULL, 'I'},
715 {"endpos", required_argument, NULL, 'E'},
716 {"option", required_argument, NULL, 'o'},
717 {"plugin", required_argument, NULL, 'P'},
718 {"status-interval", required_argument, NULL, 's'},
719 {"slot", required_argument, NULL, 'S'},
720/* action */
721 {"create-slot", no_argument, NULL, 1},
722 {"start", no_argument, NULL, 2},
723 {"drop-slot", no_argument, NULL, 3},
724 {"if-not-exists", no_argument, NULL, 4},
725 {NULL, 0, NULL, 0}
726 };
727 int c;
728 int option_index;
729 uint32 hi,
730 lo;
731 char *db_name;
732
733 pg_logging_init(argv[0]);
734 progname = get_progname(argv[0]);
735 set_pglocale_pgservice(argv[0], PG_TEXTDOMAIN("pg_basebackup"));
736
737 if (argc > 1)
738 {
739 if (strcmp(argv[1], "--help") == 0 || strcmp(argv[1], "-?") == 0)
740 {
741 usage();
742 exit(0);
743 }
744 else if (strcmp(argv[1], "-V") == 0 ||
745 strcmp(argv[1], "--version") == 0)
746 {
747 puts("pg_recvlogical (PostgreSQL) " PG_VERSION);
748 exit(0);
749 }
750 }
751
752 while ((c = getopt_long(argc, argv, "E:f:F:ntvd:h:p:U:wWI:o:P:s:S:",
753 long_options, &option_index)) != -1)
754 {
755 switch (c)
756 {
757/* general options */
758 case 'f':
760 break;
761 case 'F':
762 if (!option_parse_int(optarg, "-F/--fsync-interval", 0,
763 INT_MAX / 1000,
765 exit(1);
766 fsync_interval *= 1000;
767 break;
768 case 'n':
769 noloop = 1;
770 break;
771 case 't':
772 two_phase = true;
773 break;
774 case 'v':
775 verbose++;
776 break;
777 case 5:
778 failover = true;
779 break;
780/* connection options */
781 case 'd':
783 break;
784 case 'h':
786 break;
787 case 'p':
789 break;
790 case 'U':
792 break;
793 case 'w':
794 dbgetpassword = -1;
795 break;
796 case 'W':
797 dbgetpassword = 1;
798 break;
799/* replication options */
800 case 'I':
801 if (sscanf(optarg, "%X/%08X", &hi, &lo) != 2)
802 pg_fatal("could not parse start position \"%s\"", optarg);
803 startpos = ((uint64) hi) << 32 | lo;
804 break;
805 case 'E':
806 if (sscanf(optarg, "%X/%08X", &hi, &lo) != 2)
807 pg_fatal("could not parse end position \"%s\"", optarg);
808 endpos = ((uint64) hi) << 32 | lo;
809 break;
810 case 'o':
811 {
812 char *data = pg_strdup(optarg);
813 char *val = strchr(data, '=');
814
815 if (val != NULL)
816 {
817 /* remove =; separate data from val */
818 *val = '\0';
819 val++;
820 }
821
822 noptions += 1;
823 options = pg_realloc(options, sizeof(char *) * noptions * 2);
824
825 options[(noptions - 1) * 2] = data;
826 options[(noptions - 1) * 2 + 1] = val;
827 }
828
829 break;
830 case 'P':
832 break;
833 case 's':
834 if (!option_parse_int(optarg, "-s/--status-interval", 0,
835 INT_MAX / 1000,
837 exit(1);
839 break;
840 case 'S':
842 break;
843/* action */
844 case 1:
845 do_create_slot = true;
846 break;
847 case 2:
848 do_start_slot = true;
849 break;
850 case 3:
851 do_drop_slot = true;
852 break;
853 case 4:
854 slot_exists_ok = true;
855 break;
856
857 default:
858 /* getopt_long already emitted a complaint */
859 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
860 exit(1);
861 }
862 }
863
864 /*
865 * Any non-option arguments?
866 */
867 if (optind < argc)
868 {
869 pg_log_error("too many command-line arguments (first is \"%s\")",
870 argv[optind]);
871 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
872 exit(1);
873 }
874
875 /*
876 * Required arguments
877 */
878 if (replication_slot == NULL)
879 {
880 pg_log_error("no slot specified");
881 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
882 exit(1);
883 }
884
885 if (do_start_slot && outfile == NULL)
886 {
887 pg_log_error("no target file specified");
888 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
889 exit(1);
890 }
891
892 if (!do_drop_slot && dbname == NULL)
893 {
894 pg_log_error("no database specified");
895 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
896 exit(1);
897 }
898
900 {
901 pg_log_error("at least one action needs to be specified");
902 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
903 exit(1);
904 }
905
907 {
908 pg_log_error("cannot use --create-slot or --start together with --drop-slot");
909 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
910 exit(1);
911 }
912
914 {
915 pg_log_error("cannot use --create-slot or --drop-slot together with --startpos");
916 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
917 exit(1);
918 }
919
921 {
922 pg_log_error("--endpos may only be specified with --start");
923 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
924 exit(1);
925 }
926
927 if (!do_create_slot)
928 {
929 if (two_phase)
930 {
931 pg_log_error("%s may only be specified with --create-slot", "--enable-two-phase");
932 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
933 exit(1);
934 }
935
936 if (failover)
937 {
938 pg_log_error("%s may only be specified with --create-slot", "--enable-failover");
939 pg_log_error_hint("Try \"%s --help\" for more information.", progname);
940 exit(1);
941 }
942 }
943
944 /*
945 * Obtain a connection to server. Notably, if we need a password, we want
946 * to collect it from the user immediately.
947 */
949 if (!conn)
950 /* Error message already written in GetConnection() */
951 exit(1);
953
954 /*
955 * Trap signals. (Don't do this until after the initial password prompt,
956 * if one is needed, in GetConnection.)
957 */
958#ifndef WIN32
962#endif
963
964 /*
965 * Run IDENTIFY_SYSTEM to check the connection type for each action.
966 * --create-slot and --start actions require a database-specific
967 * replication connection because they handle logical replication slots.
968 * --drop-slot can remove replication slots from any replication
969 * connection without this restriction.
970 */
971 if (!RunIdentifySystem(conn, NULL, NULL, NULL, &db_name))
972 exit(1);
973
974 if (!do_drop_slot && db_name == NULL)
975 pg_fatal("could not establish database-specific replication connection");
976
977 /*
978 * Set umask so that directories/files are created with the same
979 * permissions as directories/files in the source data directory.
980 *
981 * pg_mode_mask is set to owner-only by default and then updated in
982 * GetConnection() where we get the mode from the server-side with
983 * RetrieveDataDirCreatePerm() and then call SetDataDirectoryCreatePerm().
984 */
986
987 /* Drop a replication slot. */
988 if (do_drop_slot)
989 {
990 if (verbose)
991 pg_log_info("dropping replication slot \"%s\"", replication_slot);
992
994 exit(1);
995 }
996
997 /* Create a replication slot. */
998 if (do_create_slot)
999 {
1000 if (verbose)
1001 pg_log_info("creating replication slot \"%s\"", replication_slot);
1002
1004 false, false, slot_exists_ok, two_phase,
1005 failover))
1006 exit(1);
1008 }
1009
1010 if (!do_start_slot)
1011 exit(0);
1012
1013 /* Stream loop */
1014 while (true)
1015 {
1017 if (time_to_abort)
1018 {
1019 /*
1020 * We've been Ctrl-C'ed or reached an exit limit condition. That's
1021 * not an error, so exit without an errorcode.
1022 */
1023 exit(0);
1024 }
1025
1026 /*
1027 * Ensure all written data is flushed to disk before exiting or
1028 * starting a new replication.
1029 */
1030 if (outfd != -1)
1032
1033 if (noloop)
1034 {
1035 pg_fatal("disconnected");
1036 }
1037 else
1038 {
1039 /* translator: check source for value for %d */
1040 pg_log_info("disconnected; waiting %d seconds to try again",
1043 }
1044 }
1045}
1046
1047/*
1048 * Fsync our output data, and send a feedback message to the server. Returns
1049 * true if successful, false otherwise.
1050 *
1051 * If successful, *now is updated to the current timestamp just before sending
1052 * feedback.
1053 */
1054static bool
1056{
1057 /* flush data to disk, so that we send a recent flush pointer */
1058 OutputFsync(*now);
1060 if (!sendFeedback(conn, *now, true, false))
1061 return false;
1062
1063 return true;
1064}
1065
1066/*
1067 * Try to inform the server about our upcoming demise, but don't wait around or
1068 * retry on failure.
1069 */
1070static void
1072 XLogRecPtr lsn)
1073{
1075 (void) PQflush(conn);
1076
1077 if (verbose)
1078 {
1079 switch (reason)
1080 {
1081 case STREAM_STOP_SIGNAL:
1082 pg_log_info("received interrupt signal, exiting");
1083 break;
1085 pg_log_info("end position %X/%08X reached by keepalive",
1087 break;
1090 pg_log_info("end position %X/%08X reached by WAL record at %X/%08X",
1092 break;
1093 case STREAM_STOP_NONE:
1094 Assert(false);
1095 break;
1096 }
1097 }
1098}
Datum now(PG_FUNCTION_ARGS)
Definition timestamp.c:1609
#define Max(x, y)
Definition c.h:991
#define SIGNAL_ARGS
Definition c.h:1357
#define Assert(condition)
Definition c.h:873
#define PG_TEXTDOMAIN(domain)
Definition c.h:1203
int64_t int64
Definition c.h:543
#define PG_BINARY
Definition c.h:1281
uint64_t uint64
Definition c.h:547
uint32_t uint32
Definition c.h:546
void set_pglocale_pgservice(const char *argv0, const char *app)
Definition exec.c:430
int main(void)
int64 TimestampTz
Definition timestamp.h:39
#define _(x)
Definition elog.c:91
void PQfinish(PGconn *conn)
char * PQerrorMessage(const PGconn *conn)
int PQsocket(const PGconn *conn)
int PQflush(PGconn *conn)
Definition fe-exec.c:4017
void PQfreemem(void *ptr)
Definition fe-exec.c:4049
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 PQconsumeInput(PGconn *conn)
Definition fe-exec.c:2001
PGresult * PQexec(PGconn *conn, const char *query)
Definition fe-exec.c:2279
int PQgetCopyData(PGconn *conn, char **buffer, int async)
Definition fe-exec.c:2833
char * pg_strdup(const char *in)
Definition fe_memutils.c:85
void * pg_realloc(void *ptr, size_t size)
Definition fe_memutils.c:65
int pg_mode_mask
Definition file_perm.c:25
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
long val
Definition informix.c:689
#define close(a)
Definition win32.h:12
#define write(a, b, c)
Definition win32.h:14
int i
Definition isn.c:77
#define PQresultErrorMessage
#define PQgetResult
#define PQclear
#define PQresultStatus
@ PGRES_COPY_BOTH
Definition libpq-fe.h:137
@ PGRES_COMMAND_OK
Definition libpq-fe.h:125
@ PGRES_COPY_OUT
Definition libpq-fe.h:131
void pg_logging_init(const char *argv0)
Definition logging.c:83
#define pg_log_error(...)
Definition logging.h:106
#define pg_log_error_hint(...)
Definition logging.h:112
#define pg_log_info(...)
Definition logging.h:124
const char * progname
Definition main.c:44
bool option_parse_int(const char *optarg, const char *optname, int min_range, int max_range, int *result)
#define pg_fatal(...)
const void size_t len
const void * data
PGDLLIMPORT int optind
Definition getopt.c:51
PGDLLIMPORT char * optarg
Definition getopt.c:53
StreamStopReason
@ STREAM_STOP_KEEPALIVE
@ STREAM_STOP_END_OF_WAL
@ STREAM_STOP_NONE
@ STREAM_STOP_SIGNAL
static volatile sig_atomic_t stop_reason
static int verbose
static int noloop
static bool do_start_slot
static void sighup_handler(SIGNAL_ARGS)
static bool two_phase
static void StreamLogicalLog(void)
static bool output_needs_fsync
static XLogRecPtr endpos
static bool failover
static const char * plugin
static volatile sig_atomic_t time_to_abort
static bool slot_exists_ok
static int fsync_interval
static bool do_drop_slot
static bool output_isfile
static char * replication_slot
static bool flushAndSendFeedback(PGconn *conn, TimestampTz *now)
static XLogRecPtr output_written_lsn
static void sigexit_handler(SIGNAL_ARGS)
static int outfd
static TimestampTz output_last_fsync
static size_t noptions
static char * outfile
static XLogRecPtr output_fsync_lsn
static bool sendFeedback(PGconn *conn, TimestampTz now, bool force, bool replyRequested)
static void usage(void)
static void OutputFsync(TimestampTz now)
static XLogRecPtr startpos
#define RECONNECT_SLEEP_TIME
static bool do_create_slot
static void disconnect_atexit(void)
static void prepareToTerminate(PGconn *conn, XLogRecPtr endpos, StreamStopReason reason, XLogRecPtr lsn)
static int standby_message_timeout
static volatile sig_atomic_t output_reopen
static char ** options
#define pqsignal
Definition port.h:547
const char * get_progname(const char *argv0)
Definition path.c:652
#define printf(...)
Definition port.h:266
PQExpBuffer createPQExpBuffer(void)
Definition pqexpbuffer.c:72
void resetPQExpBuffer(PQExpBuffer str)
void appendPQExpBuffer(PQExpBuffer str, const char *fmt,...)
void destroyPQExpBuffer(PQExpBuffer str)
void appendPQExpBufferChar(PQExpBuffer str, char ch)
void appendPQExpBufferStr(PQExpBuffer str, const char *data)
char * c
static int fb(int x)
#define PqReplMsg_WALData
Definition protocol.h:77
#define PqReplMsg_Keepalive
Definition protocol.h:75
#define PqReplMsg_StandbyStatusUpdate
Definition protocol.h:84
void pg_usleep(long microsec)
Definition signal.c:53
static void error(void)
int dbgetpassword
Definition streamutil.c:50
PGconn * GetConnection(void)
Definition streamutil.c:60
char * dbhost
Definition streamutil.c:46
int64 fe_recvint64(char *buf)
Definition streamutil.c:868
TimestampTz feGetCurrentTimestamp(void)
Definition streamutil.c:803
char * dbport
Definition streamutil.c:48
void feTimestampDifference(TimestampTz start_time, TimestampTz stop_time, long *secs, int *microsecs)
Definition streamutil.c:822
void fe_sendint64(int64 i, char *buf)
Definition streamutil.c:857
bool feTimestampDifferenceExceeds(TimestampTz start_time, TimestampTz stop_time, int msec)
Definition streamutil.c:844
char * dbname
Definition streamutil.c:49
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
static StringInfo copybuf
Definition tablesync.c:127
static void CreateReplicationSlot(CreateReplicationSlotCmd *cmd)
Definition walsender.c:1194
static void DropReplicationSlot(DropReplicationSlotCmd *cmd)
Definition walsender.c:1406
#define fsync(fd)
Definition win32_port.h:83
#define SIGHUP
Definition win32_port.h:158
#define EINTR
Definition win32_port.h:361
#define S_IRUSR
Definition win32_port.h:279
#define fstat
Definition win32_port.h:73
#define S_ISREG(m)
Definition win32_port.h:318
#define S_IWUSR
Definition win32_port.h:282
#define select(n, r, w, e, timeout)
Definition win32_port.h:500
#define XLogRecPtrIsValid(r)
Definition xlogdefs.h:29
#define LSN_FORMAT_ARGS(lsn)
Definition xlogdefs.h:47
uint64 XLogRecPtr
Definition xlogdefs.h:21
#define InvalidXLogRecPtr
Definition xlogdefs.h:28