On Mon, 8 Jun 1998, Harri Varpanen wrote:
> Hi,
>
> I'd like to begin experimenting with databases so I installed the
> FreeBSD port for postgreSQL 6.3.2. The installation went well but I don't
> seem to get anything done; this is what I get:
>
> --
>
> $ createuser (or any command whatsoever)
>
> 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.
>
> createuser: database access failed.
>
> --
>
> And, the kernel gives:
>
> /kernel: cmd postgres pid 13794 tried to use non-present SYSVSEM
> /kernel: pid 13794 (postgres), uid 70: exited on signal 12 (core dumped)
>
> --
>
> What to fix? The port seems to do things a bit different compared to the
> instructions on the pgsql web pages, should I try without the port?
With or without the port won't matter...as the error message
says, you do not have the SYSV* options enabled in your kernel...