Shulou(Shulou.com)06/01 Report--

1. PostgreSQL parameter type

All the configuration items of system parameters in PostgreSQL system are not sensitive to size, such as Bool, Int, floating point number, string and enumerated value.

Some parameters need to be restarted, some ordinary users modify them directly, and some super users need to modify them to take effect. They can be divided into the following categories:

1. Internal: read-only parameter, which is already written and cannot be modified.

2. Postmaster: you need to restart the database to take effect.

3. Sighup: no need to restart the database. Send sighup signal to the postmaster process to take effect.

4. Backend: you do not need to restart the database and send sighup signals to the postmaster process to take effect, but for clients that are already connected, you need to disconnect and reconnect to take effect.

5. Superuser: there is no need to restart the database, and the super user can set it through the set command.

6. User: there is no need to restart the database. You can set it through the set command.

You can view the description and type of the parameters by querying the pg_setting table

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.