Re: A particular database to move to other drive

Andreas Kretschmer <[email protected]>
Newsgroups gmane.comp.db.postgresql.novice,gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.advocacy
Message-ID <[email protected]>
On 25 November 2017 21:13:22 GMT+01:00, nikhil raj <[email protected]> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.