23.02.2021 09:31, Peter Gore wrote:
As a test I have tried to get asynchronous replication working. Is this
even possible when Master and Replica is on the same Server?
Sure. Even using a single FB instance for both.
I have two
databases; FB4Test.fdb and FB4TestReplica.fdb o the same (localhost)
server. The replica I created by copying theFB4Test.FDB whilst the
server was not running.
I followed the release notes and changed the replication.conf as follows
database = D:\Users\Peter\Documents\FB4Data\FB4TEST.FDB
{
log_directory = /FB4Test/chlog
log_archive_directory = /FB4Test/archlog
UNIX paths??? Your server is obviously on Windows, so it cannot work.
I'd rather expect something like:
log_directory = D:\Users\Peter\Documents\FB4Test\chlog
log_archive_directory = D:\Users\Peter\Documents\FB4Test\archlog
database = D:\Users\Peter\Documents\FB4Data\FB4TESTReplica.FDB
{
log_source_directory = /incominglogs/
Same here.
I also ran all the necessary DDL statements and run GFIX as prescribed
*GFIX - Doc anomaly 2*
Release Notes
I found empirically that
Page 28
gfix -replica read-only <database>
should be
gfix -replica read_only <database>
Also page 137
gfix -replica read-only <database>
should be
gfix -replica read_only <database>
Probably references to read-write should be read_write but haven't tried
this.
Noted to be fixed, thanks.
*GFIX - Returned error*
gfix -replica read_only D:\Users\Peter\Documents\FB4Data\FB4TESTReplica.FDB
Unable to perform operation
-System privilege USE_GFIX_UTILITY is missing
You missed the -user switch, and the user must be DBA/owner.
When I modify data in the Master database the following error appears in
the Firebird.log
TOSHPJGTue Feb 23 06:02:15 2021
Operating system call FindFirstFile failed. Error code 3
I will improve the error reporting to be more user-friendly. This errors
means non-existing "/FB4Test/chlog" directory.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel