Re: Getting Started newbie questions)

type in "which psql". This will tell you where psql is installed, along
with all of the other binaries.

to resolve the error "psql: FATAL 1: user "Steve" does not exist", you need to create a
postgres user named steve. here is how:

[drajput(at)challenger etc]$ su <-- log in as root
Password: <-- key in root
passwd
[root(at)challenger etc]# su -l postgres <-- swith over to the user name
"postgres"
[postgres(at)challenger postgres]$ createuser steve <-- add a new
postgres user account steve.
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
[postgres(at)challenger postgres]$

regards,

Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474

Steve_Miller(at)sil(dot)org
Sent by: pgsql-novice-owner(at)postgresql(dot)org
01/09/2003 10:56 AM

To: pgsql-novice(at)postgresql(dot)org
cc:
Subject: [NOVICE] Getting Started newbie questions)

I'm new to both Linux and Postgres

I installed Red Hat 8 on a stand-alone test machine yesterday. I did a
custom install, and installed everything. So my assumption is that
everything Red Hat 8 could install was installed, including Postgresql.

I went into Server Settings, Services, and in Service Configuration found
postgresql. I checked it, so that it would start on reboot. The machine
has
since been rebooted

The tutorial says the Postgresql is stored in /usr/local/pgsql/ and
/usr/local/pgsql/data. I don't see either one, either as me (Steve) or as
root. I do see files under /usr/lib/, usr/share/, and usr/include.

The tutorial says to try to create a new database with

$ createdb mydb

I get the error:

psql: FATAL 1: user "Steve" does not exist
createdb: database creation failed.

This sounds to me like postmaster is running. But what do I know?

The tutorial says to try the command with the absolute path:

/usr/local/pgsql/bin/createdb mydb

I get the error:

No such file or directory

No surprise there. I already saw that I couldn't find a /usr/local/pgsql

Steve

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)