Help Center/ Data Warehouse Service / More Documents/ SQL Syntax Reference (Kuala Lumpur Region)/ DDL Syntax/ ALTER SUBSCRIPTION
Updated on 2025-10-11 GMT+08:00
View PDF
Share

ALTER SUBSCRIPTION

Function

This syntax modifies the attributes of a subscription.

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'

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 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 parameters, see the Parameter Description part 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

Modify subscription connection information. 
ALTER SUBSCRIPTION mysub CONNECTION 'host=192.168.1.51 port=5432 user=foo dbname=foodb password=xxxx';

Helpful Links

CREATE SUBSCRIPTION and DROP SUBSCRIPTION

Parent Topic: DDL Syntax