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