Re: A particular database to move to other drive

From: Stéphane KANSCHINE <stephane(at)hexack(dot)fr>
To: nikhil raj <nikhilraj474(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: A particular database to move to other drive
Date: 2017-11-27 09:35:44
Message-ID: 20171127093544.lgap7swy2zcpykvx@office.hexack.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le dim. 26 nov., vers 01:08, nikhil raj exprimait :

> Hi,

Hey !

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

Just :
- shutdown your instance
- move data_directory to its new location
- upgrade data_directory to its new location in postgresql.conf
- restart your instance

Done.

Regards,
--
Stéphane KANSCHINE - http://www.hexack.fr./ - http://www.nuajik.com./
＠ stephane(at)hexack(dot)fr
 +33 6 64 31 72 52

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Abhishek Gautam 2017-11-27 09:53:45 Re: A particular database to move to other drive
Previous Message Shreeyansh Dba 2017-11-27 09:05:22 Re: A particular database to move to other drive