Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WNmMj-0000rS-M3 for pgsql-admin@arkaria.postgresql.org; Wed, 12 Mar 2014 16:50:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WNmMi-0007VE-ND for pgsql-admin@arkaria.postgresql.org; Wed, 12 Mar 2014 16:50:48 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WNmMh-0007V7-F9 for pgsql-admin@postgresql.org; Wed, 12 Mar 2014 16:50:47 +0000 Received: from nm47.bullet.mail.ne1.yahoo.com ([98.138.120.54]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WNmMd-0003xZ-R4 for pgsql-admin@postgresql.org; Wed, 12 Mar 2014 16:50:46 +0000 Received: from [127.0.0.1] by nm47.bullet.mail.ne1.yahoo.com with NNFMP; 12 Mar 2014 16:50:42 -0000 Received: from [98.138.101.128] by nm47.bullet.mail.ne1.yahoo.com with NNFMP; 12 Mar 2014 16:47:48 -0000 Received: from [106.10.166.123] by tm16.bullet.mail.ne1.yahoo.com with NNFMP; 12 Mar 2014 16:47:47 -0000 Received: from [106.10.150.25] by tm12.bullet.mail.sg3.yahoo.com with NNFMP; 12 Mar 2014 16:47:47 -0000 Received: from [127.0.0.1] by omp1026.mail.sg3.yahoo.com with NNFMP; 12 Mar 2014 16:47:47 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 480352.96045.bm@omp1026.mail.sg3.yahoo.com Received: (qmail 36913 invoked by uid 60001); 12 Mar 2014 16:47:47 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1394642867; bh=3A43S7clZLwhJbRxMvQoXjWd9JTln0DF2CtZGYUOp9I=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=dZLn7y9gWZ7W8WH4tUokON7lz++sDM+C5R997Sy+UMv9WYspgYS/Bftqq6QvW3SqytJcqZiczLLfPPAla+BPG33bF6I0nlCeDhqBhkRR4AcWnq0DsKMcKUlt3fjioHqtys1HrOsvd5w+xuRnmiOJ6a4d6KFJvCkyLvKqOpFekuU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=cp6OOe2+nZTQ0hmXCZj2y67DOtwWFE5O26lvr6NJQ2iKy1MEl6GuXSOjZMqfzVYJfjGizzc1ZdmrfWL4hoMNM2fScaMp/wXyCmvT/tRwdyW0MqFRPOkSovBI34WydUq54rujnrDDhrU+7WVNZD01dp6jGmdQGTjb7VBq/RHNAUE=; X-YMail-OSG: b_W.ZjkVM1neXDpZcY3nncuMA0fua1_qfUtrMaG8vnvhCCx FLDM3woD5twrLqbc_AJl0IZ4kz3NShistXtv5xzIBNSsIWBaQqYPE_USbpu1 CP9iErDp2kvEiQKR_eWt1mp5BtesvosHeUo_93BB4chABPTHSJqrMGVHMIFT .aVaRxJL02vQBIghx0WjXvA3o4.DjnOaPVgsjEohoHO0NrePQzU98R9RbvDM xnSvw0xVQ6wTQ125cMMXvtiwygATTp6TeuHroXKrvO7ROuc4JHI5yGZ5X9TD mzBe.nzXFgtC.pKIF4UgGaC5gBtKvpd8uQcU4re0_0eMzupxbGGCRSGP2w96 LlmlifiR8g3_hIJO6OdxDRK9TpTOBJvCtsc8zHH22HFdRth7mXttIeFRa0pI W7U6krLF1XYm_Io94yrdqEYPa1GH.p3zrZMwpJvvOHD3fcBAdJETHL6x1tea .V_RAZEkLNf7cjZp5s8Yh2qcLVUt4R651try_tIp.yJXbMsXlwabBsKc.uj0 mfrVBZ6bMoQgqOYzeJq.qz3zoebsbZAaD0QE8fiIakXLdFxZvCLM83IKZKS0 - Received: from [49.205.13.57] by web193603.mail.sg3.yahoo.com via HTTP; Thu, 13 Mar 2014 00:47:47 SGT X-Rocket-MIMEInfo: 002.001, RWl0aGVyIHdheSBpcyBnb29kLiBZb3UgY2FuIGVpdGhlciBjcmVhdGUgc3ltbGlua3Mgb3IgbW92ZSBkYXRhIGRpcmVjdG9yeSB0byBuZXcgbW91bnQgcG9pbnQuIEJvdGggd2lsbCB3b3JrIGZpbmUuCllvdSBjYW4gYWxzbyB1c2UgdXNlIHBnX2N0bCAtRCB0byBwb2ludCB0byBuZXcgZGF0YV9kaXJlY3RvcnkuCgpSZWdhcmRzCkRoYW5hbmpheQpPcGVuU0NHCgoKCk9uIFdlZG5lc2RheSwgMTIgTWFyY2ggMjAxNCA5OjE1IFBNLCBLaWVyZW4gU2NvdHQgPGtpZXJlbnNjb3R0QGhvdG1haWwuY29tPiB3cm90ZToBMAEBAQE- X-Mailer: YahooMailWebService/0.8.177.636 References: Message-ID: <1394642867.32444.YahooMailNeo@web193603.mail.sg3.yahoo.com> Date: Thu, 13 Mar 2014 00:47:47 +0800 (SGT) From: Dhananjay Singh Reply-To: Dhananjay Singh Subject: Re: data_directory symlinks To: Kieren Scott , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="235919422-1939961915-1394642867=:32444" X-Pg-Spam-Score: 1.2 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --235919422-1939961915-1394642867=:32444 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Either way is good. You can either create symlinks or move data directory t= o new mount point. Both will work fine.=0AYou can also use use pg_ctl -D to= point to new data_directory.=0A=0ARegards=0ADhananjay=0AOpenSCG=0A=0A=0A= =0AOn Wednesday, 12 March 2014 9:15 PM, Kieren Scott wrote:=0A =0A =0AHi=0A=0ABy default pg_createcluster will create a new = cluster in=A0/var/lib/postgresql//=0A=0AI wan't to move m= y data_directory from this location to another volume (with lots more space= ). Is it best practice to set the data_directory location --datadir with pg= _createcluster, or to just move the data_directory contents to the new volu= me and then create a symbolic link (as postgres) from=A0/var/lib/postgresql= // to the new volume? This seems to be essentially the same thing,= but I wondered if there were any gotcha's with using symbolic links in thi= s way=A0(e.g. if we tried to run multiple clusters on one host), rather tha= n specifying the data_directory at pg_createcluster time - which subsequent= ly sets this parameter in the postgresql.conf?=0A=0AUbuntu Trusty=0Apg 9.3= =0A=0AThanks in advance! --235919422-1939961915-1394642867=:32444 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Either way is good. You can either create symlinks= or move data directory to new mount point. Both will work fine.
You can also use use pg_ct= l -D to point to new data_directory.

Regards
Dhana= njay
OpenSCG


On Wednesday, 12 March 2014 9:15 PM, Kieren Sco= tt <kierenscott@hotmail.com> wrote:
=0A=0A=0A
Hi

By = default pg_createcluster will create a new cluster in /var/lib/postgre= sql/<version>/<cluster>

I wan't to mov= e my data_directory from this location to another volume (with lots more sp= ace). Is it best practice to set the data_directory location --datadir with= pg_createcluster, or to just move the data_directory contents to the new v= olume and then create a symbolic link (as postgres) from /var/lib/postgresql/<version>/ to the new volume= ? This seems to be essentially the same thing, but I wondered if there were= any gotcha's with using symbolic links in this way (e.g. if we tried to run multiple clusters on one host= ), rather than specifying the data_d= irectory at pg_createcluster time - which subsequently sets this parameter = in the postgresql.conf?

Ubuntu Trusty
p= g 9.3

Thanks in advance!
=09=09 =09 =09=09=
=0A


<= /html> --235919422-1939961915-1394642867=:32444--