Updating a publication database (updatepubdb) v7

Suggest edits

The updatepubdb command lets you change the connection information for an existing publication database definition identified by its publication database ID.

Synopsis

-updatepubdb
  -repsvrfile pubsvrfile
  -pubdbid dbid
  -dbhost host
  -dbport port
  -dbuser user
{ -dbpassword encrypted_pwd | -dbpassfile pwdfile }
[ -oraconnectiontype { sid | servicename } ]
  -database dbname
[ -urloptions jdbc_url_parameters ]
[ -nodepriority priority_level ]

Identify the publication database definition to update with the pubdbid parameter.

See Adding a publication database for details on the database connection information to supply for a publication database definition for a single-master replication system. See Adding the primary definition node and Creating more primary nodes for a multi-master replication system.

Parameters

pubsvrfile

The file containing the publication server login information.

dbid

The publication database ID of the publication database definition to update.

host

The IP address of the host where the publication database server is running.

port

The port number on which the database server is listening for connections.

user

The publication database user name.

encrypted_pwd

The encrypted password of the database user. See Encrypting passwords to learn how to use the encrypt command to generate an encrypted password.

pwdfile

The file containing the password of the database user in encrypted form.

-oraconnectiontype

Specify sid to use the Oracle system ID (SID) to identify the publication database in the database parameter. Specify servicename to use the Oracle service name to identify the publication database in the database parameter.

Note

For Oracle 12c, use the service name.

dbname

The Postgres or SQL Server database name, the Oracle SID, or the Oracle service name of the publication database.

jdbc_url_parameters

Extended usage of JDBC URL parameters such as for support of SSL connectivity. See Preparing using secure sockets layer (SSL) connections for information on SSL connectivity to the publication database. Specifying the urloptions parameter completely replaces any existing JDBC URL parameters that were previously specified with this database. Omitting the urloptions parameter deletes any existing JDBC URL parameters that were previously specified with this database.

priority_level

For MMR only: Integer value from 1 through 10 assigning the priority level to a primary node. 1 has the highest priority, and 10 has the lowest priority.

Examples

This example updates an existing publication database definition with publication database ID 1.

$ java -jar edb-repcli.jar -updatepubdb -repsvrfile ~/pubsvrfile.prop \
>   -pubdbid 1 \
>   -dbhost 192.168.2.6 -dbport 1521 \
>   -dbuser pubuser -dbpassfile ~/pwdfile \
>   -oraconnectiontype sid \
>   -database xe
Updating publication database ...
Publication database with ID 1 is updated successfully.
← Prev

Printing the primary definition node database ID (printpdndbid)

Next →

Removing a publication database (removepubdb)