Postgres Plus xDB Replication Server with Multi-Master User's Guide : 3.1 Installing With Stack Builder or StackBuilder Plus
Postgres Plus Advanced Server xDB Replication Server User's Guide
3.1 Installing With Stack Builder or StackBuilder Plus
Stack Builder and StackBuilder Plus are programs used to download and install add-on products and updates to PostgreSQL and Postgres Plus Advanced Server. Stack Builder is used for PostgreSQL. StackBuilder Plus is used for Postgres Plus Advanced Server.
Stack Builder and StackBuilder Plus are very similar in functionality and look-and-feel, differing primarily in the list of products offered.
This section demonstrates the installation of xDB Replication Server using StackBuilder Plus for Advanced Server. Steps are noted where the installation process differs for installation on PostgreSQL using Stack Builder.
Step 1 (For PostgreSQL only): You must have Java runtime version 1.6 or later installed on the hosts where you intend to install any xDB Replication Server component (xDB Replication Console, publication server, or subscription server). Any Java product such as Oracle Java or OpenJDK may be used.
Follow the directions for your host operating system to install Java runtime.
(For Advanced Server, a Java runtime is supplied and installed as part of the Advanced Server installation process.)
Step 2: From the host’s application menu, open the Postgres menu and choose Stack Builder or StackBuilder Plus.
Figure 24 - Postgres application menu
Step 3 (For Linux only): Depending upon your Linux host, a dialog box or a prompt appears requesting the root account’s password. Enter the root password and click the OK button.
Figure 25 - Enter root account password
Step 4: The StackBuilder Plus welcome screen appears. Select your Postgres installation from the drop-down list and click the Next button.
Figure 26 - StackBuilder Plus welcome screen
Step 5 (For Advanced Server): Expand the Replication Solutions node and check the box for xDB Replication Server. Click the Next button.
Figure 27 - StackBuilder Plus applications
Step 5 (For PostgreSQL): Expand the Registration-Required and Trial Products node, and then expand the Solution Pack node. Check the box for xDB Replication Server under the Solution Pack list and click the Next button.
Figure 28 - Stack Builder applications
Figure 29 - Solution Pack for PostgreSQL
Step 6 (For Advanced Server only): In the Account Registration screen, either enter your email address and password for your EnterpriseDB user account if you have one, or click the link in which case you will be directed to the registration page of the EnterpriseDB website where you can create an account. Click the Next button.
Note (For PostgreSQL only): Proceed to Step 7. If you are using PostgreSQL, account registration occurs later in the process.
Figure 30 - EnterpriseDB account registration
Step 7: Verify that xDB Replication Server appears in the list of selected packages. Click the Next button.
Figure 31 - Selected packages
An information box appears showing the download progress of the xDB Replication Server package. This may take a few minutes.
Figure 32 - Downloading progress
Step 8: When downloading of the xDB Replication Server package completes, the following screen appears that starts the installation of xDB Replication Server. Click the Next button.
Note: You can check the Skip Installation box if you wish to install xDB Replication Server some other time.
Figure 33 – Start installation
Step 9: Select the installation language and click the OK button.
Figure 34 - Installation language
Step 10: In the Setup xDB Replication Server screen, click the Next button.
Figure 35 – Setup xDB Replication Server
Step 11: Read the license agreement. If you accept the agreement, select the accept radio button and click the Next button.
Figure 36 - License agreement
Step 12: Browse to a directory where you want the xDB Replication Server components installed, or allow it to install the components in the default location shown. Click the Next button.
Figure 37 - Installation directory
Step 13: If you do not want a particular xDB Replication Server component installed on this particular host, uncheck the box next to the component name. Click the Next button.
Figure 38 - Select components
Step 14 (For PostgreSQL only): In the Account Registration screen select the radio button that applies to you. Click the Next button.
Note (For Advanced Server only): Proceed to Step 15.
Figure 39 - Account registration
If you do not have an EnterpriseDB user account, you will be directed to the registration page of the EnterpriseDB website.
If you already have an EnterpriseDB user account, enter the email address and password for your EnterpriseDB user account as shown in the following screen. Click the Next button.
Figure 40 - My EnterpriseDB account
Step 15: Enter the Postgres database connection information for the database server in which the xDB Control database is to run.
Note: From this point on, it is suggested that you record the values you enter on these screens as they will be needed during the publication and subscription server registration process.
Enter values for the following fields:
● Host. Network address of the Postgres database server that is to host the xDB Control database. (localhost is acceptable if the xDB Control database is to reside on the same machine where you are running this installation process.)
● Port. Port number on which the Postgres database server is listening for connections.
● User Name. The database superuser name to authenticate connections to the xDB Control database by the publication server or subscription server running on this host. You must also use this superuser name and password when you register a publication server or a subscription server running on this host. Default superuser is postgres (enterprisedb for Advanced Server installed in Oracle compatible configuration mode).
● Password. Password of the database user given in the User Name field.
● Control Database. The database name of the xDB Control database. If the database does not already exist, it will be created. Default database name is postgres (edb for Advanced Server installed in Oracle compatible configuration mode).
Figure 41 - xDB Control database information
Note: The database specified as the xDB Control database cannot be used as a publication database or a master node in a replication system. Therefore it is suggested to choose a database name other than the given default.
Note: For purposes of this example, xdb is chosen as the xDB Control database name.
Note: The information that you enter on this screen is saved to the xDB Replication Configuration file named /etc/edb-repl.conf (XDB_HOME\etc\edb-repl.conf on Windows hosts). Whenever a publication server or subscription server on this host is started, it obtains the connection information to the xDB Control database from this file.
After you have completed the Postgres Installation Details screen, click the Next button.
Step 16 (Only if publication server is a selected component): Enter an available port on which the publication server will run. Default port number is 9051. Click the Next button.
Figure 42 - Publication server details
Step 17 (Only if subscription server is a selected component): Enter an available port on which the subscription server will run. Default port number is 9052. Click the Next button.
Figure 43 - Subscription server details
Step 18: For the operating system account under which the publication server or subscription server is to run, enter postgres (enterprisedb if you are using Advanced Server installed in Oracle compatible configuration mode).
Figure 44 - Publication/subscription server operating system account
Step 19: On the Ready to Install screen, click the Next button.
Figure 45 - Ready to install
An information box appears showing the installation progress of the xDB Replication Server selected components. This may take a few minutes.
Figure 46 - Installation progress
Step 20: When installation has completed the following screen appears. Click the Finish button.
Figure 47 – xDB Replication Server installation completion
Step 21: On the StackBuilder Plus Installation Complete screen, click the Finish button.
Figure 48 - StackBuilder Plus installation complete
Successful installation of xDB Replication Server affects your host environment as described in Section 3.2.