Re: changing the default directory

i agree and if your postgres data folder will be constant I would set PGDATA
environment variable to the folder location

M-
----- Original Message -----
From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: "User Map" <map(dot)user(at)yahoo(dot)com>
Cc: "pgsql" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, January 24, 2008 8:18 AM
Subject: Re: [GENERAL] changing the default directory

> On 24/01/2008 13:02, User Map wrote:
>
> > i am new to this postgre, i m running postgre under windows server 2003.
> > postgres stores the database/data in the directory "C:\Program
> > Files\PostgreSQL\8.2\data" by default. i want to change this directory
> > to some other drive. is it posible to do this without comand prompt. if
> > it is not then how to do that step by step. and does this one time
> > directory change applies to every database that i will create through
> > pgadminIII.
>
> Hi,
>
> The data directory is set by using initdb. If you installed using the
> pgInstaller, then setting the data directory was one of the steps along
> the way....and I don't think you can change that using pgInstaller
> without un- and re-installing PostgreSQL altogether (others will correct
> me if I'm wrong).
>
> However, it's easy to run initdb from the command line, and this will
> let you create a new data directory without having to uninstall first.
> Have a look at the docs, here:
>
> http://www.postgresql.org/docs/8.2/static/creating-cluster.html
>
> It's pretty much the same on Windows as on *nix.
>
> HTH,
>
> Ray.
>
> ---------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod(at)iol(dot)ie
> ---------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>