1use strict; 2use warnings; 3 4use Config; 5use PostgresNode; 6use TestLib; 7use Test::More tests => 68; 8 9my $tempdir = TestLib::tempdir; 10my $tempdir_short = TestLib::tempdir_short; 11 12######################################### 13# Basic checks 14 15program_help_ok('pg_dump'); 16program_version_ok('pg_dump'); 17program_options_handling_ok('pg_dump'); 18 19program_help_ok('pg_restore'); 20program_version_ok('pg_restore'); 21program_options_handling_ok('pg_restore'); 22 23program_help_ok('pg_dumpall'); 24program_version_ok('pg_dumpall'); 25program_options_handling_ok('pg_dumpall'); 26 27######################################### 28# Test various invalid options and disallowed combinations 29# Doesn't require a PG instance to be set up, so do this first. 30 31command_fails_like( 32 [ 'pg_dump', 'qqq', 'abc' ], 33 qr/\Qpg_dump: too many command-line arguments (first is "abc")\E/, 34 'pg_dump: too many command-line arguments (first is "asd")'); 35 36command_fails_like( 37 [ 'pg_restore', 'qqq', 'abc' ], 38 qr/\Qpg_restore: too many command-line arguments (first is "abc")\E/, 39 'pg_restore too many command-line arguments (first is "abc")'); 40 41command_fails_like( 42 [ 'pg_dumpall', 'qqq', 'abc' ], 43 qr/\Qpg_dumpall: too many command-line arguments (first is "qqq")\E/, 44 'pg_dumpall: too many command-line arguments (first is "qqq")'); 45 46command_fails_like( 47 [ 'pg_dump', '-s', '-a' ], 48 qr/\Qpg_dump: options -s\/--schema-only and -a\/--data-only cannot be used together\E/, 49 'pg_dump: options -s/--schema-only and -a/--data-only cannot be used together' 50); 51 52command_fails_like( 53 [ 'pg_restore', '-s', '-a' ], 54 qr/\Qpg_restore: options -s\/--schema-only and -a\/--data-only cannot be used together\E/, 55 'pg_restore: options -s/--schema-only and -a/--data-only cannot be used together' 56); 57 58command_fails_like( 59 [ 'pg_restore', '-d', 'xxx', '-f', 'xxx' ], 60 qr/\Qpg_restore: options -d\/--dbname and -f\/--file cannot be used together\E/, 61 'pg_restore: options -d/--dbname and -f/--file cannot be used together'); 62 63command_fails_like( 64 [ 'pg_dump', '-c', '-a' ], 65 qr/\Qpg_dump: options -c\/--clean and -a\/--data-only cannot be used together\E/, 66 'pg_dump: options -c/--clean and -a/--data-only cannot be used together'); 67 68command_fails_like( 69 [ 'pg_restore', '-c', '-a' ], 70 qr/\Qpg_restore: options -c\/--clean and -a\/--data-only cannot be used together\E/, 71 'pg_restore: options -c/--clean and -a/--data-only cannot be used together' 72); 73 74command_fails_like( 75 [ 'pg_dump', '--inserts', '-o' ], 76 qr/\Qpg_dump: options --inserts\/--column-inserts and -o\/--oids cannot be used together\E/, 77 'pg_dump: options --inserts/--column-inserts and -o/--oids cannot be used together' 78); 79 80command_fails_like( 81 [ 'pg_dump', '--if-exists' ], 82 qr/\Qpg_dump: option --if-exists requires option -c\/--clean\E/, 83 'pg_dump: option --if-exists requires option -c/--clean'); 84 85command_fails_like( 86 [ 'pg_dump', '-j3' ], 87 qr/\Qpg_dump: parallel backup only supported by the directory format\E/, 88 'pg_dump: parallel backup only supported by the directory format'); 89 90command_fails_like( 91 [ 'pg_dump', '-j', '-1' ], 92 qr/\Qpg_dump: invalid number of parallel jobs\E/, 93 'pg_dump: invalid number of parallel jobs'); 94 95command_fails_like( 96 [ 'pg_dump', '-F', 'garbage' ], 97 qr/\Qpg_dump: invalid output format\E/, 98 'pg_dump: invalid output format'); 99 100command_fails_like( 101 [ 'pg_restore', '-j', '-1' ], 102 qr/\Qpg_restore: invalid number of parallel jobs\E/, 103 'pg_restore: invalid number of parallel jobs'); 104 105command_fails_like( 106 [ 'pg_restore', '--single-transaction', '-j3' ], 107 qr/\Qpg_restore: cannot specify both --single-transaction and multiple jobs\E/, 108 'pg_restore: cannot specify both --single-transaction and multiple jobs'); 109 110command_fails_like( 111 [ 'pg_dump', '-Z', '-1' ], 112 qr/\Qpg_dump: compression level must be in range 0..9\E/, 113 'pg_dump: compression level must be in range 0..9'); 114 115command_fails_like( 116 [ 'pg_restore', '--if-exists' ], 117 qr/\Qpg_restore: option --if-exists requires option -c\/--clean\E/, 118 'pg_restore: option --if-exists requires option -c/--clean'); 119 120command_fails_like( 121 [ 'pg_restore', '-F', 'garbage' ], 122 qr/\Qpg_restore: unrecognized archive format "garbage";\E/, 123 'pg_dump: unrecognized archive format'); 124 125# pg_dumpall command-line argument checks 126command_fails_like( 127 [ 'pg_dumpall', '-g', '-r' ], 128 qr/\Qpg_dumpall: options -g\/--globals-only and -r\/--roles-only cannot be used together\E/, 129 'pg_dumpall: options -g/--globals-only and -r/--roles-only cannot be used together' 130); 131 132command_fails_like( 133 [ 'pg_dumpall', '-g', '-t' ], 134 qr/\Qpg_dumpall: options -g\/--globals-only and -t\/--tablespaces-only cannot be used together\E/, 135 'pg_dumpall: options -g/--globals-only and -t/--tablespaces-only cannot be used together' 136); 137 138command_fails_like( 139 [ 'pg_dumpall', '-r', '-t' ], 140 qr/\Qpg_dumpall: options -r\/--roles-only and -t\/--tablespaces-only cannot be used together\E/, 141 'pg_dumpall: options -r/--roles-only and -t/--tablespaces-only cannot be used together' 142); 143 144command_fails_like( 145 [ 'pg_dumpall', '--if-exists' ], 146 qr/\Qpg_dumpall: option --if-exists requires option -c\/--clean\E/, 147 'pg_dumpall: option --if-exists requires option -c/--clean'); 148