Printing publication database details (printpubdbidsdetails) v7

Suggest edits

The printpubdbidsdetails command displays the connection information for each publication database definition.

Synopsis

-printpubdbidsdetails –repsvrfile pubsvrfile

The output has the following components:

dbid:host:port:dbname:user

Note

The database user’s password isn't displayed.

Parameters

pubsvrfile

The file containing the publication server login information.

dbid

The publication database ID assigned to the publication database definition.

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.

dbname

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

user

The publication database user name.

Examples

Four publication database definitions are subordinate to the publication server identified by the content of file pubsvrfile.prop.

$ java -jar edb-repcli.jar -printpubdbidsdetails \
>   -repsvrfile ~/pubsvrfile.prop
Printing publication database ids with details...
id:host:port:database|sid:user
2:192.168.2.7:5444:edb:pubuser
1:192.168.2.6:1521:xe:pubuser
24:192.168.2.7:5444:MMRnode:MMRuser
3:192.168.2.6:5444:edb:pubuser
← Prev

Printing publication database IDs (printpubdbids)

Next →

Printing the controller database ID (printcontrollerdbid)