Forum OpenACS Q&A: Installing PostgreSQL 7.1.3: installing plpgsql using 'createlang plpgsql template1' command

1: Installing PostgreSQL 7.1.3: installing plpgsql using 'createlang plpgsql template1' command

Posted by Mike Ananny on 07/16/02 06:04 PM

Hi,

I'm a newbie to this and am in the middle of installing OpenACS 4.5.

I've installed PostgreSQL 7.1.3, started it up and am now trying to
follow the documentation instructions under 'Set up plpgsql and allow
nsadmin access' at https://openacs.org/doc/postgres.html.

When I run:

% createlang plpgsql template1

I get the following error:

/usr/bin/psql: error while loading shared libraries: /usr/bin/psql:
undefined symbol: pg_encoding_to_char

I think I created the user and environment variables properly but am
frankly pretty clueless about what to do next. Any help would be
greatly appreciated.

Thanks,
-- Mike.

2: Response to Installing PostgreSQL 7.1.3: installing plpgsql using 'createlang plpgsql template1' command (response to 1)

Posted by Mike Ananny on 07/17/02 12:30 PM

As a follow-up, I'm running Mandrake 2.05.1(1) on an Intel Pentium 4, 1.4GHz. And, I gave the wrong URL for the documentation I'm following. It's actually: https://openacs.org/doc/openacs-4/postgres.html

Thanks in advance for any suggestions.

-- Mike.

3: Response to Installing PostgreSQL 7.1.3: installing plpgsql using 'createlang plpgsql template1' command (response to 1)

Posted by Janine Ohmer on 07/17/02 06:36 PM

Did you remember to add $PGHOME/lib to your LD_LIBRARY_PATH? That's the first thing I would check.

4: Response to Installing PostgreSQL 7.1.3: installing plpgsql using 'createlang plpgsql template1' command (response to 1)

Posted by Mike Ananny on 07/18/02 01:28 PM

Thanks to everyone for their suggestions.

After a bit of searching the web I found a response at http://www.geocrawler.com/archives/3/12/2002/2/0/7963711/ that suggested recompiling PostgreSQL with --enable-multibyte.

I recompiled with the -enable--multibyte and -enable-local flags and was then able to use createlang.

In the documentation at https://openacs.org/doc/openacs-4/postgres.html these flags were suggested for Unicode support. Perhaps this could be rephrased to be less of an option as I wasn't sure if I wanted Unicode support but it seems to be necessary in my case?

Thanks again,

-- Mike.

5: Response to Installing PostgreSQL 7.1.3: installing plpgsql using 'createlang plpgsql template1' command (response to 1)

Posted by Jon Griffin on 07/18/02 04:19 PM

I don't use lang or unicode and all works. I am glad that worked for you but something else is wrong.