persefon Posted October 23, 2011 Posted October 23, 2011 Hello, i can't add functions to my DB because Plpgsql (postgres) language is not created in jhonny. Thanks
Guest xaav Posted October 23, 2011 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.
Wizard Posted October 23, 2011 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"?
Guest xaav Posted October 23, 2011 Posted October 23, 2011 Have you tried "sudo su postgres"? Yes, I have tried that; the problem is the .pgpass file is missing.
Ashoat Posted October 23, 2011 Posted October 23, 2011 Okay, done. I think WHM has a facility to change the PostgreSQL root password?
Guest xaav Posted October 24, 2011 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.
Krydos Posted October 24, 2011 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.
Recommended Posts