Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Postgre: 2 quite simple things

Discussion in 'General Discussion' started by Owca, Nov 28, 2005.

  1. Owca

    Owca Registered

    Joined:
    Nov 16, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151
    hi guys,

    Postgre installed succesfully, users can create their databases etc but i don't see Postgre in Service Status in WHM.
    There is no postgresql file in /var/run/chkservd/
    I see in Restart Services SQL Server (PgSQL)

    Question 1:
    How / What shoud i change to see postgre in Service status?
    Question 2:
    How change PG database encoding from SQL_ASCII to UNICODE? But globaly not for one database but for all databases created and that which will be created.
    Something similar to default-character-set=latin2 in my.cnf (mysql)

    Thx,

    Martin
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    166
    WHM >> Service Configuration >> Service Manager

    Ensure that 'postgresql' has 'Enabled' and 'Monitor' checked.

    Even if it has, click 'Save' to refresh the saved settings.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Owca

    Owca Registered

    Joined:
    Nov 16, 2005
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151
    // WHM >> Service Configuration >> Service Manager

    There is no 'postgresql' service :( But Postgre is working, installed from tutorial from this forum.

    Any ideas?

    Martin
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice