Search PostgreSQL documentation

pg_dumpall --no-toast-compressionCommand-line ToolsPG18--no-toast-compression Do not output commands to set TOAST compression methods. With this option, all columns will be restored with the default compression setting.pg_dumpall › Options pg_dumpall --no-unlogged-table-dataCommand-line ToolsPG18--no-unlogged-table-data Do not dump the contents of unlogged tables. This option has no effect on whether or not the table definitions (schema) are dumped; it only suppresses dumping the ta…pg_dumpall › Options pg_dumpall --on-conflict-do-nothingCommand-line ToolsPG18--on-conflict-do-nothing Add ON CONFLICT DO NOTHING to INSERT commands. This option is not valid unless --inserts or --column-inserts is also specified.pg_dumpall › Options pg_dumpall --passwordCommand-line ToolsPG18-W--password Force pg_dumpall to prompt for a password before connecting to a database. This option is never essential, since pg_dumpall will automatically prompt for a password if the serve…pg_dumpall › Options pg_dumpall --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections. Defaults to the PGPORT environment variable, if set, or…pg_dumpall › Options pg_dumpall --quote-all-identifiersCommand-line ToolsPG18--quote-all-identifiers Force quoting of all identifiers. This option is recommended when dumping a database from a server whose PostgreSQL major version is different from pg_dumpall's, or w…pg_dumpall › Options pg_dumpall --restrict-key=restrict_keyCommand-line ToolsPG18--restrict-key=restrict_key Use the provided string as the psql \restrict key in the dump output. If no restrict key is specified, pg_dumpall will generate a random one as needed. Keys may c…pg_dumpall › Options pg_dumpall --role=rolenameCommand-line ToolsPG18--role=rolename Specifies a role name to be used to create the dump. This option causes pg_dumpall to issue a SET ROLE rolename command after connecting to the database. It is useful when th…pg_dumpall › Options pg_dumpall --roles-onlyCommand-line ToolsPG18-r--roles-only Dump only roles, no databases or tablespaces.pg_dumpall › Options pg_dumpall --rows-per-insert=nrowsCommand-line ToolsPG18--rows-per-insert=nrows Dump data as INSERT commands (rather than COPY). Controls the maximum number of rows per INSERT command. The value specified must be a number greater than zero. Any e…pg_dumpall › Options pg_dumpall --schema-onlyCommand-line ToolsPG18-s--schema-only Dump only the object definitions (schema), not data.pg_dumpall › Options pg_dumpall --sequence-dataCommand-line ToolsPG18--sequence-data Include sequence data in the dump. This is the default behavior except when --no-data, --schema-only, or --statistics-only is specified.pg_dumpall › Options pg_dumpall --statisticsCommand-line ToolsPG18--statistics Dump optimizer statistics.pg_dumpall › Options pg_dumpall --statistics-onlyCommand-line ToolsPG18--statistics-only Dump only the statistics, not the schema (data definitions) or data. Optimizer statistics for tables, materialized views, foreign tables, and indexes are dumped.pg_dumpall › Options pg_dumpall --superuser=usernameCommand-line ToolsPG18-S username--superuser=username Specify the superuser user name to use when disabling triggers. This is relevant only if --disable-triggers is used. (Usually, it's better to leave this out, …pg_dumpall › Options pg_dumpall --tablespaces-onlyCommand-line ToolsPG18-t--tablespaces-only Dump only tablespaces, no databases or roles.pg_dumpall › Options pg_dumpall --use-set-session-authorizationCommand-line ToolsPG18--use-set-session-authorization Output SQL-standard SET SESSION AUTHORIZATION commands instead of ALTER OWNER commands to determine object ownership. This makes the dump more standards compa…pg_dumpall › Options pg_dumpall --username=usernameCommand-line ToolsPG18-U username--username=username User name to connect as.pg_dumpall › Options pg_dumpall --verboseCommand-line ToolsPG18-v--verbose Specifies verbose mode. This will cause pg_dumpall to output start/stop times to the dump file, and progress messages to standard error. Repeating the option causes additional de…pg_dumpall › Options pg_dumpall --versionCommand-line ToolsPG18-V--version Print the pg_dumpall version and exit.pg_dumpall › Options pg_isreadyCommand-line ToolsPG18pg_isready pg_isready — check the connection status of a PostgreSQL server Synopsis pg_isready [connection-option...] [option...]pg_isready pg_isready --dbname=dbnameCommand-line ToolsPG18-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 command li…pg_isready › Options pg_isready --helpCommand-line ToolsPG18-?--help Show help about pg_isready command line arguments, and exit.pg_isready › Options pg_isready --host=hostnameCommand-line ToolsPG18-h hostname--host=hostname Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix-domain socket.pg_isready › Options pg_isready --port=portCommand-line ToolsPG18-p port--port=port Specifies the TCP port or the local Unix-domain socket file extension on which the server is listening for connections. Defaults to the value of the PGPORT environment var…pg_isready › Options pg_isready --quietCommand-line ToolsPG18-q--quiet Do not display status message. This is useful when scripting.pg_isready › Options pg_isready --timeout=secondsCommand-line ToolsPG18-t seconds--timeout=seconds The maximum number of seconds to wait when attempting connection before returning that the server is not responding. Setting to 0 disables. The default is 3 secon…pg_isready › Options pg_isready --username=usernameCommand-line ToolsPG18-U username--username=username Connect to the database as the user username instead of the default.pg_isready › Options pg_isready --versionCommand-line ToolsPG18-V--version Print the pg_isready version and exit.pg_isready › Options pg_receivewalCommand-line ToolsPG18pg_receivewal pg_receivewal — stream write-ahead logs from a PostgreSQL server Synopsis pg_receivewal [option...]pg_receivewal pg_receivewal --compress=method[:detail]Command-line ToolsPG18-Z level-Z method[:detail]--compress=level--compress=method[:detail] Enables compression of write-ahead logs. The compression method can be set to gzip, lz4 (if PostgreSQL was compiled with …pg_receivewal › Options pg_receivewal --create-slotCommand-line ToolsPG18--create-slot Create a new physical replication slot with the name specified in --slot, then exit.pg_receivewal › Options pg_receivewal --dbname=connstrCommand-line ToolsPG18-d connstr--dbname=connstr Specifies parameters used to connect to the server, as a connection string; these will override any conflicting command line options. This option is called --dbnam…pg_receivewal › Options pg_receivewal --directory=directoryCommand-line ToolsPG18-D directory--directory=directory Directory to write the output to. This parameter is required.pg_receivewal › Options pg_receivewal --drop-slotCommand-line ToolsPG18--drop-slot Drop the replication slot with the name specified in --slot, then exit.pg_receivewal › Options pg_receivewal --endpos=lsnCommand-line ToolsPG18-E lsn--endpos=lsn Automatically stop replication and exit with normal exit status 0 when receiving reaches the specified LSN. If there is a record with LSN exactly equal to lsn, the record …pg_receivewal › Options pg_receivewal --helpCommand-line ToolsPG18-?--help Show help about pg_receivewal command line arguments, and exit.pg_receivewal › Options pg_receivewal --host=hostCommand-line ToolsPG18-h host--host=host Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. The defaul…pg_receivewal › Options pg_receivewal --if-not-existsCommand-line ToolsPG18--if-not-exists Do not error out when --create-slot is specified and a slot with the specified name already exists.pg_receivewal › Options pg_receivewal --no-loopCommand-line ToolsPG18-n--no-loop Don't loop on connection errors. Instead, exit right away with an error.pg_receivewal › Options