Re: A particular database to move to other drive - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: A particular database to move to other drive
Date
Msg-id 5D19429F-4AF2-4CFC-B7E8-258B95B59C3C@a-kretschmer.de
Whole thread Raw
List pgsql-novice
On 25 November 2017 21:13:22 GMT+01:00, nikhil raj <nikhilraj474@gmail.com> wrote:
>Hi,
>Any one can please help me out
>
>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 .
>
>Thanks


You can create a new tablespace on that drive and move the db using alter database ...

Andreas

--
2ndQuadrant - The PostgreSQL Support Company


pgsql-novice by date:

Previous
From: Craig H
Date:
Subject: macOS ownership and premissions
Next
From: "Dale Schmitz"
Date:
Subject: Novice question about users and...rights?