Hello All,

I'm a virgin newbie to Linux and PostgreSQL but have very much experience in - (whispered) sssh, Windows.

I have downloaded the Red Hat 9 errata corrected RPMs of pgsql - includingthe missing "odbc" package they left off the site (13 rpms in all).

They seemed to unpack with no issues. Following Red Hat's PostgreSQL Configuration instructions, here is my terminal dialog;

[root@localhost user]# postmaster -i > logfile 2>&1 &
[1] 2884
[root@localhost user]# createdb -h localhost -E UNICODE mydb
bash: createdb: command not found
[1]+ Exit 127 postmaster -i >logfile 2>&1

I have been searching around and looking through this list and tried the "initdb" method with a similar "command not found" result. I had to hand create the "/usr/local/pgsql/data" structure - not sure if that was a wise thing to do...maybe some file pointers did not get made.

It seems to me that something did not get installed, installed correctly orI should go back to windows - just kidding. I want to get this Linux down, get pgsql happening, add-on pgadmin III and start giving back to the community.

I've reached that point I'm sure we all have been to at one time or another- I don't trust myself, my knowledge or even my lack of it.

All help greatly appreciated -even the stuff that doesn't work - its the thought and friendship!

Phil
Its a Bitch Being a Newbie!

Hello,

My first thought would be to try the commands with absolute path to the
executables like '/usr/local/pgsql/bin/createdb' as postgres and you have to
initdb first.

BR,

Aarni

On Wednesday 28 January 2004 07:06, you wrote:
--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com

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

On Wednesday 28 January 2004 08:06, Phil Seretti wrote:
You shouldn't be able to start the postmaster as root. that is why it exists
with error status 127. you should start the postmaster as the postgres user.

the postgres user's environment (usually) has the correct path settings
defined so that commands like createdb can work.

- Martin -

--
"If we don't succeed, we run the risk of failure."
--Bill Clinton, President

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

В Срд, 28.01.2004, в 06:06, Phil Seretti пишет:
on redhat just do
# /etc/init.d/postgresql start

then you can do

# su - postgres
# psql template1 postgres

and start adding users and creating databases and stuff.

--
Markus Bertheau <twanger (AT) bluetwanger (DOT) de>


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly