Re: A particular database to move to other drive

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: A particular database to move to other drive
Date: 2017-11-27 10:15:05
Message-ID: ovgoj2$nnb$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim Gündüz 2017-11-27 10:18:47 Re: A particular database to move to other drive
Previous Message Abhishek Gautam 2017-11-27 09:53:45 Re: A particular database to move to other drive