Re: Win32 users?

Joe schrieb:

> I guess I wasn't clear enough. Currently, I'm about to use the native
> Win32 port. I suspect pgsql-hackers-win32 subscribers won't
> appreciate newbie-type questions. Specifically, I installed 8.0.3
> with the installer. Then I opened a command prompt window, typed
> 'createdb mydb' as per the tutorial (section 1.3) and got
> 'unrecognized internal or external command'.

Which makes it a Windows problem, I'd say. ;)

> I presume I need to add the Postgres bin directory to my PATH, but I
> couldn't find a reference to this in the manual or in the native
> Windows FAQ.

You can allways use the complete path to the psql command, but obviously
this'd suck.

> Bruce Momjiam thought that the pginstaller took care of this already,
> so I'm going to reinstall (and pay attention this time :-), but if
> someone can point me to the instructions I'd appreciate it.

No, the installer doesn't ... as far as I know.
I'd say it's better that it doesn't. I prefer messing up my system
variables my self. :D

So dere's what I did.
1) Figure out where your Postgres binaries ended up.
Probaply in C:\Programs\PostgreSQL\8.0\bin
2) Right-click on the PC-icon on your desktop. It's called "my
workplace" or something. Sorry, I have no English version.
3) Click on settings
4) Extended
5) The middle button is for the environment-variables
6) In the lower listbox "systemvariables" you should find "path"
7) select it and click the edit button
8) Append the Postgres-directory to the PATH-string ...bla...bla...
;C:\Programs\PostgreSQL\8.0\bin
seperated by a ;
9) click OK and OK again

The CMDs should have the extended path from now on.
At least when you log out and in again. No reboot necesary.

This goes for windows 2000.
I have a faint idea that Win XP has no such PC-icon right on the desktop
anymore but it's somewhere in the start-menue.

BTW a cygwin user hadn't had this issue because he'd have put the
cygwin-path there as it's mentioned in the cygwin readme.