| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-novice(at)lists(dot)postgresql(dot)org,nikhil raj <nikhilraj474(at)gmail(dot)com>,pgsql-general(at)postgresql(dot)org,pgsql-advocacy(at)postgresql(dot)org,pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: A particular database to move to other drive |
| Date: | 2017-11-26 11:27:03 |
| Message-ID: | 5D19429F-4AF2-4CFC-B7E8-258B95B59C3C@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-general pgsql-novice |
On 25 November 2017 21:13:22 GMT+01:00, nikhil raj <nikhilraj474(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2017-11-27 19:27:48 | Re: Migration to PGLister - After |
| Previous Message | nikhil raj | 2017-11-25 20:13:22 | A particular database to move to other drive |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Guerra | 2017-11-26 14:11:21 | Error installing PostgreSQL 8.3 (password short, not complex) |
| Previous Message | Justin Pryzby | 2017-11-26 00:53:28 | Re: backends stuck in "startup" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2017-11-26 15:18:53 | Re: Roles and security |
| Previous Message | John R Pierce | 2017-11-25 23:15:03 | Re: Roles and security |