Help Center/ Data Warehouse Service/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ Publications and Subscriptions/ ALTER SUBSCRIPTION
Updated on 2026-07-02 GMT+08:00
View PDF
Share

ALTER SUBSCRIPTION

Function

ALTER SUBSCRIPTION modifies subscription attributes.

Precautions

  • This statement is supported by version 8.2.0.100 or later clusters.
  • Only the owner of a subscription can execute ALTER SUBSCRIPTION, and the new owner must be a system administrator.

Syntax

  • Update the connection information of a subscription. 
    1
    		 
    ALTER SUBSCRIPTION name CONNECTION 'conninfo';
  • Update the name of the publication on the publisher side. 
    1
    		 
    ALTER SUBSCRIPTION name SET PUBLICATION publication_name [, ...];

  • Enable a subscription.

    1
    		 
    ALTER SUBSCRIPTION name ENABLE;

  • Disable a subscription.

    1
    		 
    ALTER SUBSCRIPTION name DISABLE;
  • Set subscription parameters. 
    1
    		 
    ALTER SUBSCRIPTION name SET ( subscription_parameter [= value] [, ... ] );
  • Change the subscription owner. 
    1
    		 
    ALTER SUBSCRIPTION name OWNER TO new_owner;
  • Rename the subscription. 
    1
    		 
    ALTER SUBSCRIPTION name RENAME TO new_name;

Parameter Description

Table 1 ALTER SUBSCRIPTION parameters

Parameter

Description

Value Range

name

Specifies the name of the subscription to be modified.

Name of an existing subscription.

CONNECTION 'conninfo'

Modifies the parameter attributes set by CREATE SUBSCRIPTION for connecting to the publisher database.

For details about the parameters, see Parameter Description in CREATE SUBSCRIPTION.

publication_name

Specifies the name of a new publication.

A string compliant with the identifier naming rules.

ENABLE

Enables a previously disabled subscription and starts logical replication at the end of a transaction.

-

DISABLE

Disables a running subscription and stops logical replication at the end of a transaction.

-

SET ( publication_parameter [= value] [, ... ] )

Modifies the publication parameters initially set by CREATE PUBLICATION.

For details about the parameter, see Parameter Description in CREATE SUBSCRIPTION.

new_owner

Specifies the name new subscription owner.

Name of an existing user.

new_name

Specifies the new name of the subscription.

A string compliant with the identifier naming rules.

Examples

  • Create the subscription sub_demo. 
    DROP SUBSCRIPTION IF EXISTS sub_demo;
CREATE SUBSCRIPTION sub_demo
    CONNECTION 'host=10.***.*.** port=10000 user=u_admin dbname=testdb password=********'
    PUBLICATION pub_sales_only;
  • Change the publication of the subscription to insert_only. 
    1
    		 
    ALTER SUBSCRIPTION sub_demo SET PUBLICATION insert_only;
  • Rename the subscription. 
    1
    		 
    ALTER SUBSCRIPTION sub_demo RENAME TO new_sub_demo;
  • Disable the subscription. 
    ALTER SUBSCRIPTION new_sub_demo DISABLE;

Helpful Links

CREATE SUBSCRIPTION and DROP SUBSCRIPTION

Checking the Subscription Information in the Database

You can use the PG_SUBSCRIPTION system catalog provided by DWS to check the subscription information created in the current database, including the subscription name, owner, and parameter settings.

Parent Topic: Publications and Subscriptions