Thread: service postgresql start Fails, Can't su

service postgresql start Fails, Can't su

From
Phillip Harrington
Date:
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


Re: service postgresql start Fails, Can't su

From
Phillip Harrington
Date:
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

Phillip Harrington wrote:
> Hello,
>
> [root@server root]# service postgresql start
> Starting postgresql service: Password:
> su: incorrect password
>                                                            [FAILED]