PostgreSQL is used to hold the status information for Replication. The Database name is specified in the Python configuration. There needs to be an instance of this database on both LOCAL and REMOTE locations.
Transmission Log
This is a PostgreSQL table ‘transmissionlog’ which holds the files that have been previously transmitted. It is used to indicate the files that are about to be transmitted. The currents timestamp can be checked against the last edit time on a file to indicate whether a file needs to be retransmitted.
...
Field | Type | Holds |
|---|---|---|
Filename | Text | Fully pathed filename. |
currentts | Timestamp without time zone | Last time file was modified. |
Newts | Timestamp without time zone | Latest time file was modified. |
action | Character(1) | Action (A=Addition, U=Update). |
locale | Character(1) | Owner of the field (by default R=Remote, L=Local) |
Status
This is a PostgreSQL table which holds the status of the current run for a location.
...
The nextprocess field holds what entity is to be run next when the current finishes with the full parameter set it would use. This is necessary when running in Asynchronous mode to get the call that a REMOTE entity would have used.
PostgreSQL Configuration
In the pg_hba.conf file the authentication method for local connections needs to be trust, e.g.
...