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@challenger etc]$ su <-- log in as root Password: <-- key in root passwd [root@challenger etc]# su -l postgres <-- swith over to the user name "postgres" [postgres@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@challenger postgres]$
regards,
Devinder Rajput Stores Division Corporate Offices Chicago, IL (773) 442-6474
Steve_Miller@sil.org Sent by: pgsql-novice-owner@postgresql.org
01/09/2003 10:56 AM
To: pgsql-novice@postgresql.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@postgresql.org)