Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id EEED99FB7C9 for ; Sat, 12 May 2007 13:53:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 47854-07 for ; Sat, 12 May 2007 13:53:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229]) by postgresql.org (Postfix) with ESMTP id C82DB9FB6B5 for ; Sat, 12 May 2007 13:53:39 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i28so1111868wxd for ; Sat, 12 May 2007 09:53:39 -0700 (PDT) Received: by 10.70.48.11 with SMTP id v11mr7175713wxv.1178988819130; Sat, 12 May 2007 09:53:39 -0700 (PDT) Received: from srinilaptop ( [71.175.17.63]) by mx.google.com with ESMTP id h15sm10185676wxd.2007.05.12.09.53.38; Sat, 12 May 2007 09:53:38 -0700 (PDT) Reply-To: From: "Srinivas Kotapally" To: "'Linux Geeks'" , References: Subject: Re: Moving data directory Date: Sat, 12 May 2007 12:53:34 -0400 Organization: Coriendo LLC Message-ID: <026d01c794b6$14f29770$800101df@srinilaptop> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 In-Reply-To: Thread-Index: AceUtZ5Z5PjQ9aC5Q7OcpBt7CsQ5wAAAD9sg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.935 tagged_above=0 required=5 tests=AWL=1.120, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200705/99 X-Sequence-Number: 25419 You can do an initdb -d /var/lib/postgresql to initialize the data directory in the /var/lib/postgresql directory. If you also have data in the /usr/lib/postgresql - make sure you back it up and restore it in the new directory. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Linux Geeks Sent: Saturday, May 12, 2007 12:48 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] Moving data directory Hi All, I'm very new to postgresql and would like to move my data directory to another partition in Ubuntu. The standard installation is in /usr/lib/postgresql. How do I move it into /var/lib/postgresql. Regards, Dino -- To Analyze Is To Know Batte Field, Differ from Battle Itself ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly