Help Center/ Data Warehouse Service / SQL Syntax Reference/ SQL Syntax Reference (9.1.1.x)/ DDL Syntax/ ALTER SUBSCRIPTION
Updated on 2025-10-10 GMT+08:00
View PDF
Share

ALTER SUBSCRIPTION

Function

This syntax modifies the attributes of a subscription.

This syntax has been discarded in clusters of version 9.1.1.100 or later. If this syntax is executed, the error message "SUBSCRIPTION is not yet supported" will be displayed.

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

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

Parent Topic: DDL Syntax