From: | nikhil raj <nikhilraj474(at)gmail(dot)com> |
---|---|
To: | Abhishek Gautam <abhishekgautam009(at)gmail(dot)com> |
Cc: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: A particular database to move to other drive |
Date: | 2017-11-27 10:54:33 |
Message-ID: | CAG1ps1zM0pWZpkqiAqpKuXWOFwS4_k_w_nYscZXcTFftY0fgSg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks a lot.
On Nov 27, 2017 3:23 PM, "Abhishek Gautam" <abhishekgautam009(at)gmail(dot)com>
wrote:
Hi,
May be creating new tablespace on new drives and then changing db
tablespace from default to new one.
Beware there would be physical movement of data.
Haven’t done this for whole db but should work.
Sent from iPhone
Cheers,
Abhishek Gautam
On 27-Nov-2017, at 2:35 PM, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> wrote:
On Sun, Nov 26, 2017 at 1:08 AM, 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
>
If we want to move a particular database from one drive to another drive
for this requires downtime. There are multiple options to move a database
like pg_dump & pg_restore or taking a physical copy, we may pick anyone
from these options depending on the size of the database.
--
[image: http://www.shreeyansh.com] <http://www.shreeyansh.com>
From | Date | Subject | |
---|---|---|---|
Next Message | Jakub Jedelský | 2017-11-27 11:16:49 | Clear FS caches after postgresql stops |
Previous Message | nikhil raj | 2017-11-27 10:53:44 | Re: A particular database to move to other drive |