I just fought with this all day yesterday, and finally figured it out. One
thing I realized (thank you steve jorgensen for pointing this issue out) is
that the user you install as is the one you have to be logged on as to run
the database. This was not a problem for me because I have granted my
normal user administrator priveleges. This may not be the best way to
proceed in a production environment, but my guess is that you just want to
install postgresql on NT in order to experiment with it and do development
work. What follows is cut and pasted from something I just sent off to
someone yesterday.
All that's necessary is to grab the file from
http://208.160.255.143/pgsql/pgsql.exe and run it. This will unzip into
C:\pgsql and then you just run the setup.exe from there and let it install
everything. Next, just go to Start | Programs | PostgreSQL v. 7.03 |
PostgreSQL Guardian to get everything running. Then go to Start |
Programs | PostgreSQL v. 7.03 | Cygwin Bash Shell and type the following:
psql -h localhost -U sysdba template1
Then at the password prompt, enter "masterkey" (no quotes), and you're
logged into the template1 db that is installed by default. To create your
own db, do this:
createdb -h localhost -U sysdba -W yourdb
again, enter the password "masterkey" at the prompt, and you'll have created
a database named "yourdb"
As should be obvious, the default user with all the power is named "sysdba"
(not "postgres" as might be expected) and the password for that user is
"masterkey". Anything else you need to now can be discovered by typing the
command you want (createdb, psql, createuser, dropuser, dropdb, etc...)
followed by the help invocation "--help".
Good luck, and ask specific questions if you have them,
~c
+-----Original Message-----
+From: pgsql-novice-owner@postgresql.org
+[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of manoj garg
+Sent: Tuesday, April 10, 2001 7:16 AM
+To: pgsql-novice@postgresql.org
+Subject: [NOVICE] how to run postgre on winNT
+
+
+hi,
+ can anybody tell me where can i get postgre for
+windows and how to run it.like how to create database,
+tables etc
+thanks in advance
+mobile
+
+__________________________________________________
+Do You Yahoo!?
+Get email at your own domain with Yahoo! Mail.
+http://personal.mail.yahoo.com/
+
+---------------------------(end of broadcast)---------------------------
+TIP 6: Have you searched our list archives?
+
+http://www.postgresql.org/search.mpl
+
