Registering a publication server v7

When you register a publication server, you're identifying the network location, admin user name, and password of a specific, running, publication server instance. You want to use this instance to manage all aspects of the publications you create subordinate to it.

It's important that you record the login information for the publication server. You must always use this same publication server instance to manage all publications created subordinate to it as represented in the Replication Server console replication tree.

  1. Start the publication server if it's not already running.


    If you're using Oracle publication or subscription databases, and the publication server wasn't restarted since copying the Oracle JDBC driver to the lib/jdbc subdirectory of your Replication Server installation, restart the publication server.

    For Linux only: You can verify the publication server is running by using the systemctl command for RHEL/Rocky Linux/AlmaLinux 8.x or later, and the service command for previous Linux versions.

    Use the following command for Rocky Linux 8 or AlmaLinux 8 or RHEL 8:

    systemctl status edb-xdbpubserver

    For previous Linux versions:

    service edb-xdbpubserver status

    If the publication server is running and you want to restart it, use the restart option.

    For RHEL/Rocky Linux/AlmaLinux 8.x or later:

    systemctl restart edb-xdbpubserver

    For previous Linux versions:

    service edb-xdbpubserver restart

    If the publication server isn't running, use the start option.

    For RHEL/Rocky Linux/AlmaLinux 8.x or later:

    systemctl start edb-xdbpubserver

    For previous Linux versions:

    service edb-xdbpubserver start

    Similarly, use the stop option to stop the publication server.

    For Windows only: Open Control Panel > System and Security > Administrative Tools > Services. The publication server runs as a service named Publication Service for Replication Server. Use the Start or Restart link for the service.

    If the publication server doesn't start, see Publication and subscription server startup failures.

  2. Register the publication server. Open the Replication Server console from the system’s application menu. For Replication Server installed from an Replication Server RPM package, invoke the script XDB_HOME/bin/ to start the Replication Server console.

  3. Select the top-level Replication Servers node. Select File > Publication Server > Register Server.

    In the Register Publication Server dialog box, enter the values you supplied while installing Replication Server unless otherwise specified.

    • Host. Network IP address of the host running the publication server. This is the network IP address used for pub_ipaddr in the pg_hba.conf file in Postgres server authentication. (Don't use localhost for this field.)
    • Port. Port number the publication server is using. You can find the port number in the xdbReplicationServer-xx.config file. See Installation details for the location of the file.
    • User Name. Admin user name used to authenticate your use of this publication server. You can find the user name in the edb-repl.conf file. See Installation details for the location of the file.
    • Password. Password of the admin user given in the User Name field.
    • Save login information. Select this box if you don't want to register the publication server each time you open the Replication Server console. See Saving server login information for additional information on the advantages and disadvantages of saving server login information.

    The user name and password combination you enter is authenticated against the admin user name and password in the Replication Server configuration file residing on the host with the IP address you enter in the Host field.

    After you fill in the fields, select Register. A Publication Server node appears in the replication tree of the Replication Server console. Expand the Publication Server node to expose the SMR and MMR type nodes.

    Continue to build the single-master replication system under the SMR type node.