From owner-freebsd-questions Wed Jun 3 00:14:55 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id AAA12714 for freebsd-questions-outgoing; Wed, 3 Jun 1998 00:14:55 -0700 (PDT) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from gdi.uoregon.edu (gdi.uoregon.edu [128.223.170.30]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id AAA12702 for ; Wed, 3 Jun 1998 00:14:46 -0700 (PDT) (envelope-from dwhite@gdi.uoregon.edu) Received: from localhost (dwhite@localhost) by gdi.uoregon.edu (8.8.8/8.8.8) with SMTP id AAA22758; Wed, 3 Jun 1998 00:14:42 -0700 (PDT) (envelope-from dwhite@gdi.uoregon.edu) Date: Wed, 3 Jun 1998 00:14:42 -0700 (PDT) From: Doug White Reply-To: Doug White To: Chan Fook Sheng cc: "freebsd-questions@FreeBSD.ORG" , pgsql-admin@postgresql.org Subject: Re: postgresql questions In-Reply-To: <3573CF31.8AE747D6@hotmail.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Tue, 2 Jun 1998, Chan Fook Sheng wrote: > Then I try > 3)postmaster -D /usr/local/pgsql/data > and it runs, I wonder why it don't start automatically when I start the > server, my /usr/local/pgsql/.profile file had defined the PGDATA as > /usr/local/pgsql/data and I have the file /usr/local/etc/rc.d/pgsql.sh . Make sure it's executable. > 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? You need to build a new kernel with lines options SYSVSHM options SYSVSEM options SYSVMSG Doug White | University of Oregon Internet: dwhite@resnet.uoregon.edu | Residence Networking Assistant http://gladstone.uoregon.edu/~dwhite | Computer Science Major To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message