4.8.2. Install PostgreSQL Applier

4.8.2. Install PostgreSQL Applier
Prev	^Up	4.8. Deploying the PostgreSQL Applier	Next

4.8.2. Install PostgreSQL Applier

Once you have completed the configuration of the PostgreSQL database, you can configure and install the PostgreSQL applier as described using the steps below.

Unpack the Tungsten Replicator distribution in staging directory:
copy
```
shell> tar zxf tungsten-replicator-7.0.3-141.tar.gz
```
Change into the staging directory:
copy
```
shell> cd tungsten-replicator-7.0.3-141
```
Configure the installation using tpm:
Show Staging
Show INI
copy
```
shell> ./tools/tpm configure defaults \
    --reset \
    --install-directory=/opt/continuent \
    --user=tungsten \
    --profile-script=~/.bash_profile \
    --rest-api-admin-user=apiuser \
    --rest-api-admin-pass=secret

shell> ./tools/tpm configure alpha \
    --master=sourcehost \
    --members=localhost,sourcehost \
    --datasource-type=postgresql \
    --postgresql-dbname=dbname \
    --replication-user=tungsten \
    --replication-password=secret \
    --replication-host=remotedbhost \
    --replication-port=5432
```
copy
```
shell> vi /etc/tungsten/tungsten.ini
```
copy
```
[defaults]
install-directory=/opt/continuent
user=tungsten
profile-script=~/.bash_profile
rest-api-admin-user=apiuser
rest-api-admin-pass=secret

[alpha]
master=sourcehost
members=localhost,sourcehost
datasource-type=postgresql
postgresql-dbname=dbname
replication-user=tungsten
replication-password=secret
replication-host=remotedbhost
replication-port=5432
```
Configuration group defaults
The description of each of the options is shown below; click the icon to hide this detail:
Click the icon to show a detailed description of each argument.
- --reset
  reset
  For staging configurations, deletes all pre-existing configuration information between updating with the new configuration values.
- --install-directory=/opt/continuent
  install-directory=/opt/continuent
  Path to the directory where the active deployment will be installed. The configured directory will contain the software, THL and relay log information unless configured otherwise.
- --user=tungsten
  user=tungsten
  System User
- --profile-script=~/.bash_profile
  profile-script=~/.bash_profile
  Append commands to include env.sh in this profile script
- --rest-api-admin-user=apiuser
  rest-api-admin-user=apiuser
  Optional: Must be specified along with rest-api-admin-pass if you wish to access the full API features and use the Dashboard GUI for cluster installations.
- --rest-api-admin-pass=secret
  rest-api-admin-pass=secret
  Optional: Must be specified along with rest-api-admin-user if you wish to access the full API features.
Configuration group alpha
The description of each of the options is shown below; click the icon to hide this detail:
Click the icon to show a detailed description of each argument.
- --master=sourcehost
  master=sourcehost
  The hostname of the primary (extractor) within the current service.
- --members=localhost,sourcehost
  members=localhost,sourcehost
  Hostnames for the dataservice members
- --datasource-type=postgresql
  datasource-type=postgresql
  Database type
- --postgresql-dbname=dbname
  postgresql-dbname=dbname
  Name of the database to replicate
- --replication-user=tungsten
  replication-user=tungsten
  For databases that required authentication, the username to use when connecting to the database using the corresponding connection method (native, JDBC, etc.).
- --replication-password=secret
  replication-password=secret
  The password to be used when connecting to the database using the corresponding --replication-user.
- --replication-host=remotedbhost
  replication-host=remotedbhost
  Hostname of the datasource where the database is located. If the specified hostname matches the current host or member name, the database is assumed to be local. If the hostnames do not match, extraction is assumed to be via remote access. For MySQL hosts, this configures a remote replication Replica (relay) connection.
- --replication-port=5432
  replication-port=5432
  The network port used to connect to the database server. The default port used depends on the database being configured.
Note
If you plan to make full use of the REST API (which is enabled by default) you will need to also configure a username and password for API access. This must be done by specifying the following options in your configuration:
```
rest-api-admin-user=tungsten
rest-api-admin-pass=secret
```
Once the prerequisites and configuring of the installation has been completed, the software can be installed:
copy
```
shell> ./tools/tpm install
```

If the installation process fails, check the output of the /tmp/tungsten-configure.log file for more information about the root cause.

Once the replicators have started, the status of the service can be checked using trepctl. See Section 4.8.3, “Management and Monitoring of PostgreSQL Deployments” for more information.

tar zxf tungsten-replicator-7.0.3-141.tar.gz
cd tungsten-replicator-7.0.3-141
./tools/tpm configure defaults \
    --reset \
    --install-directory=/opt/continuent \
    --user=tungsten \
    --profile-script=~/.bash_profile \
    --rest-api-admin-user=apiuser \
    --rest-api-admin-pass=secret

./tools/tpm configure alpha \
    --master=sourcehost \
    --members=localhost,sourcehost \
    --datasource-type=postgresql \
    --postgresql-dbname=dbname \
    --replication-user=tungsten \
    --replication-password=secret \
    --replication-host=remotedbhost \
    --replication-port=5432
vi /etc/tungsten/tungsten.ini
[defaults]
install-directory=/opt/continuent
user=tungsten
profile-script=~/.bash_profile
rest-api-admin-user=apiuser
rest-api-admin-pass=secret

[alpha]
master=sourcehost
members=localhost,sourcehost
datasource-type=postgresql
postgresql-dbname=dbname
replication-user=tungsten
replication-password=secret
replication-host=remotedbhost
replication-port=5432
./tools/tpm install

Show Copy-friendly Text

Prev	Up	Next
4.8.1. Preparing for PostgreSQL Replication	^Level	4.8.3. Management and Monitoring of PostgreSQL Deployments

Continuent Documentation

4.8.2. Install PostgreSQL Applier

Note