The postgresql book by wrox tells us to create a user postgres using "useradd" command but when I look into User & groups using RH9.1 configuration tool I dont see any such users but the corresponding "useradd postgres" fails. Little confusing...damn my intelligence...
Have a look at the file /etc/passwd. It lists all the users on the system (if you use the standard authentication method and not some network stuff like NFS or the like). "man 5 passwd" should explain the file format for you. RHs configuration tool probably doesn't tell you about all users but only about those in the group of "living people" (usually "users"). Look for a config option like "Show all users" or "Show system users".
Have fun!
Yours Arthur
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
