From fb2ea12f42b9453853be043b8ed107e136e1ccb7 Mon Sep 17 00:00:00 2001 From: Amit Kapila Date: Fri, 28 Mar 2025 12:26:39 +0530 Subject: pg_createsubscriber: Add '--all' option. The '--all' option indicates that the tool queries the source server (publisher) for all databases and creates subscriptions on the target server (subscriber) for databases with matching names. Without this user needs to explicitly specify all databases by using -d option for each database. This simplifies converting a physical standby to a logical subscriber, particularly during upgrades. The options '--database', '--publication', '--subscription', and '--replication-slot' cannot be used when '--all' is specified. Author: Shubham Khanna Reviewed-by: vignesh C Reviewed-by: Ashutosh Bapat Reviewed-by: Euler Taveira Reviewed-by: Hayato Kuroda Reviewed-by: Amit Kapila Reviewed-by: Peter Smith Reviewed-by: Shlok Kyal Discussion: https://postgr.es/m/CAHv8RjKhA=_h5vAbozzJ1Opnv=KXYQHQ-fJyaMfqfRqPpnC2bA@mail.gmail.com --- doc/src/sgml/ref/pg_createsubscriber.sgml | 37 +++++++++++++++++++++++++------ 1 file changed, 30 insertions(+), 7 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/pg_createsubscriber.sgml b/doc/src/sgml/ref/pg_createsubscriber.sgml index d011b79e5e6..1f0ddd7f9f2 100644 --- a/doc/src/sgml/ref/pg_createsubscriber.sgml +++ b/doc/src/sgml/ref/pg_createsubscriber.sgml @@ -87,6 +87,24 @@ PostgreSQL documentation command-line arguments: + + + + + + Create one subscription per database on the target server. Exceptions + are template databases and databases that don't allow connections. + If the database name is not specified in publisher-server, the postgres + database will be used, or if that does not exist, template1 will be used. + Automatically generated names for subscriptions, publications, and + replication slots are used when this option is specified. + This option cannot be used along with , + , , or + . + + + + @@ -94,10 +112,12 @@ PostgreSQL documentation The name of the database in which to create a subscription. Multiple databases can be selected by writing multiple - switches. If option is not provided, the database - name will be obtained from option. If the database - name is not specified in either the option or - option, an error will be reported. + switches. This option cannot be used together with . + If option is not provided, the database name will be + obtained from option. If the database name is not + specified in either the option, or the + option, and option is not + specified, an error will be reported. @@ -253,7 +273,8 @@ PostgreSQL documentation names must match the number of specified databases, otherwise an error is reported. The order of the multiple publication name switches must match the order of database switches. If this option is not specified, - a generated name is assigned to the publication name. + a generated name is assigned to the publication name. This option cannot + be used together with . @@ -269,7 +290,8 @@ PostgreSQL documentation otherwise an error is reported. The order of the multiple replication slot name switches must match the order of database switches. If this option is not specified, the subscription name is assigned to the - replication slot name. + replication slot name. This option cannot be used together with + . @@ -284,7 +306,8 @@ PostgreSQL documentation names must match the number of specified databases, otherwise an error is reported. The order of the multiple subscription name switches must match the order of database switches. If this option is not specified, - a generated name is assigned to the subscription name. + a generated name is assigned to the subscription name. This option cannot + be used together with . -- cgit v1.2.3