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.

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:
    1
    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:
    36
    WHM >> Service Configuration >> Service Manager

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

    Even if it has, click 'Save' to refresh the saved settings.
     
  3. Owca

    Owca Registered

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

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

    Any ideas?

    Martin
     

Share This Page