have you contacted support ? we had previously used oracle db for mirroring without such problems, maybe postgress sync has some problems
I would like to know the progress on this. How postgresql with mirroring perform? Is there any over head in production?
Mirroring will be damaged , if there is any network connectivity issues, or CTM utility you ran on Primary DB and but dint run on secondary,
can paste here if any error you see in proclog or mirror_log,
and let me know what are the steps that you performed for mirroring?
Hi, i am sorry to interrupt.
Rashid, what do you mean ctm utility only run in primary could damage the mirror? is there any specific list of command & how to deal with it?
May be you didn't run the following command on host computer i.e,
but i was not running those command.
I agree with Mohamed Rashid, Mirroring is damaged if there is network issue between the main server and mirrored server.
Secondly make sure that the Control-M on the mirrored database are down. If Control-M services are running on Mirrored database it damages the mirroring.
From the Primary server type the below command and leave it for a day and look for the connection breakout logs next day.
ping <mirrored server ip> -t >> d:\pingresult.txt
Or you may have some sort of monitoring device in your environment which will notify you about any network outage between these servers. Other will just collect the data using ping command and check the next day.