service postgresql start Fails, Can't su

[Phillip Harrington]

Hello,

[***@server root]# service postgresql start
Starting postgresql service: Password:
su: incorrect password
[FAILED]

I've tried this as the postgres user as well and get:

[***@server root]# su postgres
Password:
bash-2.05a$ cd
bash-2.05a$ service postgresql start
postgresql: unrecognized service

I'm wondering if this would have worked if I had not as root done:

[***@server root]# passwd postgres

to set the password for that user. But then I couldn't become that user..?

I'm wondering if this is a permissions thing? Where is it trying to su
from (the /etc/init.d/postgres file obviously, but er - from what user?
from root to whom?)? Why doesn't it know the password? Can I set it in
the /etc/init.d/postgres or somewhere else?

More info: PostgreSQL RPM was installed on my machine (a user mode Linux
virtual machine) when I got it. It's a Red Hat 7.3 and I believe
Postgres is 7.2. Should I uninstall, delete everything and start fresh?

Sorry if this is a duplicate post. I've Googled and surfed this list for
about three hours now trying to find this so I'm giving up and posting :-/

TIA,
Phillip


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

[Phillip Harrington]

After much thought, I think I did something lame with a PAM file
somewhere a while back, causing root to use a passwd when su'ing. I'll
look into it.
Phillip

Post by Phillip Harrington
Hello,
su: incorrect password
[FAILED]

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