From: Stéphane KANSCHINE <stephane@hexack.fr>
To: nikhil raj <nikhilraj474@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: A particular database to move to other drive
Date: Mon, 27 Nov 2017 10:35:44 +0100
Message-ID: <20171127093544.lgap7swy2zcpykvx@office.hexack.fr> (raw)
In-Reply-To: <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
References: <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
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
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: stephane@hexack.fr, nikhilraj474@gmail.com
Subject: Re: A particular database to move to other drive
In-Reply-To: <20171127093544.lgap7swy2zcpykvx@office.hexack.fr>
* 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