summaryrefslogtreecommitdiff
path: root/src/bin/scripts/vacuumdb.c
Commit message (Collapse)AuthorAgeFilesLines
* Support multiple -t/--table arguments for more commandsMagnus Hagander2013-01-171-9/+25
| | | | | | | | On top of the previous support in pg_dump, add support to specify multiple tables (by using the -t option multiple times) to pg_restore, clsuterdb, reindexdb and vacuumdb. Josh Kupershmidt, reviewed by Karl O. Pinc
* Update copyrights for 2013Bruce Momjian2013-01-011-1/+1
| | | | | Fully update git head, and update back branches in ./COPYRIGHT and legal.sgml files.
* In our source code, make a copy of getopt's 'optarg' string arguments,Bruce Momjian2012-10-121-6/+6
| | | | rather than just storing a pointer.
* Fix "too many arguments" messages not to index off the end of argv[].Robert Haas2012-09-061-1/+1
| | | | | This affects initdb, clusterdb, reindexdb, and vacuumdb in master and 9.2; in earlier branches, only initdb is affected.
* Make documentation of --help and --version options more consistentPeter Eisentraut2012-06-181-2/+2
| | | | | | Before, some places didn't document the short options (-? and -V), some documented both, some documented nothing, and they were listed in various orders. Now this is hopefully more consistent and complete.
* Run pgindent on 9.2 source tree in preparation for first 9.3Bruce Momjian2012-06-101-5/+5
| | | | commit-fest.
* Don't override arguments set via options with positional arguments.Andrew Dunstan2012-04-171-11/+16
| | | | | | | | | A number of utility programs were rather careless about paremeters that can be set via both an option argument and a positional argument. This leads to results which can violate the Principal Of Least Astonishment. These changes refuse to use positional arguments to override settings that have been made via positional arguments. The changes are backpatched to all live branches.
* Update copyright notices for year 2012.Bruce Momjian2012-01-011-1/+1
|
* Make command-line tools smarter about finding a DB to connect to.Robert Haas2011-12-061-5/+15
| | | | | | | | If unable to connect to "postgres", try "template1". This allows things to work more smoothly in the case where the postgres database has been dropped. And just in case that's not good enough, also allow the user to specify a maintenance database to be used for the initial connection, to cover the case where neither postgres nor template1 is suitable.
* Stamp copyrights for year 2011.Bruce Momjian2011-01-011-1/+1
|
* Remove cvs keywords from all files.Magnus Hagander2010-09-201-1/+1
|
* Add missing 'Z' letter to getopt_long call --- the newly addedTom Lane2010-06-111-2/+2
| | | | | | --analyze-only switch did not work in its short form -Z. Josh Berkus
* In vacuumdb --help, call analyze "statistics", not "hints".Bruce Momjian2010-02-261-3/+3
|
* pgindent run for 9.0Bruce Momjian2010-02-261-2/+2
|
* Stamp HEAD as 9.0devel, and update various places that were referring to 8.5Tom Lane2010-02-171-2/+2
| | | | (hope I got 'em all). Per discussion, this release will be 9.0 not 8.5.
* Remove old-style VACUUM FULL (which was known for a little while asTom Lane2010-02-081-28/+10
| | | | | | | | | | | | | | | | | VACUUM FULL INPLACE), along with a boatload of subsidiary code and complexity. Per discussion, the use case for this method of vacuuming is no longer large enough to justify maintaining it; not to mention that we don't wish to invest the work that would be needed to make it play nicely with Hot Standby. Aside from the code directly related to old-style VACUUM FULL, this commit removes support for certain WAL record types that could only be generated within VACUUM FULL, redirect-pointer removal in heap_page_prune, and nontransactional generation of cache invalidation sinval messages (the last being the sticking point for Hot Standby). We still have to retain all code that copes with finding HEAP_MOVED_OFF and HEAP_MOVED_IN flag bits on existing tuples. This can't be removed as long as we want to support in-place update from pre-9.0 databases.
* Use -Z for vacuumdb --analyze-only, rather than -o.Bruce Momjian2010-01-071-4/+4
|
* Rename new vacuumdb option to --analyze-only from --only-analyze.Bruce Momjian2010-01-071-15/+15
|
* Corrected CVS entry:Bruce Momjian2010-01-061-2/+2
| | | | --only-analyze mode is for _vacuumdb_, not pg_dump.
* Support rewritten-based full vacuum as VACUUM FULL. TraditionalItagaki Takahiro2010-01-061-19/+74
| | | | | | | | | | | VACUUM FULL was renamed to VACUUM FULL INPLACE. Also added a new option -i, --inplace for vacuumdb to perform FULL INPLACE vacuuming. Since the new VACUUM FULL uses CLUSTER infrastructure, we cannot use it for system tables. VACUUM FULL for system tables always fall back into VACUUM FULL INPLACE silently. Itagaki Takahiro, reviewed by Jeff Davis and Simon Riggs.
* pg_dump --only-analyzeBruce Momjian2010-01-061-22/+52
| | | | | Implement pg_dump --only-analyze for use by pg_migrator to only analyze all databases.
* Update copyright for the year 2010.Bruce Momjian2010-01-021-2/+2
|
* FREEZE and VERBOSE options were in wrong order in the VACUUM command thatHeikki Linnakangas2009-10-161-3/+3
| | | | vacuumdb produces. Per report by Thom Brown.
* In VACUUM, FREEZE must be before ANALYZE; fix this in vacuumdb. DocsBruce Momjian2009-04-281-3/+3
| | | | are already correct.
* Add a -w/--no-password option that prevents all password prompts to allPeter Eisentraut2009-02-261-13/+18
| | | | | | programs that have a -W/--password option. In passing, remove the ancient PSQL_ALWAYS_GET_PASSWORDS compile option.
* Sort the output of --help mostly alphabetical, make it align better, makePeter Eisentraut2009-02-251-4/+4
| | | | help of pg_dump and pg_dumpall more similar.
* Add --freeze option to vacuumdb.Bruce Momjian2009-02-181-9/+17
|
* Update copyright for 2009.Bruce Momjian2009-01-011-2/+2
|
* Append major version number and for libraries soname major version numberPeter Eisentraut2008-12-111-2/+2
| | | | | | | to the gettext domain name, to simplify parallel installations. Also, rename set_text_domain() to pg_bindtextdomain(), because that is what it does.
* Update copyrights in source tree to 2008.Bruce Momjian2008-01-011-2/+2
|
* Make documentation of -W options more accurate and uniform.Tom Lane2007-12-111-2/+2
|
* Remove gratuitous response messages from utility programs.Peter Eisentraut2007-06-041-12/+9
| | | | | | | | | | | | | | (Possibly release notes material, lest users be confused.) The --quiet option is now obsolete and without effect in createdb, createuser, dropdb, dropuser; kept for compatibility but marked for removal in 8.4. Progress messages when acting on all databases now go to stdout instead of stderr, since they are not in fact errors. Ordered options in reindexdb reference page alphabetically, like in other programs' pages.
* Add cancel handlers so it's possible to Ctrl-C clusterdb, reindexdbMagnus Hagander2007-04-091-10/+4
| | | | | and vacuumdb. ITAGAKI Takahiro, with minor fixes from me.
* Add ORDER BY to vacummdb so databases are scaned in the same order asBruce Momjian2007-02-131-2/+2
| | | | pg_dumpall.
* Update CVS HEAD for 2007 copyright. Back branches are typically notBruce Momjian2007-01-051-2/+2
| | | | back-stamped for this.
* Update copyright for 2006. Update scripts.Bruce Momjian2006-03-051-2/+2
|
* Cause initdb to create a third standard database "postgres", whichTom Lane2005-06-211-2/+2
| | | | | | | | | | | | | | unlike template0 and template1 does not have any special status in terms of backend functionality. However, all external utilities such as createuser and createdb now connect to "postgres" instead of template1, and the documentation is changed to encourage people to use "postgres" instead of template1 as a play area. This should fix some longstanding gotchas involving unexpected propagation of database objects by createdb (when you used template1 without understanding the implications), as well as ameliorating the problem that CREATE DATABASE is unhappy if anyone else is connected to template1. Patch by Dave Page, minor editing by Tom Lane. All per recent pghackers discussions.
* Tag appropriate files for rc3PostgreSQL Daemon2004-12-311-2/+2
| | | | | | | | Also performed an initial run through of upgrading our Copyright date to extend to 2005 ... first run here was very simple ... change everything where: grep 1996-2004 && the word 'Copyright' ... scanned through the generated list with 'less' first, and after, to make sure that I only picked up the right entries ...
* Pgindent run for 8.0.Bruce Momjian2004-08-291-5/+3
|
* Update copyright to 2004.Bruce Momjian2004-08-291-2/+2
|
* Add PGETC (for pg_service.conf) and PGLOCALE (for locale dir)Bruce Momjian2004-06-031-2/+2
| | | | | | | | | environment variable processing to libpq. The patch also adds code to our client apps so we set the environment variable directly based on our binary location, unless it is already set. This will allow our applications to emit proper locale messages that are generated in libpq.
* Remove init_nls() functions, call set_pglocale() directly.Bruce Momjian2004-06-011-2/+3
| | | | Add locale to pg_ctl.c.
* Make the locale location relocatable.Bruce Momjian2004-05-251-2/+2
| | | | Adjust get_*_path functions to be limited to MAXPGPATH.
* Rename find_my_binary/find_other_binary toBruce Momjian2004-05-121-2/+2
| | | | | | | | | find_my_exec/find_other_exec(). Remove passing of progname to these functions as they can find that out from argv[0], which they already have. Make get_progname return const char *, and update all progname variables to be const char *.
* Do an explicit fflush after writing a progress message with puts.Tom Lane2004-01-011-15/+20
| | | | | This ensures stdout is kept in sync with messages on stderr. Per report from Olaf Ferger.
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* pgindent run.Bruce Momjian2003-08-041-15/+19
|
* Apply message style guide to frontend programs.Peter Eisentraut2003-07-231-4/+4
|
* Change clusterdb and vacuumdb into C programs.Peter Eisentraut2003-06-181-0/+272
View Lorry Controller Status