pgsql: Fix some failures with connection tests on Windows hosts

Fix some failures with connection tests on Windows hosts

The truncation of the log file, that this set of tests relies on to make
sure that a connection attempt matches with its expected backend log
pattern, fails, as reported by buildfarm member fairywren. Instead of a
truncation, do a rotation of the log file and restart the node. This
will ensure that the connection attempt data is unique for each test.

Discussion: /messages/by-id/YG05nCI8x8B+Ad3G@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c7578fa64019f27edc31261ea49066a4b2569a6c

Modified Files
--------------
src/test/perl/PostgresNode.pm | 24 ++++++++++++++++++++++--
1 file changed, 22 insertions(+), 2 deletions(-)