21: PostgreSQL Initial Setup

Owned by Michael Litner
Oct 20, 2024
6 min read

To setup the infrastructure in the Data Virtualization Module, do the following procedure:

  1. 21: PostgreSQL Initial Setup | To install the Accelario source agent and target agent:

  2. 21: PostgreSQL Initial Setup | To add a source host

  3. 21: PostgreSQL Initial Setup | To create a test data environment:

  4. 21: PostgreSQL Initial Setup | To add a target host:

  5. 21: PostgreSQL Initial Setup | To add a DB Home:

  6. 21: PostgreSQL Initial Setup | Create and start a VDB

 

To install the Accelario source agent and target agent:

Accelario agents are deployed on a source server and on a target server. There are two types of agents:

  1. GI (golden image) agent - installed on the source server.

  2. Destination agent - installed on the target server.

When the VDB is used on the same server where the source DB resides, both agents can be installed on the same server. It is necessary to change the ports as described below.

  • The agents should be run as root.

  • The agents should be run in the background.

Example for a source agent.

Example for a target agent.

The default port is 8080.

If necessary, the port can be changed. Use the following parameters to java execution: Example for a source agent.

Example for a target agent.

To set the timezone for a java process:

To set the timezone for a java process, use the following code:

-Duser.timezone=<TimeZone> jvm command line option

Example for a source agent.

Example for a target agent.

To add a source host

  1. On the navigation bar, click Source.

The Source Management window appears.

2. Click Add Source Host.

3. Enter the source host details.

In all dialog boxes, an asterisk * next to a label on the left is used to identify a mandatory user input.

4. Enter the Advanced Parameters if necessary.

5. Click Add.

The Source Management window displays the source host(s) that have been added to the system.

To create a test data environment:

  1. On the navigation bar, click Source.

The Source Management window appears.

2. Click Create Test Data Environment.

3. Select DB type.

4. Enter a Name.

5. Click Next.

To create a test data environment from a LIVE GI:

  1. Enter the test data environment details.

2. Click Next.

3. Enter the Source DB Parameters.

4. Click Test Connection to verify that the connection to the database is valid.

5. Click Done.

The Source Management window displays the test data environment for the source host that has been created.

To add a target host:

  1. On the navigation bar, click Target.
    The Target Management window appears.

2. Click Add Target Host.

3. Enter the target host details.

4. Enter the Advanced Parameters if necessary.

5. Click Add.

The Target Management displays the target host(s) that have been added to the system.

To add a DB Home:

  1. Click Add DB Home.

2. Select a DB type.

3. Enter the DB Home details.

4. Click Add.

The Target Management displays the DB Home(s) that have been added to the system.

Create and start a VDB

To create a VDB:

  1. On the navigation bar, click VDB.
    The VDB Management window appears.

To select a GI:

  1. In the VDB Management window, select a Test Data Environment.

2. Select the GI.

Adding a snapshot:

  1. Select the source.

  2. Click Add Snapshot.

3. Enter a Name.

4. Click Add.

The Snapshots work area displays the new snapshot with all the snapshots that have been created.

To create a VDB from a snapshot:

  1. Select a snapshot.

  2. Click Create VDB.

3. Enter the VDB parameters.

4. Enter the Advanced Parameters, if necessary.

5. Click Create VDB. Otherwise, click Cancel to exit without creating a VDB.

The VDB Management window displays the VDB that has been created.

The following icons display information about a VDB:

Icon

Description

VDB Locked

VDB Stopped

VDB Started

VDB Creation Failed

Â