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 enconding.

Discussion in 'General Discussion' started by SACHIN, Oct 23, 2006.

  1. SACHIN

    SACHIN Guest

    HI,


    how can i set encoding for postgresql tables and database?



    Thank you,
     
  2. MaX DiVeL

    MaX DiVeL Member

    Joined:
    Oct 23, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    you want add a new database in youre cpanel

    or what?
     
  3. nrm

    nrm Member
    PartnerNOC

    Joined:
    Jan 11, 2007
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Moscow, Russia
  4. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Code:
    su - postgres
    psql template1 postgres
    update pg_database set encoding = pg_char_to_encoding('NEWENCODING');
    
    After this, from now on all databases will be created with the new encoding. This only works, of course, if you want all databases to be the same encoding.
     
  5. bryanabhay

    bryanabhay Active Member

    Joined:
    Aug 14, 2006
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    6
    Hello,


    But before doing this i am not able to

    psql -U postgres -w

    this command is not accepting the password

    and hence i am unable to login as postgres user and do the other tasks ?

    does anyone know why ?

    ~ Bryan
     

Share This Page