From owner-freebsd-questions Tue Jun 2 03:08:20 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id DAA24042 for freebsd-questions-outgoing; Tue, 2 Jun 1998 03:08:20 -0700 (PDT) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from mail.capgemini.com.sg ([203.116.11.115]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id DAA24024 for ; Tue, 2 Jun 1998 03:08:05 -0700 (PDT) (envelope-from chen68@hotmail.com) Received: from hotmail.com (123.capgemini.com.sg [10.64.0.89]) by mail.capgemini.com.sg (post.office MTA v2.0 0813 ID# 0-16936) with ESMTP id AAA117; Tue, 2 Jun 1998 18:06:24 +0800 Message-ID: <3573CF31.8AE747D6@hotmail.com> Date: Tue, 02 Jun 1998 18:08:49 +0800 From: Chan Fook Sheng Organization: fschan@capgemini.com.sg X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: "freebsd-questions@FreeBSD.ORG" , pgsql-admin@postgresql.org Subject: postgresql questions Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hello everybody, I have some questions on Postgresql, pls help me if you can. I have installed postgresql 6.2.1on FreeBSD 2.2.6. To start it, I must first start the postmaster running, so I : 1) su pgsql (this account I think was created during the installation) 2) postmaster (I get this message :"postmaster does not know where to find the database system data. you must specify the directory that contains the database system either by specifying the -D invocation option or by setting the PGDATA environment variable". ) 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 . 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? Best Regards, chan To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message