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.

postgresql JP ?

Discussion in 'General Discussion' started by Secret Agent, Dec 14, 2005.

  1. Secret Agent

    Secret Agent Guest

    I'm trying to create a new postgres db with its encoding method set to 'EUC_JP'(japanese).. but some higher level of permission is required to create db with encoding setup.

    I tried with phpPgAdmin (below) and ssh shell but both failed from the same permission problem. cPanel's Postgres control simply doesn't do as far as encoding setup.

    I would like to create the below

    createdb --encoding EUC_JP --owner thailand thailand_tbp

    Giving me errors

    createdb: could not connect to database template1: FATAL: user "root" does not exist

    Any advice please?
  2. Secret Agent

    Secret Agent Guest

    Also, I would like to know if it is possible to use the pgAdmin desktop tool to administrate Postgre databases. And if so, what information would I need to enter?

    Thank you.

Share This Page