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@xxxxxx> To: "User Map" <map.user@xxxxxxxxx> Cc: "pgsql" <pgsql-general@xxxxxxxxxxxxxx> Sent: Thursday, January 24, 2008 8:18 AM Subject: Re: 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@xxxxxx > --------------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
