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
[EMAIL PROTECTED]
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to