Snowshoe logo
all-things-risingwave

Can the application name in the replication PID of a PostgreSQL connector be customized?

When looking at the replication PID in pg_stat_activity for a PostgreSQL connector, the application name is currently set to Debezium Streaming. Is it possible to customize this to be RisingWave or My RisingWave cluster number 3 for better identification purposes?

Ri

Rick Otten

Asked on Feb 28, 2024

  • The application name in the replication PID of a PostgreSQL connector is hardcoded in the Debezium Postgres connector.
  • Customizing the application name directly in the connector is not supported.
  • One alternative approach is to create a dedicated PostgreSQL user with a more descriptive name for better identification purposes.

Example:

public class PostgresConnection extends JdbcConnection {

    public static final String CONNECTION_STREAMING = "Debezium Streaming";
    public static final String CONNECTION_SLOT_INFO = "Debezium Slot Info";
    public static final String CONNECTION_DROP_SLOT = "Debezium Drop Slot";
    public static final String CONNECTION_VALIDATE_CONNECTION = "Debezium Validate Connection";
    public static final String CONNECTION_HEARTBEAT = "Debezium Heartbeat";
    public static final String CONNECTION_GENERAL = "Debezium General";
Feb 29, 2024Edited by