Skip site navigation (1) Skip section navigation (2)

Re: newbie question (pete collins)

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: (view raw, whole thread or download thread mbox)
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

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


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.



pgsql-admin by date

Next:From: GavinDate: 1998-10-21 07:04:18
Subject: Postgres SQL 6.3.2
Previous:From: pete collinsDate: 1998-10-20 12:16:18
Subject: newbie question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group