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
