who should run this command {service postgresql start}?

[000]

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]

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]

Thanks Michael.

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

 

[cPanelMichael]

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:

bash-4.1$ /usr/sbin/stoptomcat
bash: /usr/sbin/stoptomcat: Permission denied

Thank you.

 

[000]

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

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

 

[cPanelMichael]

The roles in the pg_hba.conf file are discussed on this thread:

Updated pg_hba.conf after cPanel update

Thank you.