Re: A particular database to move to other drive

Thanks a lot.

On Nov 27, 2017 3:49 PM, "Devrim Gündüz" <devrim(at)gunduz(dot)org> wrote:

>
> 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