Search PostgreSQL documentation

pg_amcheck --index=patternCommand-line ToolsPG18pg_amcheck › Optionsi pattern--index=pattern Check indexes matching the specified pattern, unless they are otherwise excluded. This option can be specified more than once. This is similar to the --relation opti… pg_amcheck --install-missing=schemaCommand-line ToolsPG18pg_amcheck › Optionsinstall-missing--install-missing=schema Install any missing extensions that are required to check the database(s). If not yet installed, each extension's objects will be installed into the g… pg_amcheck --jobs=numCommand-line ToolsPG18pg_amcheck › Optionsj num--jobs=num Use num concurrent connections to the server, or one per object to be checked, whichever is less. The default is to use a single connection. pg_amcheck --maintenance-db=dbnameCommand-line ToolsPG18pg_amcheck › Optionsmaintenance-db=dbname Specifies a database or connection string to be used to discover the list of databases to be checked. If neither --all nor any option including a database pattern is us… pg_amcheck --no-dependent-indexesCommand-line ToolsPG18pg_amcheck › Optionsno-dependent-indexes By default, if a table is checked, any btree indexes of that table will also be checked, even if they are not explicitly selected by an option such as --index or --relat… pg_amcheck --no-dependent-toastCommand-line ToolsPG18pg_amcheck › Optionsno-dependent-toast By default, if a table is checked, its toast table, if any, will also be checked, even if it is not explicitly selected by an option such as --table or --relation. This op… pg_amcheck --no-passwordCommand-line ToolsPG18pg_amcheck › Optionsw--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 wil… pg_amcheck --no-strict-namesCommand-line ToolsPG18pg_amcheck › Optionsno-strict-names By default, if an argument to --database, --table, --index, or --relation matches no objects, it is a fatal error. This option downgrades that error to a warning. pg_amcheck --on-error-stopCommand-line ToolsPG18pg_amcheck › Optionson-error-stop After reporting all corruptions on the first page of a table where corruption is found, stop processing that table relation and move on to the next table or index. Note that in… pg_amcheck --parent-checkCommand-line ToolsPG18pg_amcheck › Optionsparent-check For each btree index checked, use amcheck's bt_index_parent_check function, which performs additional checks of parent/child relationships during index checking. The default is … pg_amcheck --passwordCommand-line ToolsPG18pg_amcheck › OptionsW--password Force pg_amcheck to prompt for a password before connecting to a database. This option is never essential, since pg_amcheck will automatically prompt for a password if the server… pg_amcheck --port=portCommand-line ToolsPG18pg_amcheck › Optionsp port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. pg_amcheck --progressCommand-line ToolsPG18pg_amcheck › OptionsP--progress Show progress information. Progress information includes the number of relations for which checking has been completed, and the total size of those relations. It also includes th… pg_amcheck --relation=patternCommand-line ToolsPG18pg_amcheck › Optionsr pattern--relation=pattern Check relations matching the specified pattern, unless they are otherwise excluded. This option can be specified more than once. Patterns may be unqualified, e.g.… pg_amcheck --rootdescendCommand-line ToolsPG18pg_amcheck › Optionsrootdescend For each index checked, re-find tuples on the leaf level by performing a new search from the root page for each tuple using amcheck's rootdescend option. Use of this option impli… pg_amcheck --schema=patternCommand-line ToolsPG18pg_amcheck › Optionss pattern--schema=pattern Check tables and indexes in schemas matching the specified pattern, unless they are otherwise excluded. This option can be specified more than once. To select only … pg_amcheck --skip=optionCommand-line ToolsPG18pg_amcheck › Optionsskip=option If all-frozen is given, table corruption checks will skip over pages in all tables that are marked as all frozen. If all-visible is given, table corruption checks will skip over … pg_amcheck --startblock=blockCommand-line ToolsPG18pg_amcheck › Optionsstartblock=block Start checking at the specified block number. An error will occur if the table relation being checked has fewer than this number of blocks. This option does not apply to ind… pg_amcheck --table=patternCommand-line ToolsPG18pg_amcheck › Optionst pattern--table=pattern Check tables matching the specified pattern, unless they are otherwise excluded. This option can be specified more than once. This is similar to the --relation optio… pg_amcheck --username=usernameCommand-line ToolsPG18pg_amcheck › OptionsU--username=username User name to connect as. pg_amcheck --verboseCommand-line ToolsPG18pg_amcheck › Optionsv--verbose Print more messages. In particular, this will print a message for each relation being checked, and will increase the level of detail shown for server errors. pg_amcheck --versionCommand-line ToolsPG18pg_amcheck › OptionsV--version Print the pg_amcheck version and exit. pg_amopManual ChaptersPG18The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that is a member of an operator family. A family me… pg_amprocManual ChaptersPG18The catalog pg_amproc stores information about support functions associated with access method operator families. There is one row for each support function belonging to an operator family. … pg_analyticsExtensionsExtensionsAnalytics · ExtensionsPostgres for analytics, powered by DuckDB duckdb pgrx pg_analytics Analytics pg_archivecleanupManual ChaptersPG18clean up PostgreSQL WAL archive files Synopsis pg_archivecleanup [option...] archivelocation oldestkeptwalfile pg_argon2idExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension for Argon2id password hashing functions pg_argon2id Security pg_array_multi_indexExtensionsExtensionsFunctions and aggregates · Extensionssimultaneous multiple-indexing of PostgreSQL arrays array function indexing pg_array_multi_index Functions and aggregates pg_ascii_movieExtensionsExtensionsFeatures · Extensionspg ascii movie is a PostgreSQL extension to watch ascii movies. ascii-movies plpgsql postgresql-extension pg_ascii_movie Features pg_askExtensionsExtensionsAI and vectors · ExtensionsPostgres Extension which uses AI to create SQL from Natural language. pg_ask AI and vectors pg_asyncExtensionsExtensionsFeatures · ExtensionsC extension that provides async LISTEN/NOTIFY queue support on PostgreSQL replicas in hot standby. async listen-notify queue shared-preload pg_async Features pg_attrdefManual ChaptersPG18The catalog pg_attrdef stores column default expressions and generation expressions. The main information about columns is stored in pg_attribute. Only columns for which a default expression… pg_attributeManual ChaptersPG18The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row for every column in every table in the database. (There will also be attribute ent… pg_auditExtensionsExtensionsSecurity · ExtensionsAn extension for creating audit tables audit history trigger pg_audit Security pg_audit_toolsExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension for audit tables management pg_audit_tools Security pg_auditorExtensionsExtensionsSecurity · ExtensionsAudit data changes and provide flashback ability pg_auditor Security pg_auth_membersManual ChaptersPG18The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed. Because user identities are cluster-wide, pg_auth_members is share… pg_auth_monExtensionsExtensionsSecurity · Extensionsmonitor connection attempts per user pg_auth_mon Security pg_authidManual ChaptersPG18The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of “users” and “groups”. A user is essentially just a role with the … pg_available_extension_versionsManual ChaptersPG18The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the pg_extension catalog, which shows the extensions currently in…