From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: A particular database to move to other drive
Date: Mon, 27 Nov 2017 11:15:05 +0100
Message-ID: <ovgoj2$nnb$1@blaine.gmane.org> (raw)
In-Reply-To: <20171127093544.lgap7swy2zcpykvx@office.hexack.fr>
References: <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
<20171127093544.lgap7swy2zcpykvx@office.hexack.fr>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: spam_eater@gmx.net
Subject: Re: A particular database to move to other drive
In-Reply-To: <ovgoj2$nnb$1@blaine.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox