Create Config for PostgreSQL
Use the create config command to create a new configuration file. This command runs the SharePlex default text editor and opens a new file. To create a configuration, follow the instructions in Chapter 5 of the SharePlex Administrator’s Guide.
If you attempt to give a new configuration the same name as an existing configuration, SharePlex returns this error message “The parameter for create config must be a new filename.”
As an alternative to creating a configuration, you can use the copy config command to duplicate an existing configuration and then use the edit config command to edit the copy.
Usage
| Supported source: |
PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Supported targets: |
PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Authorization level: |
Operator (2) |
| Issues on: |
source system |
| Related commands: |
activate config, copy config |
Syntax
Syntax description
| filename |
The name of the configuration that you want to create. Configuration names are case-sensitive. The name must be unique among configurations on the system.
Example:
sp_ctrl(sysA>create config sales |
Deactivate config for PostgreSQL
Use the deactivate config command to gracefully terminate replication for an active configuration. This command stops all Capture activity for the configuration, posts all data currently in the queues, removes the associated SharePlex processes and queues, and drops replication slots (physical/logical).
The deactivate config command does not remove a configuration from the system, but only stops replication of its objects until you activate it again. When you deactivate a configuration, it can cause the target data to go out of synchronization if users continue making changes to the configured source objects. Deactivating one configuration on a system does not deactivate other active configurations on the same system.
Note: In SharePlex 11.1, physical or logical slots created at activation will get dropped from the database after successful deactivation.
Usage
| Supported sources: |
PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Supported targets: |
PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Authorization level: |
Administrator (1) |
| Issues on: |
source system |
| Related commands: |
list config |
Syntax
| deactivate config filename |
Syntax description
| filename |
The name of the configuration that you want to deactivate. Configuration names are case-sensitive.
Example:
sp_ctrl(sysA)>deactivate config sales |
Drop Partition for PostgreSQL
Use the drop partition command to remove a row partition from a partition scheme in a horizontally partitioned replication configuration. Issue a drop partition command for each row partition that you want to remove.
Reactivate the configuration file if the command affects a table that is already being replicated. SharePlex will only lock tables for which there are configuration changes.
For more information about how to configure horizontally partitioned replication, see the SharePlex Administration Guide.
Usage
| Supported source: |
PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Supported targets: |
PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Issues on: |
source system |
| Related commands: |
add partition, modify partition, drop partition scheme, view partitions |
Syntax
|
drop partition from scheme_name
where
{
{condition =column_condition
route = routing_map |
name = partition_name |
tablename = target_table |
description = description
} |
Syntax Description
| scheme_name |
The name of the partition scheme. |
| condition |
Column condition that defines the rows of the partition that you want to remove. |
| route |
The routing map of the partition that you want to remove. |
| tablename |
The fully qualified name of the target table in the partition that you want to remove. |
| name |
The short name of the partition that you want to remove. |
| description |
The description of the partition that you want to remove. |
Examples
sp_ctrl> drop partition from scheme1 where name = q1
sp_ctrl> drop partition from scheme1 where condition = "C1 < 200"
sp_ctrl> drop partition from scheme1 where route = sysb:q2@r.dbname
Drop Partition Scheme command for PostgreSQL
Use the drop partition scheme command to remove a partition scheme from the SharePlex replication configuration. This command also removes all of the row partitions that are specified for the partition scheme.
Reactivate the configuration file if the command affects a table that is already being replicated. SharePlex will only lock tables for which there are configuration changes.
For more information about how to configure horizontally partitioned replication, see the SharePlex Administration Guide.
Usage
| Supported source: |
PostgreSQL (on-prem), Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Supported targets: |
PostgreSQL, Oracle, SQL Server, Kafka, Amazon RDS for PostgreSQL, Amazon Aurora for PostgreSQL, Azure Database for PostgreSQL Flexible Server, and Google Cloud SQL for PostgreSQL |
| Issues on: |
source system |
| Related commands: |
add partition, modify partition, drop partition, view partitions |
Syntax
|
drop partition scheme scheme_name |
Syntax Description
| scheme_name |
The name of the partition scheme. |
Example
sp_ctrl> drop partition scheme sales
