Search PostgreSQL documentation

PGREQUIRESSLCommand-line ToolsPG18PGREQUIRESSL behaves the same as the requiressl connection parameter. This environment variable is deprecated in favor of the PGSSLMODE variable; setting both variables suppresses the effect…Environment Variables PGSERVICECommand-line ToolsPG18PGSERVICE behaves the same as the service connection parameter.Environment Variables PGSERVICEFILECommand-line ToolsPG18PGSERVICEFILE specifies the name of the per-user connection service file (see Section 32.17). Defaults to ~/.pg_service.conf, or %APPDATA%\postgresql\.pg_service.conf on Microsoft Windows.Environment Variables PGSSLCERTCommand-line ToolsPG18PGSSLCERT behaves the same as the sslcert connection parameter.Environment Variables PGSSLCERTMODECommand-line ToolsPG18PGSSLCERTMODE behaves the same as the sslcertmode connection parameter.Environment Variables PGSSLCOMPRESSIONCommand-line ToolsPG18PGSSLCOMPRESSION behaves the same as the sslcompression connection parameter.Environment Variables PGSSLCRLCommand-line ToolsPG18PGSSLCRL behaves the same as the sslcrl connection parameter.Environment Variables PGSSLCRLDIRCommand-line ToolsPG18PGSSLCRLDIR behaves the same as the sslcrldir connection parameter.Environment Variables PGSSLKEYCommand-line ToolsPG18PGSSLKEY behaves the same as the sslkey connection parameter.Environment Variables PGSSLMAXPROTOCOLVERSIONCommand-line ToolsPG18PGSSLMAXPROTOCOLVERSION behaves the same as the ssl_max_protocol_version connection parameter.Environment Variables PGSSLMINPROTOCOLVERSIONCommand-line ToolsPG18PGSSLMINPROTOCOLVERSION behaves the same as the ssl_min_protocol_version connection parameter.Environment Variables PGSSLMODECommand-line ToolsPG18PGSSLMODE behaves the same as the sslmode connection parameter.Environment Variables PGSSLNEGOTIATIONCommand-line ToolsPG18PGSSLNEGOTIATION behaves the same as the sslnegotiation connection parameter.Environment Variables PGSSLROOTCERTCommand-line ToolsPG18PGSSLROOTCERT behaves the same as the sslrootcert connection parameter.Environment Variables PGSSLSNICommand-line ToolsPG18PGSSLSNI behaves the same as the sslsni connection parameter.Environment Variables PGSYSCONFDIRCommand-line ToolsPG18PGSYSCONFDIR sets the directory containing the pg_service.conf file and in a future version possibly other system-wide configuration files.Environment Variables PGTARGETSESSIONATTRSCommand-line ToolsPG18PGTARGETSESSIONATTRS behaves the same as the target_session_attrs connection parameter.Environment Variables PGTZCommand-line ToolsPG18PGTZ sets the default time zone. (Equivalent to SET timezone TO ....)Environment Variables PGUSERCommand-line ToolsPG18PGUSER behaves the same as the user connection parameter.Environment Variables portCommand-line ToolsPG18port Port number to connect to at the server host, or socket file name extension for Unix-domain connections. If multiple hosts were given in the host or hostaddr parameters, this parameter …Database Connection Control Functions › Parameter Key Words postgresCommand-line ToolsPG18postgres postgres — PostgreSQL database server Synopsis postgres [option...]postgres postgres --describe-configCommand-line ToolsPG18--describe-config This option dumps out the server's internal configuration variables, descriptions, and defaults in tab-delimited COPY format. It is designed primarily for use by administra…postgres › Options › General Purpose postgres --helpCommand-line ToolsPG18-?--help Show help about postgres command line arguments, and exit.postgres › Options › General Purpose postgres --name=valueCommand-line ToolsPG18--name=value Sets a named run-time parameter; a shorter form of -c.postgres › Options › General Purpose postgres --singleCommand-line ToolsPG18--single Selects the single-user mode. This must be the first argument on the command line.postgres › Options › Options for Single-User Mode postgres --versionCommand-line ToolsPG18-V--version Print the postgres version and exit.postgres › Options › General Purpose postgres -B nbuffersCommand-line ToolsPG18-B nbuffers Sets the number of shared buffers for use by the server processes. The default value of this parameter is chosen automatically by initdb. Specifying this option is equivalent to …postgres › Options › General Purpose postgres -C nameCommand-line ToolsPG18-C name Prints the value of the named run-time parameter, and exits. (See the -c option above for details.) This returns values from postgresql.conf, modified by any parameters supplied in t…postgres › Options › General Purpose postgres -c name=valueCommand-line ToolsPG18-c name=value Sets a named run-time parameter. The configuration parameters supported by PostgreSQL are described in Chapter 19. Most of the other command line options are in fact short form…postgres › Options › General Purpose postgres -D datadirCommand-line ToolsPG18-D datadir Specifies the file system location of the database configuration files. See Section 19.2 for details.postgres › Options › General Purpose postgres -d debug-levelCommand-line ToolsPG18-d debug-level Sets the debug level. The higher this value is set, the more debugging output is written to the server log. Values are from 1 to 5. It is also possible to pass -d 0 for a spec…postgres › Options › General Purpose postgres -eCommand-line ToolsPG18-e Sets the default date style to “European”, that is DMY ordering of input date fields. This also causes the day to be printed before the month in certain date output formats. See Section 8…postgres › Options › General Purpose postgres -FCommand-line ToolsPG18-F Disables fsync calls for improved performance, at the risk of data corruption in the event of a system crash. Specifying this option is equivalent to disabling the fsync configuration par…postgres › Options › General Purpose postgres -h hostnameCommand-line ToolsPG18-h hostname Specifies the IP host name or address on which postgres is to listen for TCP/IP connections from client applications. The value can also be a comma-separated list of addresses, o…postgres › Options › General Purpose postgres -iCommand-line ToolsPG18-i Allows remote clients to connect via TCP/IP (Internet domain) connections. Without this option, only local connections are accepted. This option is equivalent to setting listen_addresses …postgres › Options › General Purpose postgres -jCommand-line ToolsPG18-j Use semicolon followed by two newlines, rather than just newline, as the command entry terminator.postgres › Options › Options for Single-User Mode postgres -k directoryCommand-line ToolsPG18-k directory Specifies the directory of the Unix-domain socket on which postgres is to listen for connections from client applications. The value can also be a comma-separated list of direct…postgres › Options › General Purpose postgres -lCommand-line ToolsPG18-l Enables secure connections using SSL. PostgreSQL must have been compiled with support for SSL for this option to be available. For more information on using SSL, refer to Section 18.9.postgres › Options › General Purpose postgres -N max-connectionsCommand-line ToolsPG18-N max-connections Sets the maximum number of client connections that this server will accept. The default value of this parameter is chosen automatically by initdb. Specifying this option i…postgres › Options › General Purpose postgres -OCommand-line ToolsPG18-O Allows the structure of system tables to be modified. This is used by initdb.postgres › Options › Semi-Internal Options