Forum OpenACS Q&A: createlang step

Collapse
1: createlang step
Posted by phil phil on 10/27/06 11:02 AM
i've got a problem on the postgres instalation.
is there any way to fix that without install postgres again?
I'm following the debian installation docs:
https://openacs.org/wiki/Installing%20OpenACS%20on%20Debian%20Linux
***********************************************
debian:~# su postgres -c "/usr/lib/postgresql/bin/createlang plpgsql template1"
createlang: could not connect to database template1: could not connect to server: lÔ)@(÷%@
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
debian:~#

Can anyone help me on that??

Collapse
2: Re: createlang step (response to 1)
Posted by Dave Bauer on 10/27/06 12:44 PM
If you installed the Debian package for PostgreSQL, you shoudl execute /etc/init.d/postgresql start as root or using sudo to start postgresql.
Collapse
3: Re: createlang step (response to 1)
Posted by Iuri Sampaio on 10/27/06 04:36 PM
somehow the command
debian:~# su postgres -c "/usr/lib/postgresql/bin/createlang plpgsql template1"

sometimes didn't work to me as well. then i just log as postgres and execute createlang.
postgres:~# createlang plpgsql template1

and it worked out.

also as dave said. make sure postmater service is up!

Collapse
4: Re: createlang step (response to 2)
Posted by phil phil on 10/30/06 09:41 AM
hi Dave Bauer,
Thank you very much..........
Collapse
5: Re: createlang step (response to 3)
Posted by phil phil on 10/30/06 09:42 AM
hi iuri sampaio,
Thank you very much !!!!!!!!!!!!!