Обсуждение: SYSVSEM?

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?

Regards,
Harri Varpanen
FreeBSD 2.2.5-STABLE

---
this is everything

> 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?
>

Hello Harry,

If you read the FAQ_FreeBSD in the docs sub directory of the distribution,
you'll see that you need to recompile the FreeBSD kernel with support for
SystemV Semaphores, etc. While you're at it you might also want to bump up
the maxusers parameter (I changed mine from 5 to 10), as I found I was
running out of file descriptors with postgresql running with apache.
--
Ivan Cornell, FrameStore Ltd
ivan.cornell@framestore.co.uk

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...

On Mon, Jun 08, 1998 at 12:19:04PM +0300, 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?

go into your /sys/i386/conf dir
open your config file for the kernel and add these lines
options SYSVSHM
options SYSVSEM
options SYSVMSG
then run config, compile, install and reboot

gabor.
--
    Interestingly enough, since subroutine declarations can come
    anywhere, you wouldn't have to put BEGIN {} at the beginning, nor
    END {} at the end.  Interesting, no?  I wonder if Henry would like
    it. :-)
        -- lwall

On Mon, 8 Jun 1998, Ivan Cornell wrote:

[...]
> you'll see that you need to recompile the FreeBSD kernel with support for
> SystemV Semaphores, etc.

Yep, up & running now, thanks!

Harri

---
this is everything