Search PostgreSQL documentation

initdb --no-data-checksumsCommand-line ToolsPG18--no-data-checksums Do not enable data checksums.initdb › Options initdb --no-instructionsCommand-line ToolsPG18--no-instructions By default, initdb will write instructions for how to start the cluster at the end of its output. This option causes those instructions to be left out. This is primarily in…initdb › Options initdb --no-localeCommand-line ToolsPG18--no-locale Equivalent to --locale=C.initdb › Options initdb --no-syncCommand-line ToolsPG18-N--no-sync By default, initdb will wait for all files to be written safely to disk. This option causes initdb to return without waiting, which is faster, but means that a subsequent operati…initdb › Options initdb --no-sync-data-filesCommand-line ToolsPG18--no-sync-data-files By default, initdb safely writes all database files to disk. This option instructs initdb to skip synchronizing all files in the individual database directories, the dat…initdb › Options initdb --pgdata=directoryCommand-line ToolsPG18-D directory--pgdata=directory This option specifies the directory where the database cluster should be stored. This is the only information required by initdb, but you can avoid writing it …initdb › Options initdb --pwfile=filenameCommand-line ToolsPG18--pwfile=filename Makes initdb read the bootstrap superuser's password from a file. The first line of the file is taken as the password.initdb › Options initdb --pwpromptCommand-line ToolsPG18-W--pwprompt Makes initdb prompt for a password to give the bootstrap superuser. If you don't plan on using password authentication, this is not important. Otherwise you won't be able to use…initdb › Options initdb --set name=valueCommand-line ToolsPG18-c name=value--set name=value Forcibly set the server parameter name to value during initdb, and also install that setting in the generated postgresql.conf file, so that it will apply during…initdb › Options initdb --showCommand-line ToolsPG18-s--show Show internal settings and exit, without doing anything else. This can be used to debug the initdb installation.initdb › Options initdb --sync-method=methodCommand-line ToolsPG18--sync-method=method When set to fsync, which is the default, initdb will recursively open and synchronize all files in the data directory. The search for files will follow symbolic links fo…initdb › Options initdb --sync-onlyCommand-line ToolsPG18-S--sync-only Safely write all database files to disk and exit. This does not perform any of the normal initdb operations. Generally, this option is useful for ensuring reliable recovery aft…initdb › Options initdb --text-search-config=configCommand-line ToolsPG18-T config--text-search-config=config Sets the default text search configuration. See default_text_search_config for further information.initdb › Options initdb --username=usernameCommand-line ToolsPG18-U username--username=username Sets the user name of the bootstrap superuser. This defaults to the name of the operating-system user running initdb.initdb › Options initdb --versionCommand-line ToolsPG18-V--version Print the initdb version and exit.initdb › Options initdb --wal-segsize=sizeCommand-line ToolsPG18--wal-segsize=size Set the WAL segment size, in megabytes. This is the size of each individual file in the WAL log. The default size is 16 megabytes. The value must be a power of 2 between 1…initdb › Options initdb --waldir=directoryCommand-line ToolsPG18-X directory--waldir=directory This option specifies the directory where the write-ahead log should be stored.initdb › Options initdb -L directoryCommand-line ToolsPG18-L directory Specifies where initdb should find its input files to initialize the database cluster. This is normally not necessary. You will be told if you need to specify their location exp…initdb › Options Initial Data SynchronizationManual ChaptersPG1829.4.5. Initial Data Synchronization If the subscription requires copying pre-existing table data and a publication contains WHERE clauses, only data that satisfies the row filter expression…Initial Data Synchronization Initial SnapshotManual ChaptersPG1829.9.1. Initial Snapshot The initial data in existing subscribed tables is snapshotted and copied in parallel instances of a special kind of apply process. These special apply processes are …Initial Snapshot Initialization FunctionManual ChaptersPG1847.6.1. Initialization Function An output plugin is loaded by dynamically loading a shared library with the output plugin's name as the library base name. The normal library search path is u…Initialization Function Initialization FunctionsManual ChaptersPG1849.1. Initialization Functions An archive library is loaded by dynamically loading a shared library with the archive_library's name as the library base name. The normal library search path i…Initialization Functions Initialization FunctionsManual ChaptersPG1850.2. Initialization Functions OAuth validator modules are dynamically loaded from the shared libraries listed in oauth_validator_libraries. Modules are loaded on demand when requested from …Initialization Functions Initialization OptionsManual ChaptersPG18Initialization Options pgbench accepts the following command-line initialization arguments: [-d] dbname[--dbname=]dbname # Specifies the name of the database to test in. If this is not speci…Initialization Options Injection PointsManual ChaptersPG1836.10.14. Injection Points An injection point with a given name is declared using macro: INJECTION_POINT(name, arg); There are a few injection points already declared at strategic points wit…Injection Points injection_pointsExtensionsExtensionsPostgres rewritten in Rust, now passing 100% of the Postgres regression tests ai-assisted-development database postgres postgresql rust injection_points FeaturesFeatures · Extensions InjectionPointWait EventsReferenceInjectionPoint LWLock 17 Waiting to read or update information related to injection points. 18 19 20 A brief sample is normal around short internal critical sections. Investigate when the sa…Wait Events · LWLock InliningManual ChaptersPG1830.1.2. Inlining PostgreSQL is very extensible and allows new data types, functions, operators and other database objects to be defined; see Chapter 36. In fact the built-in objects are impl…Inlining Inlining Support for ExtensionsManual ChaptersPG1830.4.1. Inlining Support for Extensions PostgreSQL's JIT implementation can inline the bodies of functions of types C and internal, as well as operators based on such functions. To do so for…Inlining Support for Extensions INSERTManual ChaptersPG18INSERT INSERT — create new rows in a table Synopsis [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ] [ OVERRIDING { SYSTEM | USER } V…INSERT INSERTSQL CommandsReferenceINSERT Queries & Data 10 create new rows in a table [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT INTO table_name [ AS alias ] [ ( column_name [, ...] ) ] [ OVERRIDING { SYSTEM | USER } V…SQL Commands · Queries & Data insert_arrayExtensionsExtensionsaggregates and functions for PostgreSQL Server aggregates c custom-aggregates extension functions postgresql postgresql-extension insert_array Functions and aggregatesFunctions and aggregates · Extensions insert_usernameExtensionsExtensionsfunctions for tracking who changed a table insert_username Functions and aggregatesFunctions and aggregates · Extensions insert_username — Functions for Tracking Who Changed a TableManual ChaptersPG18F.41.3. insert_username — Functions for Tracking Who Changed a Table insert_username() is a trigger that stores the current user's name into a text field. This can be useful for tracking who…insert_username — Functions for Tracking Who Changed a Table InsertingManual ChaptersPG18Inserting This section covers parameters that may be used when only inserting new rows. Parameters exclusively used with the ON CONFLICT clause are described separately. with_query The WITH …Inserting Inserting DataManual ChaptersPG186.1. Inserting Data When a table is created, it contains no data. The first thing to do before a database can be of much use is to insert data. Data is inserted one row at a time. You can al…Inserting Data Inspecting MCV ListsManual ChaptersPG189.31.1. Inspecting MCV Lists pg_mcv_list_items ( pg_mcv_list ) → setof record pg_mcv_list_items returns a set of records describing all items stored in a multi-column MCV list. It returns th…Inspecting MCV Lists InstallationManual ChaptersPG18F.40.2. Installation sepgsql can only be used on Linux 2.6.28 or higher with SELinux enabled. It is not available on any other platform. You will also need libselinux 2.1.10 or higher and se…Installation InstallationManual ChaptersPG181.1. Installation Before you can use PostgreSQL you need to install it, of course. It is possible that PostgreSQL is already installed at your site, either because it was included in your op…Installation Installation from BinariesManual ChaptersPG18Chapter 16. Installation from Binaries PostgreSQL is available in the form of binary packages for most common operating systems today. When available, this is the recommended way to install …Installation from Binaries