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