From: | "Carilda A(dot) Thomas" <agacat(at)earthlink(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: newbie question (pete collins) |
Date: | 1998-10-21 06:21:47 |
Message-ID: | 362D7D7B.5C916667@earthlink.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
pete(at)postpagan(dot)com wrote:
i installed postgre from the freebsd port
everything installed fine
pgsql deamon is running
bash-2.02$ ps aux
pgsql 166 0.0 0.4 1244 1060 ?? Is 8:39PM 0:00.00
/usr/local/pgsql/bin/postmaster -i -S -o -F -D/usr/local/pgsql/data
(postgre
i set my path variables
so when i run:
bash-2.02$ psql template1
Connection to database 'template1' failed.
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.
it dies
now when i run ps aux the postmaster deamon gone
help
pete
ocs design
=========================================================================
Pete, probably your FreeBSD kernel was built without semaphores. In
this case, postgresql will start up just fine until you make a request
to it. The request will try to spawn a backend and communicate with a
semaphore, but not finding semaphores available, it will then shut down.
You can determine if this is your problem by typing:
#> ipcs
This will give you a list of your interprocess communication
facilities. If you don't see semaphores listed -- you don't have
them. Apparently, the default in FreeBSD is to build without -- either
you or your sysadmin needs to rebuild the kernel.
You will then just have to replace the kernel -- I forget what it's
called in FreeBSD. You will NOT have to rebuild the postgresql.
Enjoy!
cat
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin | 1998-10-21 07:04:18 | Postgres SQL 6.3.2 |
Previous Message | pete collins | 1998-10-20 12:16:18 | newbie question |