Re: A particular database to move to other drive

Поиск
Список
Период
Сортировка
От Devrim Gündüz
Тема Re: A particular database to move to other drive
Дата
Msg-id 1511777927.30710.8.camel@gunduz.org
обсуждение исходный текст
Ответ на A particular database to move to other drive  (nikhil raj <nikhilraj474@gmail.com>)
Ответы Re: A particular database to move to other drive  (nikhil raj <nikhilraj474@gmail.com>)
Список pgsql-admin
Hi,

On Sun, 2017-11-26 at 01:08 +0530, nikhil raj wrote:
> I want to move a database to 'Y drive' because the size of that database is
> large about so can I move only that database to because I got an alert of
> low space is there any way
> Currently it is on F drive I want to move to Y drive .

First, create a new tablespace on Y drive:

https://www.postgresql.org/docs/current/static/sql-createtablespace.html

Then, move the database to that tablespace:

ALTER DATABASE dbname SET TABLESPACE to new_tablespace_name;

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

В списке pgsql-admin по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: A particular database to move to other drive
Следующее
От: Azimuddin Mohammed
Дата:
Сообщение: Moving hadoop metadata from Oracle to Postgres