Search PostgreSQL documentation

OptionsManual ChaptersPG18Options -A authmethod--auth=authmethod # This option specifies the default authentication method for local users used in pg_hba.conf (host and local lines). See Section 20.1 for an overview …Options OptionsManual ChaptersPG18Options -c--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 …Options OptionsManual ChaptersPG18Options The following command-line options control the content and format of the output. -a--data-only Dump only the data, not the schema (data definitions) or statistics. -c--clean Emit SQL…Options OptionsManual ChaptersPG18Options -d dbname--dbname=dbname Specifies the name of the database to connect to. The dbname can be a connection string. If so, connection string parameters will override any conflicting co…Options OptionsManual ChaptersPG18Options The following command-line options control what is checked: -a--all Check all databases, except for any excluded via --exclude-database. -d pattern--database=pattern Check databases …Options OptionsManual ChaptersPG18Options The following command-line options control the location and format of the output: -D directory--pgdata=directory Sets the target directory to write the output to. pg_basebackup will …Options OptionsManual ChaptersPG18Options The following command-line options are available: -D directory--pgdata=directory Specifies the directory where the database cluster is stored. -c--check Checks checksums. This is the…Options OptionsManual ChaptersPG18Options -d--debug Print lots of debug logging output on stderr. -k--link Use hard links instead of copying files to the synthetic backup. Reconstruction of the synthetic backup might be fast…Options OptionsManual ChaptersPG18Options To use pg_config, supply one or more of the following options: --bindir Print the location of user executables. Use this, for example, to find the psql program. This is normally also…Options OptionsManual ChaptersPG18Options pg_createsubscriber accepts the following command-line arguments: -a--all Create one subscription per database on the target server. Exceptions are template databases and databases t…Options OptionsManual ChaptersPG18Options The following command-line options control the content and format of the output. dbname Specifies the name of the database to be dumped. If this is not specified, the environment var…Options OptionsManual ChaptersPG18Options -D directory--directory=directory Directory to write the output to. This parameter is required. -E lsn--endpos=lsn Automatically stop replication and exit with normal exit status 0 w…Options OptionsManual ChaptersPG18Options At least one of the following options must be specified to select an action: --create-slot Create a new logical replication slot with the name specified by --slot, using the output p…Options OptionsManual ChaptersPG18Options datadir-D datadir--pgdata=datadir Specifies the location of the database directory. For safety reasons, you must specify the data directory on the command line. pg_resetwal does not …Options OptionsManual ChaptersPG18Options pg_restore accepts the following command line arguments. filename Specifies the location of the archive file (or directory, for a directory-format archive) to be restored. If not spe…Options OptionsManual ChaptersPG18Options pg_rewind accepts the following command-line arguments: -D directory--target-pgdata=directory This option specifies the target data directory that is synchronized with the source. Th…Options OptionsManual ChaptersPG18Options pg_verifybackup accepts the following command-line arguments: -e--exit-on-error Exit as soon as a problem with the backup is detected. If this option is not specified, pg_verifybacku…Options OptionsManual ChaptersPG18Options -i--individual By default, pg_walsummary prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation…Options OptionsManual ChaptersPG18Options postgres accepts the following command-line arguments. For a detailed discussion of the options consult Chapter 19. You can save typing most of these options by setting up a configur…Options OptionsManual ChaptersPG18Options -a--echo-all Print all nonempty input lines to standard output as they are read. (This does not apply to lines read interactively.) This is equivalent to setting the variable ECHO to…Options OptionsManual ChaptersPG18Options reindexdb accepts the following command-line arguments: -a--all Reindex all databases. --concurrently Use the CONCURRENTLY option. See REINDEX, where all the caveats of this option a…Options OptionsManual ChaptersPG18Options vacuumdb accepts the following command-line arguments: -a--all Vacuum all databases. --buffer-usage-limit size Specifies the Buffer Access Strategy ring buffer size for a given invoc…Options optionsCommand-line ToolsPG18options Specifies command-line options to send to the server at connection start. For example, setting this to -c geqo=off or --geqo=off sets the session's value of the geqo parameter to off…Database Connection Control Functions › Parameter Key Words OptionsManual ChaptersPG18Options oid2name accepts the following command-line arguments: -f filenode--filenode=filenode show info for table with filenode filenode. -i--indexes include indexes and sequences in the lis…Options OptionsManual ChaptersPG18Options pg_archivecleanup accepts the following command-line arguments: -b--clean-backup-history Remove backup history files as well. See Section 25.3.2 for details about backup history file…Options OptionsManual ChaptersPG18Options The following is divided into three subsections. Different options are used during database initialization and while running benchmarks, but some options are useful in both cases.Options OptionsManual ChaptersPG18Options pg_test_fsync accepts the following command-line options: -f--filename Specifies the file name to write test data in. This file should be in the same file system that the pg_wal dire…Options OptionsManual ChaptersPG18Options pg_test_timing accepts the following command-line options: -d duration--duration=duration Specifies the test duration, in seconds. Longer durations give slightly better accuracy, and…Options OptionsManual ChaptersPG18Options pg_upgrade accepts the following command-line arguments: -b bindir--old-bindir=bindir the old PostgreSQL executable directory; environment variable PGBINOLD -B bindir--new-bindir=bin…Options OptionsManual ChaptersPG18Options The following command-line options control the location and format of the output: startseg Start reading at the specified WAL segment file. This implicitly determines the path in whi…Options OptionsManual ChaptersPG18Options vacuumlo accepts the following command-line arguments: -l limit--limit=limit Remove no more than limit large objects per transaction (default 1000). Since the server acquires a lock …Options Options for PGP FunctionsManual ChaptersPG18F.26.3.8. Options for PGP Functions Options are named to be similar to GnuPG. An option's value should be given after an equal sign; separate options from each other with commas. For example…Options for PGP Functions Options for Single-User ModeManual ChaptersPG18Options for Single-User Mode The following options only apply to the single-user mode (see Single-User Mode below). --single Selects the single-user mode. This must be the first argument on …Options for Single-User Mode Options for WindowsManual ChaptersPG18Options for Windows -e 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 contro…Options for Windows optpathsExtensionsExtensionsPlanner hook extension for adding paths and removing self joins hook optimizer planner self-join anotherSelfJoin FeaturesFeatures · Extensions ora_btree_ginExtensionsExtensionsSupport for indexing oracle datatypes in GIN fork ivory ivorysql CompatibilityCompatibility · Extensions ora_btree_gistExtensionsExtensionsSupport for oracle indexing common datatypes in GiST fork ivory ivorysql CompatibilityCompatibility · Extensions ora_migratorExtensionsExtensionsTools to migrate Oracle databases to PostgreSQL etl migration oracle ora_migrator Replication and streamsReplication and streams · Extensions Oracle Compatibility ModeManual ChaptersPG1834.16. Oracle Compatibility Mode ecpg can be run in a so-called Oracle compatibility mode. If this mode is active, it tries to behave as if it were Oracle Pro*C. Specifically, this mode chan…Oracle Compatibility Mode oracle_fdwExtensionsExtensionsforeign data wrapper for Oracle access non-free oracle_fdw Foreign data wrappersForeign data wrappers · Extensions