SHOW:
|
|
- or go back to the newest paste.
| 1 | ||
| 2 | - | # FILE LOCATIONS |
| 2 | + | |
| 3 | # CONNECTIONS AND AUTHENTICATION | |
| 4 | #------------------------------------------------------------------------------ | |
| 5 | - | data_directory = 'ConfigDir' # use data in another directory |
| 5 | + | |
| 6 | # - Connection Settings - | |
| 7 | - | hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file |
| 7 | + | |
| 8 | listen_addresses = 'localhost' # what IP address(es) to listen on; | |
| 9 | - | ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file |
| 9 | + | |
| 10 | # defaults to 'localhost'; use '*' for all | |
| 11 | # (change requires restart) | |
| 12 | #port = 5432 # (change requires restart) | |
| 13 | max_connections = 10 # (change requires restart) | |
| 14 | ||
| 15 | #------------------------------------------------------------------------------ | |
| 16 | # RESOURCE USAGE (except WAL) | |
| 17 | #------------------------------------------------------------------------------ | |
| 18 | ||
| 19 | # - Memory - | |
| 20 | ||
| 21 | shared_buffers = 24MB # min 128kB | |
| 22 | # (change requires restart) | |
| 23 | ||
| 24 | log_timezone = 'Asia/Kolkata' | |
| 25 | # - Locale and Formatting - | |
| 26 | ||
| 27 | datestyle = 'iso, mdy' | |
| 28 | #intervalstyle = 'postgres' | |
| 29 | timezone = 'Asia/Kolkata' | |
| 30 | #timezone_abbreviations = 'Default' # Select the set of available time zone | |
| 31 | # abbreviations. Currently, there are | |
| 32 | # Default | |
| 33 | # Australia | |
| 34 | # India | |
| 35 | # You can create your own file in | |
| 36 | # share/timezonesets/. | |
| 37 | ||
| 38 | # These settings are initialized by initdb, but they can be changed. | |
| 39 | lc_messages = 'en_IN' # locale for system error message | |
| 40 | # strings | |
| 41 | lc_monetary = 'en_IN' # locale for monetary formatting | |
| 42 | lc_numeric = 'en_IN' # locale for number formatting | |
| 43 | lc_time = 'en_IN' # locale for time formatting | |
| 44 | ||
| 45 | # default configuration for text search | |
| 46 | default_text_search_config = 'pg_catalog.english' |