Re: A particular database to move to other drive - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: A particular database to move to other drive
Date
Msg-id ovgoj2$nnb$1@blaine.gmane.org
Whole thread Raw
In response to Re: A particular database to move to other drive  (Stéphane KANSCHINE <stephane@hexack.fr>)
List pgsql-admin
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. 





pgsql-admin by date:

Previous
From: Abhishek Gautam
Date:
Subject: Re: A particular database to move to other drive
Next
From: Devrim Gündüz
Date:
Subject: Re: A particular database to move to other drive