DBA Hub

📋Steps in this guide1/1

find/change default temp tablespace

VIEW DEFAULT TEMP TABLESPACE: dbaclass=# SELECT name, setting FROM pg_settings where name='temp_tablespaces'; name | setting ------------------+--------- temp_tablespaces | (1 row)

postgresql configurationintermediate
by PostgreSQL
13 views
1

find/change default temp tablespace

VIEW DEFAULT TEMP TABLESPACE: dbaclass=# SELECT name, setting FROM pg_settings where name='temp_tablespaces'; name | setting ------------------+--------- temp_tablespaces | (1 row) CHANGE DEFAULT TEMP TABLESPACE

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
dbaclass=#
show temp_tablespaces
dbaclass-# ;
temp_tablespaces
------------------
(1 row)
postgres=#
alter system set temp_tablespaces=TS_TEMP;
ALTER SYSTEM
postgres=#
select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)
postgres=#
show temp_tablespaces;
temp_tablespaces
------------------
ts_temp
(1 row)
postgres=#
SELECT name, setting FROM pg_settings where name='temp_tablespaces';
name | setting
------------------+---------
temp_tablespaces | ts_temp
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!