FTP Replicator PGDATABASE Configuration

These files hold the specification for ensuring that PostgreSQL tables can be replicated between LOCAL and REMOTE.

You can have a number of these; each represents a specific database in PostgreSQL.

You must have an entry to indicate the database in question:-

Database=iShareDataDB

You then specify the type of check the system will perform using Type set to either ‘All’ or ‘Only’:-

Type=Only

Typically the remote will want to send only a specific set of tables, those that can be modified by the users.  You specify each table to be send with an entry:-

Table=at_incidents

You can have as many of these as you wish, however only those tables in this list will be included and only if they are found in this database.  Non-existent tables do not cause an error.

For the LOCAL system, they may be a lot more tables, and the list may be much more dynamic.  Here you specify the ‘Type’ as ‘All’, indicating that all tables should be considered in the transfer.  However, you can now control this with a series of exclusions.

To exclude a specific table, use Exclude, you can list as many of these as is required:-

Exclude=at_incidents

For more general exclusions you can user the two additional settings ExcludeStarts and ExcludeEnds.  These will exclude any table that starts, or ends, with the given characters.

Thus given the following:-

ExcludeStarts=pg_
ExcludeStarts=UNI7LIVE
ExcludeEnds=_LASTUPDATE

The list of tables will not include system tables (anything beginning with “pg_”) nor the tables that we don’t use, the UNI7LIVE set, nor any of the ‘backup’ tables that Data Share creates; i.e. those ending with “_LASTUPDATE”.