Search PostgreSQL documentation

sslmodeCommand-line ToolsPG18sslmode This option determines whether or with what priority a secure SSL TCP/IP connection will be negotiated with the server. There are six modes: disable only try a non-SSL connection all…Database Connection Control Functions › Parameter Key Words sslnegotiationCommand-line ToolsPG18sslnegotiation This option controls how SSL encryption is negotiated with the server, if SSL is used. In the default postgres mode, the client first asks the server if SSL is supported. In d…Database Connection Control Functions › Parameter Key Words sslpasswordCommand-line ToolsPG18sslpassword This parameter specifies the password for the secret key specified in sslkey, allowing client certificate private keys to be stored in encrypted form on disk even when interactiv…Database Connection Control Functions › Parameter Key Words sslrootcertCommand-line ToolsPG18sslrootcert This parameter specifies the name of a file containing SSL certificate authority (CA) certificate(s). If the file exists, the server's certificate will be verified to be signed b…Database Connection Control Functions › Parameter Key Words sslsniCommand-line ToolsPG18sslsni If set to 1 (default), libpq sets the TLS extension “Server Name Indication” (SNI) on SSL-enabled connections. By setting this parameter to 0, this is turned off. The Server Name Indi…Database Connection Control Functions › Parameter Key Words target_session_attrsCommand-line ToolsPG18target_session_attrs This option determines whether the session must have certain properties to be acceptable. It's typically used in combination with multiple host names to select the first…Database Connection Control Functions › Parameter Key Words userCommand-line ToolsPG18user PostgreSQL user name to connect as. Defaults to be the same as the operating system name of the user running the application.Database Connection Control Functions › Parameter Key Words vacuumdbCommand-line ToolsPG18vacuumdb vacuumdb — garbage-collect and analyze a PostgreSQL database Synopsis vacuumdb [connection-option...] [option...] [ -t | --table table [( column [,...] )] ] ... [ dbname | -a | --al…vacuumdb vacuumdb --allCommand-line ToolsPG18-a--all Vacuum all databases.vacuumdb › Options vacuumdb --analyzeCommand-line ToolsPG18-z--analyze Also calculate statistics for use by the optimizer.vacuumdb › Options vacuumdb --analyze-in-stagesCommand-line ToolsPG18--analyze-in-stages Only calculate statistics for use by the optimizer (no vacuum), like --analyze-only. Run three stages of analyze; the first stage uses the lowest possible statistics targ…vacuumdb › Options vacuumdb --analyze-onlyCommand-line ToolsPG18-Z--analyze-only Only calculate statistics for use by the optimizer (no vacuum).vacuumdb › Options vacuumdb --buffer-usage-limit sizeCommand-line ToolsPG18--buffer-usage-limit size Specifies the Buffer Access Strategy ring buffer size for a given invocation of vacuumdb. This size is used to calculate the number of shared buffers which will be …vacuumdb › Options vacuumdb --disable-page-skippingCommand-line ToolsPG18--disable-page-skipping Disable skipping pages based on the contents of the visibility map.vacuumdb › Options vacuumdb --echoCommand-line ToolsPG18-e--echo Echo the commands that vacuumdb generates and sends to the server.vacuumdb › Options vacuumdb --exclude-schema=schemaCommand-line ToolsPG18-N schema--exclude-schema=schema Do not clean or analyze any tables in schema. Multiple schemas can be excluded by writing multiple -N switches.vacuumdb › Options vacuumdb --force-index-cleanupCommand-line ToolsPG18--force-index-cleanup Always remove index entries pointing to dead tuples.vacuumdb › Options vacuumdb --freezeCommand-line ToolsPG18-F--freeze Aggressively “freeze” tuples.vacuumdb › Options vacuumdb --fullCommand-line ToolsPG18-f--full Perform “full” vacuuming.vacuumdb › Options vacuumdb --helpCommand-line ToolsPG18-?--help Show help about vacuumdb command line arguments, and exit.vacuumdb › Options vacuumdb --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.vacuumdb › Options vacuumdb --jobs=njobsCommand-line ToolsPG18-j njobs--jobs=njobs Execute the vacuum or analyze commands in parallel by running njobs commands simultaneously. This option may reduce the processing time but it also increases the load on…vacuumdb › Options vacuumdb --maintenance-db=dbnameCommand-line ToolsPG18--maintenance-db=dbname When the -a/--all is used, connect to this database to gather the list of databases to vacuum. If not specified, the postgres database will be used, or if that does n…vacuumdb › Options vacuumdb --min-mxid-age mxid_ageCommand-line ToolsPG18--min-mxid-age mxid_age Only execute the vacuum or analyze commands on tables with a multixact ID age of at least mxid_age. This setting is useful for prioritizing tables to process to preve…vacuumdb › Options vacuumdb --min-xid-age xid_ageCommand-line ToolsPG18--min-xid-age xid_age Only execute the vacuum or analyze commands on tables with a transaction ID age of at least xid_age. This setting is useful for prioritizing tables to process to preven…vacuumdb › Options vacuumdb --missing-stats-onlyCommand-line ToolsPG18--missing-stats-only Only analyze relations that are missing statistics for a column, index expression, or extended statistics object. When used with --analyze-in-stages, this option prevent…vacuumdb › Options vacuumdb --no-index-cleanupCommand-line ToolsPG18--no-index-cleanup Do not remove index entries pointing to dead tuples.vacuumdb › Options vacuumdb --no-passwordCommand-line ToolsPG18-w--no-password Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt wi…vacuumdb › Options vacuumdb --no-process-mainCommand-line ToolsPG18--no-process-main Skip the main relation.vacuumdb › Options vacuumdb --no-process-toastCommand-line ToolsPG18--no-process-toast Skip the TOAST table associated with the table to vacuum, if any.vacuumdb › Options vacuumdb --no-truncateCommand-line ToolsPG18--no-truncate Do not truncate empty pages at the end of the table.vacuumdb › Options vacuumdb --parallel=parallel_workersCommand-line ToolsPG18-P parallel_workers--parallel=parallel_workers Specify the number of parallel workers for parallel vacuum. This allows the vacuum to leverage multiple CPUs to process indexes. See VACUUM.vacuumdb › Options vacuumdb --passwordCommand-line ToolsPG18-W--password Force vacuumdb to prompt for a password before connecting to a database. This option is never essential, since vacuumdb will automatically prompt for a password if the server de…vacuumdb › Options vacuumdb --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.vacuumdb › Options vacuumdb --quietCommand-line ToolsPG18-q--quiet Do not display progress messages.vacuumdb › Options vacuumdb --schema=schemaCommand-line ToolsPG18-n schema--schema=schema Clean or analyze all tables in schema only. Multiple schemas can be vacuumed by writing multiple -n switches.vacuumdb › Options vacuumdb --skip-lockedCommand-line ToolsPG18--skip-locked Skip relations that cannot be immediately locked for processing.vacuumdb › Options vacuumdb --table=table [ (column [,...]) ]Command-line ToolsPG18-t table [ (column [,...]) ]--table=table [ (column [,...]) ] Clean or analyze table only. Column names can be specified only in conjunction with the --analyze or --analyze-only options. Mul…vacuumdb › Options vacuumdb --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.vacuumdb › Options vacuumdb --verboseCommand-line ToolsPG18-v--verbose Print detailed information during processing.vacuumdb › Options