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

ALTER SUBSCRIPTION

Function

This syntax modifies the attributes of a subscription.

This syntax has been deprecated in clusters of version 9.1.1.100 or later. An error "SUBSCRIPTION is not yet supported" will be reported when executed.

Precautions

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'

Alters the connection attributes initially set by CREATE SUBSCRIPTION.

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

publication_name

Specifies the name of a new publication.

A string, which must comply with the identifier naming conventions.

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 parameters, 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, which must comply with the identifier naming conventions.

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, DROP SUBSCRIPTION

Parent Topic: Publications and Subscriptions