Connection Settings#
Initial Connection#
The initial connection is used only when logical_replication_mode is
set to pglogical or bdr . If you set data connections to use
only the node_name setting, it’s used when the program starts to
fetch DSN from node names.
technology#
RDBMS technology. Currently the only possible value is postgresql.
dsn#
PostgreSQL connection string. If dsn is set, then host, port, dbname, and user are ignored. The dsn setting can also have all other parameter key words allowed by libpq .
host#
Server address. Leave empty to use the Unix socket connection.
port#
Port. Default: 5432.
dbname#
Database name. Default: postgres. ### user
Database user. Default: postgres. ### application_name
Application name. Can be used even if you set dsn instead of all other connection information. Default: livecompare_initial.
Output Connection#
The output connection specifies where LiveCompare creates the comparison report tables.
technology#
RDBMS technology. Currently the only possible value is postgresql.
dsn#
PostgreSQL connection string. If dsn is set, then host, port, dbname, and user are ignored. The dsn setting can also have all other parameter key words allowed by libpq .
host#
Server address. Leave empty to use the Unix socket connection.
port#
Port. Default: 5432.
dbname#
Database name. Default: postgres.
user#
Database user. Default: postgres.
application_name#
Application name. Can be used even if you set dsn instead of all other connection information. Default: livecompare_output.
Data Connection#
A data connection is a connection section similar to
Initial Connection and Output Connection , but LiveCompare
effectively fetches and compares data on the data connections.
Similar to the Initial Connection and Output Connection , a data
connection is defined in a named section. The section name is of the
form <Name> Connection , with <Name> being any single-word
string starting with an alphabetic character. In this case, whatever you
use as Name is called the connection ID of the data connection.
Each data connection must also have a unique connection ID in the list
of data connections.
If logical_replication_mode = bdr and all_bdr_nodes = on , then
you don’t need to specify any data connection. LiveCompare builds the
data connection list by fetching PGD metadata from the
Initial Connection .
technology#
RDBMS technology. Currently possible values are postgresql or oracle. ### node_name
Name of the node in the cluster. Requires logical_replication_mode set to pglogical or bdr and also requires that the Initial Connection is filled. If node_name is set, then dsn, host, port, dbname, and user settings are all ignored. ### dsn
PostgreSQL connection string. If dsn is set, then host, port, dbname, and user are ignored. The dsn setting can also have all other parameter key words allowed by libpq . ### host
Server address. Leave empty to use the Unix socket connection. ### port
Port. Default: 5432. ### dbname
Database name. Default: postgres. ### service
Service name, used in Oracle connections. Default XE. ### user
Database user. Default: postgres.
password#
Plain text password. We don’t recommend using this. However, it might be required in some legacy connections.
application_name#
Application name. Can be used even if you set dsn or node_name instead of all other connection information. Default: livecompare_.
start_query#
Arbitrary query that’s executed each time a connection to a database is open.
fetch_fk_metadata#
Specifies whether LiveCompare gathers metadata about foreign keys on the connection. Default: on.