Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7EF0D9FB1CE for ; Tue, 22 May 2007 03:26:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47313-01 for ; Tue, 22 May 2007 03:26:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s14.bay0.hotmail.com (bay0-omc3-s14.bay0.hotmail.com [65.54.246.214]) by postgresql.org (Postfix) with ESMTP id 023BA9FA344 for ; Tue, 22 May 2007 03:26:21 -0300 (ADT) Received: from hotmail.com ([207.46.11.81]) by bay0-omc3-s14.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 21 May 2007 23:26:20 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 21 May 2007 23:26:20 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Tue, 22 May 2007 06:26:16 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: From: "Vishal Arora" To: Mahmood.Khan@in.unisys.com, indolinux.geeks@gmail.com, stellr@cns.vt.edu Cc: pgsql-admin@postgresql.org Subject: Re: Moving data directory Date: Tue, 22 May 2007 06:26:16 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 May 2007 06:26:20.0036 (UTC) FILETIME=[1C4F8C40:01C79C3A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/220 X-Sequence-Number: 25540 This is also an alternative that can be used. I am not sure about windows, but it is PGDATA variable in Linux. it can be set using export command. - vishal >From: "Khan, Mahmood Ahram" >To: "Vishal Arora" >,, >CC: >Subject: Re: [ADMIN] Moving data directory >Date: Tue, 22 May 2007 11:11:00 +0530 > >No needs to specify in pg_ctl start/stop clause instead add a variable >in PATH. PG_DATA = d:\postgresdata\data. It is start by just typing >pg_ctl start/stop. >Thanks & Best Regards > >M.AHRAM KHAN > >-----Original Message----- >From: pgsql-admin-owner@postgresql.org >[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora >Sent: Tuesday, May 22, 2007 10:09 AM >To: indolinux.geeks@gmail.com; stellr@cns.vt.edu >Cc: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] Moving data directory > >Each time you start postgres server using pg_ctl you have to mention the > >data directory location using -D option. Alternatively you can specify >in >the data_directory parameter of postgresql.conf file. > >- vishal > > > >From: "Linux Geeks" > >To: "Ray Stell" > >CC: pgsql-admin@postgresql.org > >Subject: Re: [ADMIN] Moving data directory > >Date: Tue, 22 May 2007 10:45:17 +0700 > > > >Hi Ray, > > > >Sorry for late reply. Yes, I have tested your instructions and working > >well. The think is now I need to configure so that it will always > >automically start with the new location. > > > >Thank you very much for the detailed instructions, really appreciated >it. > > > >Regards, > > > >Dino > > > >On 5/14/07, Ray Stell wrote: > >>On Sat, May 12, 2007 at 11:47:46PM +0700, Linux Geeks wrote: > >> > I'm very new to postgresql and would like to move my data directory >to > >> > another partition in Ubuntu. > >> > >> > >>I don't think there is anything internal to pg that locks the data > >>location. Just tell postmaster where you move it to. Shut down the > >>postmaster and move it and start it with the -D flag pointing to the > >>new location: > >> > >>$ pg_ctl start -D /var/pgsql/data > >>server starting > >> > >>$ psql -p 5437 testdb jira > >>Password for user jira: > >>Welcome to psql 8.2.3, the PostgreSQL interactive terminal. > >> > >>Type: \copyright for distribution terms > >> \h for help with SQL commands > >> \? for help with psql commands > >> \g or terminate with semicolon to execute query > >> \q to quit > >> > >>testdb=> \q > >> > >>pg_ctl stop -D /var/pgsql/data > >>waiting for server to shut down....,7222,,2007-05-13 19:52:06.675 > >>EDT,,1,,, LOG: logger shutting down > >> done > >>server stopped > >> > >>$ mv /var/pgsql/data-move-test /var/pgsql/data > >> > >>$ pg_ctl start -D /var/pgsql/data-move-test > >>server starting > >> > >>$ psql -p 5437 testdb jira > >>Password for user jira: > >>Welcome to psql 8.2.3, the PostgreSQL interactive terminal. > >> > >>Type: \copyright for distribution terms > >> \h for help with SQL commands > >> \? for help with psql commands > >> \g or terminate with semicolon to execute query > >> \q to quit > >> > >>testdb=> \q > >> > >>pg_ctl stop -D /var/pgsql/data-move-test > >>waiting for server to shut down....,7245,,2007-05-13 19:55:00.944 > >>EDT,,1,,, LOG: logger shutting down > >> done > >>server stopped > >> > >>$ mv /var/pgsql/data-move-test /var/pgsql/data > >> > >>$ pg_ctl start -D /var/pgsql/data > >>server starting > >> > >>$ psql -p 5437 testdb jira > >>Password for user jira: > >>Welcome to psql 8.2.3, the PostgreSQL interactive terminal. > >> > >>Type: \copyright for distribution terms > >> \h for help with SQL commands > >> \? for help with psql commands > >> \g or terminate with semicolon to execute query > >> \q to quit > >> > >>testdb=> \q > >> > >>-- > >> Lost time is when we learn nothing from the experiences of life. >Time > >> gained is when we grow to have a wisdom that is tested in the >reality of > >>life. > >> > > > > > >-- > >To Analyze Is To Know Batte Field, Differ from Battle Itself > > > >---------------------------(end of >broadcast)--------------------------- > >TIP 5: don't forget to increase your free space map settings > >_________________________________________________________________ >More photos, more messages, more storage-get 2GB with Windows Live >Hotmail. >http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migr >ation_HM_mini_2G_0507 > > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >---------------------------(end of broadcast)--------------------------- >TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq _________________________________________________________________ Catch suspicious messages before you open them—with Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_protection_0507