Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eJGVr-0008Fc-Nh for pgsql-admin@arkaria.postgresql.org; Mon, 27 Nov 2017 10:19:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eJGVr-0005Pv-Aq for pgsql-admin@arkaria.postgresql.org; Mon, 27 Nov 2017 10:19:43 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eJGVq-0005Pk-Vk for pgsql-admin@lists.postgresql.org; Mon, 27 Nov 2017 10:19:43 +0000 Received: from ns5.gunduz.org ([107.170.136.15] helo=ns1.gunduz.org) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eJGVi-0003hM-N8 for pgsql-admin@postgresql.org; Mon, 27 Nov 2017 10:19:41 +0000 Received: from asus-laptop04.gunduz.org (unknown [81.128.234.18]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ns1.gunduz.org (Postfix) with ESMTPSA id B79BA3FD27; Mon, 27 Nov 2017 10:19:29 +0000 (UTC) Message-ID: <1511777927.30710.8.camel@gunduz.org> Subject: Re: A particular database to move to other drive From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= To: nikhil raj , pgsql-admin@postgresql.org Date: Mon, 27 Nov 2017 10:18:47 +0000 In-Reply-To: References: Content-Type: multipart/signed; micalg="pgp-sha256"; protocol="application/pgp-signature"; boundary="=-isYOORKAmaFUTTQ0vc29" X-Mailer: Evolution 3.26.2 (3.26.2-1.fc27) Mime-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=-isYOORKAmaFUTTQ0vc29 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, On Sun, 2017-11-26 at 01:08 +0530, nikhil raj wrote: > 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 . First, create a new tablespace on Y drive: https://www.postgresql.org/docs/current/static/sql-createtablespace.html Then, move the database to that tablespace: ALTER DATABASE dbname SET TABLESPACE to new_tablespace_name; Regards, --=20 Devrim G=C3=BCnd=C3=BCz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR --=-isYOORKAmaFUTTQ0vc29 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEEH8GKHNUOKtDEiyD22MM9/pLPbrUFAlob5ocACgkQ2MM9/pLP brVr2A//TdnfuGD0hjAU3S3t6fhnD0crQmK6n5HfkAKLeklbQHnzBv830uYZ8BWw BX1DOAXw5+cXnsIdjSKBWIJw1HT/Y+qgkwoKdgCdK7JLGZVEt1uZpp8JLwdk0Stf jYgC/2oi+/VDUiWKr0raP0/Gg8u5JyAO/rup7JZMgOX1q4p5RsRO3qLJX/D9VY8w YNiCGLXKojBd+QM+840LT0blroHITcy7HTt5ae5ovLvpmXXxsqSDb+OMas3y3BuJ 7NN2Elf3IBIYc88eQKVcLNRrWPNFIh+VebtPhuKSAqBZ9mjx9UT9u3CdFR5x4Pc6 zpsiXLBEQmUdFM2b5sDghcHRrg9Oj3oI9RIABtlZJD3PhwNicRdZk+S6nBJ2kmr6 LD9vLlWJ85spcuXZXaAgWVyNShyPFN0OTIa7mETAfoCZYy4O+N5CkIlvHhdS0vhx RXLSF5A74vMkTAZFET+se62CgUcwy/Mlg59DYPNJVxcofYoczUO57vCZDAKzih3g QmrZZ4+F0Ml4t7bUKOqrteq/IBORyDrl42S94aZJJM3a/PoatJEEYxDdl1LQiHF8 EpTna1eqqDX/C2DQZFkIVKPJeoP0CCkBQo59WiZmPqkENEMDyC54f1xpMfw/HNXf K7yWpZ5lwztWW9h/p8f0wvspsV9nw+W6pBKpHg18sUL+xjIn+10= =vodY -----END PGP SIGNATURE----- --=-isYOORKAmaFUTTQ0vc29--