postgresql questions

From: Chan Fook Sheng <chen68(at)hotmail(dot)com>
To: "freebsd-questions(at)FreeBSD(dot)ORG" <freebsd-questions(at)FreeBSD(dot)ORG>, pgsql-admin(at)postgresql(dot)org
Subject: postgresql questions
Date: 1998-06-02 10:08:49
Message-ID: 3573CF31.8AE747D6@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message The Hermit Hacker 1998-06-02 11:56:33 Re: [ADMIN] postgresql questions
Previous Message Jackson, DeJuan 1998-06-01 20:43:19 RE: [ADMIN] Installing postgres on redhat 5.0