PostgreSQL Initial Setup

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

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

2. PostgreSQL Initial Setup | To add a source host

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

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

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

6. 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.

Example for a source agent.

Open

Open

Example for a target agent.

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.

2. Click Add Source Host.

3. Enter the source host details.

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.

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.

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.

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.

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 following icons display information about a VDB: