@@ -119,7 +119,7 @@ Options:
119
119
-a, --all repack all databases
120
120
-t, --table=TABLE repack specific table only
121
121
-s, --tablespace=TBLSPC move repacked tables to a new tablespace
122
- -S, --moveidx move repacked indexes to TBLSPC too
122
+ -S, --moveidx move repacked indexes to * TBLSPC * too
123
123
-o, --order-by=COLUMNS order by columns instead of cluster keys
124
124
-n, --no-order do vacuum full instead of cluster
125
125
-j, --jobs Use this many parallel jobs for each table
@@ -293,13 +293,13 @@ database where the error occured and then load
293
293
294
294
.. class :: diag
295
295
296
- pg_repack: repack database "template1" ... skipped: pg_repack is not installed in the database
297
- pg_repack is not installed in the database when ``--all `` option is
296
+ INFO: database "db" skipped: pg_repack VER is not installed in the database
297
+ pg_repack is not installed in the database when the ``--all `` option is
298
298
specified.
299
299
300
300
Create the pg_repack extension in the database.
301
301
302
- ERROR: pg_repack is not installed
302
+ ERROR: pg_repack VER is not installed in the database
303
303
pg_repack is not installed in the database specified by ``--dbname ``.
304
304
305
305
Create the pg_repack extension in the database.
@@ -326,22 +326,11 @@ ERROR: relation "table" must have a primary key or not-null unique keys
326
326
327
327
Define a PRIMARY KEY or a UNIQUE constraint on the table.
328
328
329
- ERROR: relation "table" has no cluster key
330
- The target table doesn't have CLUSTER KEY.
331
-
332
- Define a CLUSTER KEY on the table, via ALTER TABLE CLUSTER ON, or use
333
- one of the --no-order or --order-by modes.
334
-
335
329
ERROR: query failed: ERROR: column "col" does not exist
336
330
The target table doesn't have columns specified by ``--order-by `` option.
337
331
338
332
Specify existing columns.
339
333
340
- ERROR: permission denied for schema repack
341
- Permission error.
342
-
343
- pg_repack must be executed by a superuser.
344
-
345
334
WARNING: the table "tbl" has already a trigger called z_repack_trigger
346
335
The trigger was probably installed during a previous attempt to run
347
336
pg_repack on the table which was interrupted and for some reason failed
@@ -416,13 +405,14 @@ Releases
416
405
417
406
* pg_repack 1.2
418
407
419
- * Added --tablespace and --moveidx options to perform online SET TABLESPACE.
420
- * Added --jobs option for parallel operation .
421
- * Don't require --no-order to perform a VACUUM FULL on non-clustered tables
422
- (pg_repack issue #6).
423
- * More helpful error messages .
408
+ * Added `` --tablespace `` and `` --moveidx `` options to perform online
409
+ SET TABLESPACE .
410
+ * Added `` --jobs `` option for parallel operation.
411
+ * Don't require `` --no-order `` to perform a VACUUM FULL on non-clustered
412
+ tables (pg_repack issue #6) .
424
413
* Bugfix: correctly handle key indexes with options such as DESC, NULL
425
414
FIRST/LAST, COLLATE (pg_repack issue #3).
415
+ * More helpful program output and error messages.
426
416
427
417
* pg_repack 1.1.8
428
418
0 commit comments