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!

plpgsql-postgresql

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

  1. cosmin

    cosmin Well-Known Member

    Joined:
    Feb 6, 2002
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    316
    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:
    151
    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:
    151
    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:
    166
    Location:
    Bangalore, India
    any solution ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. mohamed_gaber

    mohamed_gaber Member

    Joined:
    Mar 4, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    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:
    166
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. nettigritty

    nettigritty Well-Known Member
    PartnerNOC

    Joined:
    Jan 21, 2004
    Messages:
    194
    Likes Received:
    0
    Trophy Points:
    166
    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 ..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    151
    worked like a sharm..

    thanx a million :)
     
Loading...

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