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
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 |