PostgreSQL is completely self-independent, does not write junk information to the system, and does not rely on the registry!
- Initdb.exe initializes the system database Postgres, template database template0, template1, and database cluster. It is understood as a storage directory!
- Pg_ctl.exe is a basic server management tool.
- Postgres.exe ServerProgram
PostgreSQL server configuration: PostgreSQL. conf
- The configuration file is in the-d directory.
- You can include other configuration files by using include [=] 'filename' to facilitate management and expansion-absolute and relative file paths
- The configuration options are case insensitive.
- "#" Indicates comment
- "=" Between configuration options and values is optional. Blank space can increase readability!
- There are only four types of values: integer, floating point number, string, and Boolean value (true, false, on, off; yes, no; 1, 0 can be used. You can also use the name value starting with them. Then sq will ignore the latter)
- The size can be measured in KB, MB, or GB. The time can be measured in D (day), H (hour), and min (minute), S (second), Ms (millinsecond)
- Some options take effect after modifying PostgreSQL. conf through pg_ctl reload; some options must restart the service.
- You can also specify options from the command line. This setting overwrites the configuration of the command line and option files. Note: This option changes the option to read-only and cannot be adjusted through the PostgreSQL. conf option file.
- You can also set different options for the needle Database: Alter database this setting will overwrite the configuration of the command line and option File
- You can also set different options for the user: Alter user. This setting overwrites the configuration of the database, command line, and option file.
- The options for each session can be set separately: set this setting will overwrite any other settings!
- Display options: show command; pg_settings virtual table
