292 18.4. Database Configuration .....293 18.5. Destroying a Database .....294 18.6. Tablespaces .....294 19. Client Authentication .....297 19.1. The pg_hba.conf file .....297 19 will automatically use the default tablespace of the current database. For more information on tablespaces, see Section 18.6. check_function_bodies (boolean) This parameter is normally true. When set is not the default action to drop the database with the current user name.) #### 18.6. Tablespaces Tablespaces in PostgreSQL allow database administrators to define locations in the file system where

447 Creating and Managing Tablespaces 448 Creating a Tablespace 448 Using a Tablespace to Store Database Objects 448 Viewing Existing Tablespaces 449 Dropping Tablespaces 450 Moving the Location of tcp_keepalives_count 1643 tcp_keepalives_idle 1643 tcp_keepalives_interval 1644 temp_buffers 1644 temp_tablespaces 1644 TimeZone 1645 timezone_abbreviations 1645 track_activities 1645 track_activity_query_size Resolved an issue where not all spill files were using the GUC temp_tablespaces. Now all spill files will use temp_tablespaces if set. 11307 Fixes Query Catalog Table errors when using targetlists

515 21.4. Database Configuration ..... 516 21.5. Destroying a Database ..... 517 21.6. Tablespaces ..... 517 22. Localization ..... 520 22.1. Locale Support ..... 520 22.1.1. Overview ... or creation attempts will fail. This variable is not used for temporary tables; for them, temp_tablespaces is consulted instead. This variable is also not used when creating databases. By default, a new database it is copied from. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespaces in which to create temporary objects (temp tables and

21.4. Database Configuration ..... 574 21.5. Destroying a Database ..... 575 21.6. Tablespaces ..... 575 22. Localization ..... 578 22.1. Locale Support ..... 578 22.1.1. Overview or creation attempts will fail. This variable is not used for temporary tables; for them, temp_tablespaces is consulted instead. This variable is also not used when creating databases. By default, a new database it is copied from. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespaces in which to create temporary objects (temp tables and

...605 21.4. Database Configuration .....607 21.5. Destroying a Database .....607 21.6. Tablespaces .....607 22. Localization .....610 22.1. Locale Support .....610 22.1.1. Overview .....610 or creation attempts will fail. This variable is not used for temporary tables; for them, temp_tablespaces is consulted instead. This variable is also not used when creating databases. By default, a new database it is copied from. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespaces in which to create temporary objects (temp tables and

21.4. Database Configuration ..... 473 21.5. Destroying a Database ..... 474 21.6. Tablespaces ..... 474 22. Localization.....477 22.1. Locale Support.....477 22.1.1. Overview.....477 not used for temporary tables; for them, temp_tablespaces is consulted instead. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespace(s) sorting large data sets are also created in these tablespace(s). The value is a list of names of tablespaces. When there is more than one name in the list, PostgreSQL chooses a random member of the list each

445 21.4. Database Configuration ..... 446 21.5. Destroying a Database ..... 447 21.6. Tablespaces ..... 447 22. Localization ..... 449 22.1. Locale Support ..... 449 22.1.1. Overview ... not used for temporary tables; for them, temp_tablespaces is consulted instead. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespace(s) sorting large data sets are also created in these tablespace(s). The value is a list of names of tablespaces. When there is more than one name in the list, PostgreSQL chooses a random member of the list each

21.4. Database Configuration ..... 507 21.5. Destroying a Database ..... 508 21.6. Tablespaces ..... 508 22. Localization ..... 511 22.1. Locale Support ..... 511 22.1.1. Overview or creation attempts will fail. This variable is not used for temporary tables; for them, temp_tablespaces is consulted instead. This variable is also not used when creating databases. By default, a new database it is copied from. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespaces in which to create temporary objects (temp tables and

...540 21.4. Database Configuration .....541 21.5. Destroying a Database .....542 21.6. Tablespaces .....542 22. Localization .....545 22.1. Locale Support .....545 22.1.1. Overview .....545 or creation attempts will fail. This variable is not used for temporary tables; for them, temp_tablespaces is consulted instead. This variable is also not used when creating databases. By default, a new database it is copied from. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespaces in which to create temporary objects (temp tables and

21.4. Database Configuration ..... 550 21.5. Destroying a Database ..... 551 21.6. Tablespaces ..... 551 22. Localization ..... 554 22.1. Locale Support ..... 554 22.1.1. Overview or creation attempts will fail. This variable is not used for temporary tables; for them, temp_tablespaces is consulted instead. This variable is also not used when creating databases. By default, a new database it is copied from. For more information on tablespaces, see Section 21.6. ## temp_tablespaces(string) This variable specifies tablespaces in which to create temporary objects (temp tables and