pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Abhishek Gautam <abhishekgautam009@gmail.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: 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 15:23:45 +0530
Message-ID: <C3081A36-59E7-486A-B207-E5BD0927CBE2@gmail.com> (raw)
In-Reply-To: <CAGDYbUM6vGYM19wenx7tMOdjr8nuzZHGegFBaeuWCBdo04R3vA@mail.gmail.com>
References: <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com>
	<CAGDYbUM6vGYM19wenx7tMOdjr8nuzZHGegFBaeuWCBdo04R3vA@mail.gmail.com>

Hi,

May be creating new tablespace on new drives and then changing db tablespace from default to new one.

Beware there would be physical movement of data.

Haven’t done this for whole db but should work.

Sent from iPhone

Cheers,
Abhishek Gautam

> On 27-Nov-2017, at 2:35 PM, Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:
> 
> 
> 
>> On Sun, Nov 26, 2017 at 1:08 AM, nikhil raj <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.
> 
> -- 
> 

view thread (10+ messages)  latest in thread

Message-ID: <C3081A36-59E7-486A-B207-E5BD0927CBE2@gmail.com>
Permalink:  ../C3081A36-59E7-486A-B207-E5BD0927CBE2@gmail.com/
Also on:    postgresql.org/message-id/C3081A36-59E7-486A-B207-E5BD0927CBE2@gmail.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: abhishekgautam009@gmail.com, shreeyansh2014@gmail.com, nikhilraj474@gmail.com
  Subject: Re: A particular database to move to other drive
  In-Reply-To: <C3081A36-59E7-486A-B207-E5BD0927CBE2@gmail.com>
  References: <CAG1ps1yfrgyjyWkOgwUxriEFO4vmwt8CBJ6eJoTQ_Kg9qxp2Vg@mail.gmail.com> <CAGDYbUM6vGYM19wenx7tMOdjr8nuzZHGegFBaeuWCBdo04R3vA@mail.gmail.com> <C3081A36-59E7-486A-B207-E5BD0927CBE2@gmail.com>

* 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