From: Runge, Steven <Steven.Runge@mastercard.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
To: nikhil raj <nikhilraj474@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: RE: A particular database to move to other drive
Date: Mon, 27 Nov 2017 16:19:19 +0000
Message-ID: <d399731db4444bcd8c672b90334ddc4a@STL3MSX05.corp.mastercard.org> (raw)
In-Reply-To: <CAGDYbUM6vGYM19wenx7tMOdjr8nuzZHGegFBaeuWCBdo04R3vA@mail.gmail.com>
References: <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
<CAGDYbUM6vGYM19wenx7tMOdjr8nuzZHGegFBaeuWCBdo04R3vA@mail.gmail.com>
I believe you could use pg_repack to move your database to a new tablespace on your Y drive without downtime (minimal locking).
Steve Runge
Consultant
Database Engineering
from: Shreeyansh Dba [mailto:shreeyansh2014@gmail.com]
Sent: Monday, November 27, 2017 3:05 AM
To: nikhil raj <nikhilraj474@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: A particular database to move to other drive
On Sun, Nov 26, 2017 at 1:08 AM, nikhil raj <nikhilraj474@gmail.com<mailto:nikhilraj474@gmail.com>> wrote:
Hi,
Any one can please help me out
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 .
Thanks
If we want to move a particular database from one drive to another drive for this requires downtime. There are multiple options to move a database like pg_dump & pg_restore or taking a physical copy, we may pick anyone from these options depending on the size of the database.
--
[http://www.shreeyansh.com]<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.shreeyansh.com&d=DwMFaQ&c=uc5ZRXl8dG...;
CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for the use of the intended recipient and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attachments is prohibited. If you have received this e-mail message in error, please delete and notify the sender immediately. Thank you.
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: Steven.Runge@mastercard.com, shreeyansh2014@gmail.com, nikhilraj474@gmail.com
Subject: RE: A particular database to move to other drive
In-Reply-To: <d399731db4444bcd8c672b90334ddc4a@STL3MSX05.corp.mastercard.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