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!

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

  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