Creating users on win32

Started by Josephalmost 26 years ago2 messagesgeneral
Jump to latest
#1Joseph
lters@mrtc.com

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

#2James Thompson
jamest@math.ksu.edu
In reply to: Joseph (#1)
Trig functions in manual

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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<