persefon Posted October 23, 2011 Share Posted October 23, 2011 Hello, i can't add functions to my DB because Plpgsql (postgres) language is not created in jhonny. Thanks Link to comment Share on other sites More sharing options...
Guest xaav Posted October 23, 2011 Share Posted October 23, 2011 This is already implemented on Stevie; but I will go ahead escalate this. @djbob The following command needs to be run under the "postgres" account: createlang plpgsql template1 The problem is the /var/lib/pgsql/.pgpass file is missing, and I don't know the password for PostgreSQL on Johnny. Link to comment Share on other sites More sharing options...
persefon Posted October 23, 2011 Author Share Posted October 23, 2011 But, can you fix it? Link to comment Share on other sites More sharing options...
Wizard Posted October 23, 2011 Share Posted October 23, 2011 This is already implemented on Stevie; but I will go ahead escalate this. @djbob The following command needs to be run under the "postgres" account: createlang plpgsql template1 The problem is the /var/lib/pgsql/.pgpass file is missing, and I don't know the password for PostgreSQL on Johnny. Have you tried "sudo su postgres"? Link to comment Share on other sites More sharing options...
Guest xaav Posted October 23, 2011 Share Posted October 23, 2011 Have you tried "sudo su postgres"? Yes, I have tried that; the problem is the .pgpass file is missing. Link to comment Share on other sites More sharing options...
Ashoat Posted October 23, 2011 Share Posted October 23, 2011 Okay, done. I think WHM has a facility to change the PostgreSQL root password? Link to comment Share on other sites More sharing options...
Guest xaav Posted October 24, 2011 Share Posted October 24, 2011 Okay, done. I think WHM has a facility to change the PostgreSQL root password? Yes, I was worried changing the password might mess something up. @persefon Please DROP and CREATE your database, then PlPgSQL should be installed. Link to comment Share on other sites More sharing options...
persefon Posted October 24, 2011 Author Share Posted October 24, 2011 It works! THANKS Link to comment Share on other sites More sharing options...
Krydos Posted October 24, 2011 Share Posted October 24, 2011 Glad your problem got solved! Please spare a few minutes to take our brief survey:http://feedback.heliohost.org/Your participation in this survey is greatly appreciated. Link to comment Share on other sites More sharing options...
Recommended Posts