PostgreSQL Source Code  git master
pg_subscription.h
Go to the documentation of this file.
1 /* -------------------------------------------------------------------------
2  *
3  * pg_subscription.h
4  * definition of the "subscription" system catalog (pg_subscription)
5  *
6  * Portions Copyright (c) 1996-2022, PostgreSQL Global Development Group
7  * Portions Copyright (c) 1994, Regents of the University of California
8  *
9  * src/include/catalog/pg_subscription.h
10  *
11  * NOTES
12  * The Catalog.pm module reads this file and derives schema
13  * information.
14  *
15  * -------------------------------------------------------------------------
16  */
17 #ifndef PG_SUBSCRIPTION_H
18 #define PG_SUBSCRIPTION_H
19 
20 #include "access/xlogdefs.h"
21 #include "catalog/genbki.h"
22 #include "catalog/pg_subscription_d.h"
23 
24 #include "nodes/pg_list.h"
25 
26 /*
27  * two_phase tri-state values. See comments atop worker.c to know more about
28  * these states.
29  */
30 #define LOGICALREP_TWOPHASE_STATE_DISABLED 'd'
31 #define LOGICALREP_TWOPHASE_STATE_PENDING 'p'
32 #define LOGICALREP_TWOPHASE_STATE_ENABLED 'e'
33 
34 /* ----------------
35  * pg_subscription definition. cpp turns this into
36  * typedef struct FormData_pg_subscription
37  * ----------------
38  */
39 
40 /*
41  * Technically, the subscriptions live inside the database, so a shared catalog
42  * seems weird, but the replication launcher process needs to access all of
43  * them to be able to start the workers, so we have to put them in a shared,
44  * nailed catalog.
45  *
46  * CAUTION: There is a GRANT in system_views.sql to grant public select
47  * access on all columns except subconninfo. When you add a new column
48  * here, be sure to update that (or, if the new column is not to be publicly
49  * readable, update associated comments and catalogs.sgml instead).
50  */
51 CATALOG(pg_subscription,6100,SubscriptionRelationId) BKI_SHARED_RELATION BKI_ROWTYPE_OID(6101,SubscriptionRelation_Rowtype_Id) BKI_SCHEMA_MACRO
52 {
53  Oid oid; /* oid */
54 
55  Oid subdbid BKI_LOOKUP(pg_database); /* Database the
56  * subscription is in. */
57 
58  XLogRecPtr subskiplsn; /* All changes finished at this LSN are
59  * skipped */
60 
61  NameData subname; /* Name of the subscription */
62 
63  Oid subowner BKI_LOOKUP(pg_authid); /* Owner of the subscription */
64 
65  bool subenabled; /* True if the subscription is enabled (the
66  * worker should be running) */
67 
68  bool subbinary; /* True if the subscription wants the
69  * publisher to send data in binary */
70 
71  bool substream; /* Stream in-progress transactions. */
72 
73  char subtwophasestate; /* Stream two-phase transactions */
74 
75  bool subdisableonerr; /* True if a worker error should cause the
76  * subscription to be disabled */
77 
78 #ifdef CATALOG_VARLEN /* variable-length fields start here */
79  /* Connection string to the publisher */
80  text subconninfo BKI_FORCE_NOT_NULL;
81 
82  /* Slot name on publisher */
83  NameData subslotname BKI_FORCE_NULL;
84 
85  /* Synchronous commit setting for worker */
86  text subsynccommit BKI_FORCE_NOT_NULL;
87 
88  /* List of publications subscribed to */
89  text subpublications[1] BKI_FORCE_NOT_NULL;
90 #endif
92 
94 
95 DECLARE_TOAST_WITH_MACRO(pg_subscription, 4183, 4184, PgSubscriptionToastTable, PgSubscriptionToastIndex);
96 
97 DECLARE_UNIQUE_INDEX_PKEY(pg_subscription_oid_index, 6114, SubscriptionObjectIndexId, on pg_subscription using btree(oid oid_ops));
98 DECLARE_UNIQUE_INDEX(pg_subscription_subname_index, 6115, SubscriptionNameIndexId, on pg_subscription using btree(subdbid oid_ops, subname name_ops));
99 
100 typedef struct Subscription
101 {
102  Oid oid; /* Oid of the subscription */
103  Oid dbid; /* Oid of the database which subscription is
104  * in */
105  XLogRecPtr skiplsn; /* All changes finished at this LSN are
106  * skipped */
107  char *name; /* Name of the subscription */
108  Oid owner; /* Oid of the subscription owner */
109  bool enabled; /* Indicates if the subscription is enabled */
110  bool binary; /* Indicates if the subscription wants data in
111  * binary format */
112  bool stream; /* Allow streaming in-progress transactions. */
113  char twophasestate; /* Allow streaming two-phase transactions */
114  bool disableonerr; /* Indicates if the subscription should be
115  * automatically disabled if a worker error
116  * occurs */
117  char *conninfo; /* Connection string to the publisher */
118  char *slotname; /* Name of the replication slot */
119  char *synccommit; /* Synchronous commit setting for worker */
120  List *publications; /* List of publication names to subscribe to */
122 
123 extern Subscription *GetSubscription(Oid subid, bool missing_ok);
124 extern void FreeSubscription(Subscription *sub);
125 extern void DisableSubscription(Oid subid);
126 extern Oid get_subscription_oid(const char *subname, bool missing_ok);
127 extern char *get_subscription_name(Oid subid, bool missing_ok);
128 
129 extern int CountDBSubscriptions(Oid dbid);
130 
131 #endif /* PG_SUBSCRIPTION_H */
#define BKI_FORCE_NOT_NULL
Definition: genbki.h:33
#define BKI_FORCE_NULL
Definition: genbki.h:32
#define BKI_SHARED_RELATION
Definition: genbki.h:27
#define BKI_ROWTYPE_OID(oid, oidmacro)
Definition: genbki.h:28
bool subdisableonerr
CATALOG(pg_subscription, 6100, SubscriptionRelationId) BKI_SHARED_RELATION BKI_ROWTYPE_OID(6101
int CountDBSubscriptions(Oid dbid)
bool subenabled
char subtwophasestate
DECLARE_TOAST_WITH_MACRO(pg_subscription, 4183, 4184, PgSubscriptionToastTable, PgSubscriptionToastIndex)
void FreeSubscription(Subscription *sub)
void DisableSubscription(Oid subid)
NameData subname
Subscription * GetSubscription(Oid subid, bool missing_ok)
XLogRecPtr subskiplsn
FormData_pg_subscription
Oid get_subscription_oid(const char *subname, bool missing_ok)
bool subbinary
struct Subscription Subscription
DECLARE_UNIQUE_INDEX_PKEY(pg_subscription_oid_index, 6114, SubscriptionObjectIndexId, on pg_subscription using btree(oid oid_ops))
DECLARE_UNIQUE_INDEX(pg_subscription_subname_index, 6115, SubscriptionNameIndexId, on pg_subscription using btree(subdbid oid_ops, subname name_ops))
Oid subdbid BKI_LOOKUP(pg_database)
char * get_subscription_name(Oid subid, bool missing_ok)
FormData_pg_subscription * Form_pg_subscription
bool substream
SubscriptionRelation_Rowtype_Id BKI_SCHEMA_MACRO
unsigned int Oid
Definition: postgres_ext.h:31
Definition: pg_list.h:51
XLogRecPtr skiplsn
Definition: c.h:676
Definition: c.h:622
uint64 XLogRecPtr
Definition: xlogdefs.h:21