Studio ODIN

PostgreSQL �Ńf�t�H���g�̕\�̈�̕ύX

PostgreSQL �ɂ̓f�[�^�x�[�X�̃f�t�H���g�̕\�̈悪����܂��B �e�[�u���Ȃǂ̃f�[�^�x�[�X�̃I�u�W�F�N�g���쐬����Ƃ��� �\�̈���w�肵�Ȃ���΁A���̃f�[�^�x�[�X�̃f�t�H���g�̕\�̈�ɍ쐬����܂��B

���̏ꍇ�A�f�[�^�x�[�X database1 �� tablespace1 �� �f�t�H���g�̕\�̈�Ƃ��Đݒ肵�Ă��܂��B

db=# \x
Expanded display is on.

db=# \l+
List of databases
-[ RECORD 1 ]-----+--------------------------
Name              | database1
Owner             | postgres
Encoding          | UTF8
Collation         | en_US.UTF-8
Ctype             | en_US.UTF-8
Access privileges |
Size              | 51 MB
Tablespace        | tablespace1
Description       |

���̃f�t�H���g�̕\�̈�̕ύX�ł��� PostgreSQL �� 8.4 ����� ALTER DATABASE ���� �s�����Ƃ��ł��܂��B

db=# ALTER DATABASE database1 SET TABLESPACE tablespace2;

����ŕ\�̈悪 tablespace2 �ɂȂ�܂��B

db=# \l+
List of databases
-[ RECORD 1 ]-----+--------------------------
Name              | database1
Owner             | postgres
Encoding          | UTF8
Collation         | en_US.UTF-8
Ctype             | en_US.UTF-8
Access privileges |
Size              | 51 MB
Tablespace        | tablespace2
Description       |

�f�[�^�x�[�X�N���X�^�̃f�t�H���g�̕\�̈�ɕύX����ꍇ�� ���̂悤�ɕ\�̈�� pg_default ���w�肵�܂��B

db=# ALTER DATABASE database1 SET TABLESPACE pg_default;

8.4 �܂ł� createdb �R�}���h���g���Ď��̂悤�� �ύX�����肵�Ă�����ł����A�o�[�W�����A�b�v�̓��e�� �ǂ������Ă����Ȃ��� �V�����o�[�W�������g���Ă郁���b�g������ł��Ȃ��ł��ˁB

$ createdb -T database1 -D pg_default database2;