This section describes how you create a new server for PostgreSQL.
-
On the Servers Properties dialog, select PostgreSQL from the dropdown list in the DBMS type section.
-
Enter information for each field on the Server Properties dialog. Refer Server Properties dialog for PostgreSQL for field information. in the DBMS type section.
Parameter |
Description |
---|---|
Name |
Enter a unique server name for use in the model. Note: The slash (/), backslash (\), colon (:), left caret
(<), right caret (>), and spaces cannot be used in a Server
name.
|
DBMS Type |
Select PostgreSQL. |
Server name | Specify the Postgres database name for your Postgres target. Often, the value you enter here is the same as the host name of the system where PostgreSQL is installed. |
DBMS instance port |
Enter the value used when PostgreSQL was installed. 5432 is the default. |
JDBC Driver |
The JDBC Driver is automatically selected based on the database you specified in the DBMS version field:
|
Driver Version |
View the JDBC Driver version. This information is obtained each time a connection to the database is made (including a Test Connection). |
DBMS logon IDs and DBMS logon password |
Specify the Default and Rep user IDs.
Note: When adding, updating, or deleting rows on the source table, do
not use the replication user ID to make these changes. Changes made
by the replication user are ignored by change capture
triggers.
Specify additional IDs.
|
Metabase schema |
Specify the name of the metabase schema. It is the qualifier of the metabase tables, in the format qualifier.tablename. |
Enable Prepared Statements |
If selected, prepared statements are enabled for the entire database server. A prepared SQL statement is a statement in which the steps to parse, analyze, validate, and determine the access path are only done once, when the statement is first prepared. On subsequent executions of the statement, the database has this information stored in memory and can skip the initial preparation steps. After a statement is prepared, only the column values change from one execution of the statement to the next. Each table can have as many as seven prepared statements: one for insert, up to five for update, and one for delete. The first time an insert, update, or delete statement is encountered, the statement is prepared, added to the cache, and is used to update the table. The statements are kept in the cache until removed. Using prepared statements provides a significant performance improvement when the same SQL statement is executed over and over. However, in some cases data for unchanged columns will be captured and sent across the network. Individual tables can disable prepared statements. This is useful for managing the size of the cache file. |
Database limit |
Displays the maximum size allowed by the database for open statements in the cache. The Specified limit, below, cannot exceed this value. The correct value is provided after you run a Test Connection. To do so, right-click the server name, then select Test Connection. |
Specified limit |
Enter the maximum size allowed for open statements in the cache. When the statement cache is full, the least recently used statement is removed from the cache, closed, and destroyed. If Journal batching is enabled, prior to removing the statement, pending batch updates are executed, If the statement that was removed is later referenced, a new prepared statement is created and added to the cache. Note the following:
|
Remote Machine Name or IP |
Select this checkbox if you are creating a new remote server for PostgreSQL. Refer to Create a new remote PostgreSQL. Specify the remote machine name or IP address. The remote machine name or IP address must be a valid machine name or IP address of the machine hosting the remote PostgreSQL instance. The remote machine name (or IP address), and the Server name establish the connection with the remote server. This is a required field. |
Model using metabase |
Displays the name of the model. (Informational only) |
Model version |
Displays the version number, updated after each commit. (Informational only) |
Metabase version |
Displays the version of the metabase (for example, 40d). (Informational only) |
GMT offset (minutes) |
Displays the amount of time, in minutes, that local time differs from Greenwich Mean Time (GMT). For example, Boston is 300 minutes less than GMT. (Informational only) |