Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 72B519FB302 for ; Sat, 12 May 2007 17:43:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 69451-01 for ; Sat, 12 May 2007 17:43:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id BD6E89FB300 for ; Sat, 12 May 2007 17:43:35 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i28so1142240wxd for ; Sat, 12 May 2007 13:43:34 -0700 (PDT) Received: by 10.70.39.5 with SMTP id m5mr7399099wxm.1179002614265; Sat, 12 May 2007 13:43:34 -0700 (PDT) Received: from srinilaptop ( [71.175.17.63]) by mx.google.com with ESMTP id h16sm10376699wxd.2007.05.12.13.43.33; Sat, 12 May 2007 13:43:33 -0700 (PDT) Reply-To: From: "Srinivas Kotapally" To: "'Linux Geeks'" , References: <026d01c794b6$14f29770$800101df@srinilaptop> Subject: Re: Moving data directory Date: Sat, 12 May 2007 16:43:29 -0400 Organization: Coriendo LLC Message-ID: <027701c794d6$32e921c0$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: AceUvxN9JEPNexu8QTGhlCK+uD1lYQAFmNCg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.711 tagged_above=0 required=5 tests=AWL=0.896, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200705/105 X-Sequence-Number: 25425 No this will permanently change it. Check out the documentation: http://www.postgresql.org/docs/8.2/interactive/server-start.html http://www.postgresql.org/docs/8.2/interactive/app-initdb.html Cheers Srinivas -----Original Message----- From: Linux Geeks [mailto:indolinux.geeks@gmail.com] Sent: Saturday, May 12, 2007 1:58 PM To: ksrinivas@coriendo.com; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Moving data directory Hi Srinivas, Is it permanently change it ? Do I have to change some entry in configuration file ? Regards, Dino On 5/12/07, Srinivas Kotapally wrote: > 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. > > ---------------------------(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 > > -- To Analyze Is To Know Batte Field, Differ from Battle Itself