Forum OpenACS Q&A: PostgreSQL installation / "createlang plpgsql template1" / autocommit error message

Collapse
1: PostgreSQL installation / "createlang plpgsql template1" / autocommit error message
Posted by Rowan Brownlee on 08/15/03 01:08 PM
Hello all,

At step 6 of the step-by-step postgreSQL installation instructions ("Set up plpgsql and allow your user to have access."),

https://openacs.org/doc/openacs-4-6-3/postgres.html

I receive the following message when executing the command "createlang plpgsql template1".

ERROR:  'autocommit' is not a valid option name
createlang: language installation failed

I don't know what's happening here - would appreciate any ideas.

thanks
rowan

Collapse
2: Re: PostgreSQL installation / "createlang plpgsql template1" / autocommit error message (response to 1)
Posted by Rowan Brownlee on 08/17/03 01:35 AM
I think I may have fixed this problem by adding 'autocommit = true' to postgres's .conf file.

Now I have a new error at the same step -

[postgres@localhost pgsql]$ createlang plpgsql template1
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
createlang: external error

From a scan of the archives it appears that this error isn't all that uncommon.

cheers
Rowan

Collapse
3: Re: PostgreSQL installation / "createlang plpgsql template1" / autocommit error message (response to 1)
Posted by Tom Jackson on 08/17/03 07:17 PM

I think it means postgres isn't running, or it isn't running on port 5432. Do a: 

ps axww|grep post
to see if postmaster/postgres is running.