Thread: Creating users on win32

How do I create users for postgress on an NT workstation?


> I am trying to run postgress on an NT workstation.
>
> Do I have to run it in a bash prompt?
>
> This is the error I get if I try to run postgres.exe at nt cmd prompt:
> D:\cygnus\cygwin-b20>postgres
> FATAL 1:  SetPgUserName: no entry in host passwd file
>
> The admin.pdf doesn't seem to give much help.
>
> I am a newbie with Unix or Linux but am very at home in the win32 world.
>
> Joseph

>Log in as "postgres" (empty password) and create some users.

Joseph

I'm trying to use the trig functions mentioned in the postgresql manual.
Namely the cosine function listed as

cos(float8)     float8    cosine   cos(0.4)

In both 6.5.3 and 7.0beta3 the function doesn't exist.  I get. . .

obe-> \df cosine
result|function|arguments|description
------+--------+---------+-----------
(0 rows)

obe-> \df cos
result|function|arguments|description
------+--------+---------+-----------
(0 rows)

I didn't see any additional ./configure options to activate the math
functions, nor did I see any recent mention of this in the mail
archives.  Am I missing something?

Also FWIW the manual lists the power function as pow which also doesn't
exist as pow but as power.

obe-> \df pow
result |function|arguments       |description
-------+--------+----------------+--------------------------
numeric|power   |numeric numeric |m raised to the power of n
(1 row)


Thanks,
James

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson    138 Cardwell Hall  Manhattan, Ks   66506    785-532-0561
Kansas State University                          Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<