To: pgsql-admin@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: A particular database to move to other drive
Date: Mon, 27 Nov 2017 11:15:05 +0100
Lines: 17
Message-ID: <ovgoj2$nnb$1@blaine.gmane.org>
References: 
 <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
 <20171127093544.lgap7swy2zcpykvx@office.hexack.fr>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
In-Reply-To: <20171127093544.lgap7swy2zcpykvx@office.hexack.fr>
Content-Language: de-DE
Precedence: bulk

Stéphane KANSCHINE schrieb am 27.11.2017 um 10:35:
>> 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.

Note that this moves all databases to the new drive, not just one.