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-1: technology ^^^^^^^^^^ RDBMS technology. Currently the only possible value is ``postgresql`` . .. _dsn-1: 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-1: host ^^^^ Server address. Leave empty to use the Unix socket connection. .. _port-1: port ^^^^ Port. Default: ``5432`` . .. _dbname-1: dbname ^^^^^^ Database name. Default: ``postgres`` . .. _user-1: user ^^^^ Database user. Default: ``postgres`` . .. _application_name-1: 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 `` Connection`` , with ```` 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-2: 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-2: 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-2: host ^^^^ Server address. Leave empty to use the Unix socket connection. .. _port-2: port ^^^^ Port. Default: ``5432`` . .. _dbname-2: dbname ^^^^^^ Database name. Default: ``postgres`` . service ^^^^^^^ Service name, used in Oracle connections. Default ``XE`` . .. _user-2: 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-2: 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`` .