show default_tablespace ;

alter system set default_tablespace='tbs_msg_data' ;

select pg_reload_conf();

show default_tablespace



show temp_tablespaces ;

alter system set temp_tablespaces='temp' ;

select pg_reload_conf();

show temp_tablespaces

[PostgreSQL]Kill une session
[PostgreSQL] Déploiement d'un cluster PATRONI

Leave a Comment

Your email address will not be published. Required fields are marked *