[EMAIL PROTECTED] root]# service postgresql start
Starting postgresql service: Password:
su: incorrect password
[FAILED]I've tried this as the postgres user as well and get:
[EMAIL PROTECTED] 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:
[EMAIL PROTECTED] 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
