Re: Getting Started newbie questions)
| От | Devinder K Rajput |
|---|---|
| Тема | Re: Getting Started newbie questions) |
| Дата | |
| Msg-id | OF26BEE057.C5EC132B-ON86256CA9.005D88A3@ipaper.com обсуждение исходный текст |
| Ответ на | Getting Started newbie questions) (Steve_Miller@sil.org) |
| Список | pgsql-novice |
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)
В списке pgsql-novice по дате отправления: