Re: [ADMIN] postgresql questions

On Tue, 2 Jun 1998, Chan Fook Sheng wrote:

> 4) when I run "psql template1 " or "createdb test" I get the following:
>
> connection to database 'template1' failed.
> PQexec() -- Request was sent to backend, but backend closed the channel
> before responding. This probably means the backend terminated abnormally
> before or while processing the request.
> freebsd /kernel : cmd postgres pid 782 tried to use non-present SYSVSEM
> freebsd /kernel : cmd postgres pid 782 tried to use non-present SYSVSEM
> freebsd /kernel : cmd postgres pid 755 tried to use non-present SYSVSEM
>  freebsd /kernel : cmd postgres pid 755 tried to use non-present SYSVSEM
>
> createdb: database creation failed on test.
> [1] 755 Bad system call (core dumped) postmaster -D/usr/local/pgsql/data
>
> And the postgresql stops. Can anyone help me on this please?

    The error message is pretty self-explanatory, no?  You don't have
SYSVSEM compiled into your kernel...