From: | Doug White <dwhite(at)gdi(dot)uoregon(dot)edu> |
---|---|
To: | Chan Fook Sheng <chen68(at)hotmail(dot)com> |
Cc: | "freebsd-questions(at)FreeBSD(dot)ORG" <freebsd-questions(at)FreeBSD(dot)ORG>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: postgresql questions |
Date: | 1998-06-03 07:14:42 |
Message-ID: | Pine.BSF.3.96.980603001345.22038o-100000@gdi.uoregon.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)resnet(dot)uoregon(dot)edu | Residence Networking Assistant
http://gladstone.uoregon.edu/~dwhite | Computer Science Major
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Dillon | 1998-06-04 00:09:08 | user auth & passwords |
Previous Message | The Hermit Hacker | 1998-06-03 01:20:01 | Re: [ADMIN] problem with initdb |