Search PostgreSQL documentation

pg_ctl --core-filesCommand-line ToolsPG18pg_ctl › Optionsc--core-files Attempt to allow server crashes to produce core files, on platforms where this is possible, by lifting any soft resource limit placed on core files. This is useful in debugging… pg_ctl --helpCommand-line ToolsPG18pg_ctl › Options?--help Show help about pg_ctl command line arguments, and exit. pg_ctl --log=filenameCommand-line ToolsPG18pg_ctl › Optionsl filename--log=filename Append the server log output to filename. If the file does not exist, it is created. By default, only the cluster owner can access the log file. If group access is e… pg_ctl --mode=modeCommand-line ToolsPG18pg_ctl › Optionsm mode--mode=mode Specifies the shutdown mode. mode can be smart, fast, or immediate, or the first letter of one of these three. If this option is omitted, fast is the default. pg_ctl --no-waitCommand-line ToolsPG18pg_ctl › OptionsW--no-wait Do not wait for the operation to complete. This is the opposite of the option -w. If waiting is disabled, the requested action is triggered, but there is no feedback about its suc… pg_ctl --options=initdb-optionsCommand-line ToolsPG18pg_ctl › Optionso initdb-options--options=initdb-options Specifies options to be passed directly to the initdb command. -o can be specified multiple times, with all the given options being passed through. T… pg_ctl --options=optionsCommand-line ToolsPG18pg_ctl › Optionso options--options=options Specifies options to be passed directly to the postgres command. -o can be specified multiple times, with all the given options being passed through. The options s… pg_ctl --pgdata=datadirCommand-line ToolsPG18pg_ctl › OptionsD datadir--pgdata=datadir Specifies the file system location of the database configuration files. If this option is omitted, the environment variable PGDATA is used. pg_ctl --silentCommand-line ToolsPG18pg_ctl › Optionss--silent Print only errors, no informational messages. pg_ctl --timeout=secondsCommand-line ToolsPG18pg_ctl › Optionst seconds--timeout=seconds Specifies the maximum number of seconds to wait when waiting for an operation to complete (see option -w). Defaults to the value of the PGCTLTIMEOUT environment va… pg_ctl --versionCommand-line ToolsPG18pg_ctl › OptionsV--version Print the pg_ctl version and exit. pg_ctl --waitCommand-line ToolsPG18pg_ctl › Optionsw--wait Wait for the operation to complete. This is supported for the modes start, stop, restart, promote, and register, and is the default for those modes. When waiting, pg_ctl repeatedly c… pg_ctl -e sourceCommand-line ToolsPG18pg_ctl › Options › Options for Windowse source Name of the event source for pg_ctl to use for logging to the event log when running as a Windows service. The default is PostgreSQL. Note that this only controls messages sent from… pg_ctl -N servicenameCommand-line ToolsPG18pg_ctl › Options › Options for WindowsN servicename Name of the system service to register. This name will be used as both the service name and the display name. The default is PostgreSQL. pg_ctl -P passwordCommand-line ToolsPG18pg_ctl › Options › Options for WindowsP password Password for the user to run the service as. pg_ctl -p pathCommand-line ToolsPG18pg_ctl › Optionsp path Specifies the location of the postgres executable. By default the postgres executable is taken from the same directory as pg_ctl, or failing that, the hard-wired installation director… pg_ctl -S start-typeCommand-line ToolsPG18pg_ctl › Options › Options for WindowsS start-type Start type of the system service. start-type can be auto, or demand, or the first letter of one of these two. If this option is omitted, auto is the default. pg_ctl -U usernameCommand-line ToolsPG18pg_ctl › Options › Options for WindowsU username User name for the user to run the service as. For domain users, use the format DOMAIN\username. pg_curlExtensionsExtensionsUtilities · ExtensionsRun curl actions for data transfer in URL syntax pg_curl Utilities pg_cursorsManual ChaptersPG18The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways: via the DECLARE statement in SQL via the Bind message in the frontend/backend prot… pg_cuvsExtensionsExtensionsAI and vectors · Extensions⚡ Blazing-fast GPU vector search for PostgreSQL powered by NVIDIA cuVS. approximate-nearest-neighbor cuda cuvs gpu multi-tenant nvidia pgvector postgresql postgresql-extension rag similarity… pg_dagdbExtensionsExtensionsUtilities · ExtensionsPostgreSQL SQL client extension for the DagDB graph engine daemon. pgrx pg_dagdb Utilities pg_data_retentionExtensionsExtensionsAdministration · ExtensionsPostgreSQL background-worker extension that applies table data retention policies. background-worker data-retention pgrx pg_data_retention Administration pg_databaseManual ChaptersPG18The catalog pg_database stores information about the available databases. Databases are created with the CREATE DATABASE command. Consult Chapter 22 for details about the meaning of some of … pg_datasentinelExtensionsExtensionsMonitoring · ExtensionsObservability and activity monitoring extension for PostgreSQL pg_datasentinel Monitoring pg_datatype_passwordExtensionsExtensionsData types · ExtensionsSQL-only password data type and operators using pgcrypto Blowfish hashes, with trigger-based encryption before storage. encryption password pgcrypto type pg_datatype_password Data types pg_db_role_settingManual ChaptersPG18The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database combination. Unlike most system catalogs, pg_db_… pg_dbbackupExtensionsExtensionsAdministration · ExtensionsPer-database logical backup, recovery chains and scheduled restore tooling backup restore pitr pg_dbbackup Administration pg_dbms_errlogExtensionsExtensionsCompatibility · ExtensionsEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. oracle pg_dbms_errlog Compatibility pg_dbms_jobExtensionsExtensionsCompatibility · ExtensionsExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL oracle dep-break pg_dbms_job Compatibility pg_dbms_lockExtensionsExtensionsCompatibility · ExtensionsExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL oracle pg_dbms_lock Compatibility pg_dbms_metadataExtensionsExtensionsCompatibility · ExtensionsExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL oracle pg_dbms_metadata Compatibility pg_dbms_statsExtensionsExtensionsAdministration · ExtensionsStatistics management extension for stabilizing PostgreSQL execution plans using fixed statistics. plan-stability shared-preload statistics pg_dbms_stats Administration pg_dbo_timestampExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension for storing time and author of database structure modification. audit ddl event-trigger pg_dbo_timestamp Security pg_dbsmExtensionsExtensionsMonitoring · Extensionstrack database size pg_dbsm Monitoring pg_dbwaExtensionsExtensionsMonitoring · ExtensionsAnalyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. monitoring query-statistics workload-analysis pg_dbwa Monitoring pg_dctpExtensionsExtensionsSecurity · ExtensionsPreload-only module that blocks clear-text passwords in role DDL password security ddl-hook preload logging pg_dctp Security pg_ddl_commandData TypesPG18Pseudo-TypesIdentifies a representation of DDL commands that is available to event triggers. pg_debug_scanExtensionsExtensionsFeatures · ExtensionsDebug PostgreSQL table scans with custom MVCC snapshot definitions. pgrx pg_debug_scan Features pg_debyte_extExtensionsExtensionsUtilities · ExtensionsExample PostgreSQL extension for decoding bytea payloads to JSON using pg_debyte Rust crates. pgrx pg_debyte_ext Utilities