The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

who should run this command {service postgresql start}?

Discussion in 'Security' started by 000, Jun 1, 2013.

  1. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    Thanks Michael.

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    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:
    some is wrong/insecure?

    I need add something to fixed connections?

    THAnks!

    :D
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page