Hi, I'm using PostgreSQL under Windows 2000 and need help on several issues. I'm not familiar with Unix or Dos prompt so the command prompt is very new to me. Somehow my command prompt became "[bash-2.50] $". So how do I change the command prompt back to "[/] $"?
How do I set the environment variable? From the command prompt I used "export PGDATA2=C:/Database/Data". It did not make any complain but when I try "initlocation PGDATA2" I get error. The reason is because PGDATA2 is not set. When I try to use initdb in the new location using option -D C:/Database it finish create database directory then stop and return failed after it create PG_VERSION file in Data directory. Do you have any idea why and how to fix it? Thanks. Bang Pham ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html