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.

plpgsql-postgresql

Discussion in 'General Discussion' started by cosmin, Jan 13, 2004.

  1. cosmin

    cosmin Well-Known Member

    Joined:
    Feb 6, 2002
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bucuresti
    A client want to install plpgsql. I try "createlang plpgsql db_name" but I receive this error

    root@dedicate [/backup]# createlang plpgsql db_name
    Password:
    psql: FATAL: Password authentication failed for user "root"

    The same error if I try with psql:
    root@dedicate [/backup]# psql
    Password:
    psql: FATAL: Password authentication failed for user "root"

    createlang: external error
    root@dedicate [/backup]#

    I put the root pswd and root_postgresql pswd and nothing.... the same error.

    Any ideeea?
    Thanks!
     
  2. TKlaver

    TKlaver Member

    Joined:
    Jan 29, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    same problem here, so any ideas would be really apreciated!
    thanks in advance!
     
  3. TKlaver

    TKlaver Member

    Joined:
    Jan 29, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    has nobody ever had any issues with this?
     
  4. nettigritty

    nettigritty Well-Known Member
    PartnerNOC

    Joined:
    Jan 21, 2004
    Messages:
    194
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bangalore, India
  5. mohamed_gaber

    mohamed_gaber Member

    Joined:
    Mar 4, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    i have the exact same problem ...

    can any bosy advice on that ?
     
  6. nettigritty

    nettigritty Well-Known Member
    PartnerNOC

    Joined:
    Jan 21, 2004
    Messages:
    194
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bangalore, India
    I had found a solution for this ..

    something like not using root as the user. some other user... let me see if i can dig this out.
     
  7. nettigritty

    nettigritty Well-Known Member
    PartnerNOC

    Joined:
    Jan 21, 2004
    Messages:
    194
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bangalore, India
    try this !!

    su - postgres

    then you will be able to manage postgres dbs. type psql -l to see list of dbs

    then try createlang etc ..
     
    #7 nettigritty, Jul 16, 2004
    Last edited: Jul 16, 2004
  8. mohamed_gaber

    mohamed_gaber Member

    Joined:
    Mar 4, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    worked like a sharm..

    thanx a million :)
     

Share This Page