Thread: postgresql questions
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
On Tue, 2 Jun 1998, Chan Fook Sheng wrote:
> 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?
The error message is pretty self-explanatory, no? You don't have
SYSVSEM compiled into your kernel...
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