Fix BF failure introduced by commit b3f6b14.

Amit Kapila · Amit Kapila · commit def0ce337068 · 2024-03-01T10:25:36.000+05:30
The test added by commit b3f6b14 uses a non-superuser and forgot to set up pg_hba.conf to allow connections from it. The special setup is only needed on Windows machines that don't use UNIX sockets. As per buildfarm Discussion: https://postgr.es/m/CAJpy0uCfrSspV1x3VWkgamqyhYaUWQZpP0nqjJx4YPvKqN6P_A@mail.gmail.com
diff --git a/src/test/recovery/t/040_standby_failover_slots_sync.pl b/src/test/recovery/t/040_standby_failover_slots_sync.pl
@@ -14,7 +14,11 @@
 
 # Create publisher
 my $publisher = PostgreSQL::Test::Cluster->new('publisher');
-$publisher->init(allows_streaming => 'logical');
+# Make sure pg_hba.conf is set up to allow connections from repl_role.
+# This is only needed on Windows machines that don't use UNIX sockets.
+$publisher->init(
+	allows_streaming => 'logical',
+	auth_extra => [ '--create-role', 'repl_role' ]);
 # Disable autovacuum to avoid generating xid during stats update as otherwise
 # the new XID could then be replicated to standby at some random point making
 # slots at primary lag behind standby during slot sync.
