service postgresql start Fails, Can't su - Mailing list pgsql-admin

From Phillip Harrington
Subject service postgresql start Fails, Can't su
Date
Msg-id 3FF21B68.7020405@philsown.com
Whole thread Raw
Responses Re: service postgresql start Fails, Can't su
List pgsql-admin
Hello,

[root@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:

[root@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:

[root@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


pgsql-admin by date:

Previous
From: Charles Haron
Date:
Subject: Re: How to use psql -c?
Next
From: "vidhya"
Date:
Subject: ftp postgres database from windows 2000 to Linux