If for some reason FTP Replicator is unable to complete successfully, the local Local and remote Remote databases can get out of sync. In this situation, future replication attempts will fail until the databases are brought back into sync.
If you have access to PgAdmin3 on the local Local and remote Remote server, you can check the status tables (statuslocal and statusremote, respectively). Open PgAdmin3 on your local Local server, and browse to your FTP Replication database. Expand the public schema and find the statuslocal table. This should have a single row. The attribute "running" should be FALSE, but in the case of a failure it may say TRUE.
In the SQL window run the following command:
| Code Block | ||
|---|---|---|
| ||
update statuslocal set (running,status,exitstatus,nextprocess,commmode) = (FALSE, '', 0, '', ''); |
On the remote Remote server, repeat these steps but update the statusremote table instead:
| Code Block | ||
|---|---|---|
| ||
update statusremote set (running,status,exitstatus,nextprocess,commmode) = (FALSE, '', 0, '', ''); |
You should then be able to run the replication from the windows task schedulerWindows Task Scheduler, as normal.