plpgsql-postgresql

[cosmin]

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!

[TKlaver]

same problem here, so any ideas would be really apreciated!
thanks in advance!

[TKlaver]

has nobody ever had any issues with this?

[nettigritty]

any solution ?

[mohamed_gaber]

i have the exact same problem ...

can any bosy advice on that ?

[nettigritty]

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.

[nettigritty]

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

[mohamed_gaber]

worked like a sharm..

thanx a million