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(at)iol(dot)ie
---------------------------------------------------------------