The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database

An alternative backup strategy is to directly copy the files that PostgreSQL uses to store the data in the database;

NameCREATE AGGREGATE -- define a new aggregate function Synopsis

This section describes functions and operators for examining and manipulating string values. Strings in this context include values of the types character

NameCOMMIT PREPARED -- commit a transaction that was earlier prepared for two-phase commit

NameCREATE TEXT SEARCH DICTIONARY -- define a new text search dictionary Synopsis

NameBEGIN -- start a transaction block Synopsis

19.8.1. Where To Log log_destination (string)

There are several ways to shut down the database server. You control the type of shutdown by sending different signals to the master postgres process

An index can support only one collation per index column. If multiple collations are of interest, multiple indexes may be needed. Consider these