who should run this command {service postgresql start}?

000

Well-Known Member
Jun 3, 2008
201
3
68
Hi.

When you update PgSQL to 9.x

Is required run this command:

service postgresql start

As root ?
Becouse When I run
-su postgres
-service postgresql start
then result is FAIL.

I only can start as ROOT

Thanks
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello :)

It does appear the default behavior for PostgreSQL 9.x is that it must be started while logged in as "root". I confirmed this on a test server with PostgreSQL 9.2 installed.

Thank you.
 

000

Well-Known Member
Jun 3, 2008
201
3
68
Thanks Michael.

And... Some idea about who START tomcat?
the user tomcat or root ?
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
And... Some idea about who START tomcat?
the user tomcat or root ?
The default behavior is that the "root" user must restart Tomcat. I get permission denied errors if I try to restart it as the "tomcat" user:

Code:
bash-4.1$ /usr/sbin/stoptomcat
bash: /usr/sbin/stoptomcat: Permission denied
Thank you.
 

000

Well-Known Member
Jun 3, 2008
201
3
68
PostgreSQL 9.x is that it must be started while logged in as "root".
Thanks.

Now, when my PhpPgAdmin no start, I samplely add this
PHP:
local all all        md5
host all all  127.0.0.1   255.255.255.255   md5
into my pg_hba.conf, after I run service postgresql reload and PhpPgAdmin connect fine! :)

My question is is all fine? or is insecure my Postgres server ?

Finally my pg_hba.conf is this:
local samerole all md5
host samerole all 127.0.0.1 255.255.255.255 md5
local all postgres md5
host all postgres 127.0.0.1 255.255.255.255 md5
local all all md5
host all all 127.0.0.1 255.255.255.255 md5
some is wrong/insecure?

I need add something to fixed connections?

THAnks!

:D