Date: Mon, 27 Nov 2017 10:35:44 +0100
From: =?utf-8?B?U3TDqXBoYW5l?= KANSCHINE <stephane@hexack.fr>
To: nikhil raj <nikhilraj474@gmail.com>, pgsql-admin@postgresql.org
Subject: Re: A particular database to move to other drive
Message-ID: <20171127093544.lgap7swy2zcpykvx@office.hexack.fr>
References: 
 <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
Organization: HexACK
User-Agent: NeoMutt/20170113 (1.7.2)
Precedence: bulk

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@hexack.fr
  +33 6 64 31 72 52