It has been impossible to install PostgreSQL, an open
source
software, from my SUSE 8.0 . Although it tells you its
been installed, each time i try to start it using
SysV-Init Editor, i get the following message:

<start>starting</start><cmd>/etc/init.d/postgresql</cmd>""<br/>
starting postgreSQL
/etc/init.d/postgresql.checkproc:command not found
.....done

What exactly am i doing wrong? Or better still, what
haven't i done yet? Please help me

Newton Eyinagho






__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Hi

Does this file /etc/init.d/postgresql.checkproc exist? Does the
postmaster process show up if you type 'ps -A' in a console? If it does,
PostgreSQL is installed and running. The checkproc command is probably
only there to check whether PostgreSQL has started correctly.

SuSE 8.0 is quite old, probably a newer version wouldn't be bad. You can
also install the newest PostgreSQL version from source
(http://www.postgresql.org/mirrors-ftp.html).

Arthur

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Dear Arthur,

Thanks so much for response and help on my cry for
help. I've tried the 'ps -a' you asked me to try and
the result it gave was as follows:

PID TTY TIME CMD
------------------------------
1070 pts/1 00:00:00 su
1071 pts/1 00:00:00 bash
1076 pts/1 00:00:00 ps

In addition to that, i also tried to use the caps form
of the command, ie 'PS -A' and what i got was as
follows:

bash: PS: command not found


When i tried another form of the command, ie 'ps -A' ,
i got a series of numbers just like the first result
above. The numbers started from 1, 2, 3, etc up until
the last set 1070, 1071, and 1076. They were also
listed under PID, TTY, TIME,and CMD.

What does this indicate? Its interesting to note that
postgreSQL wasn't in any of the various words listed
under CMD. I only found words like init, keventd,
kapad, etc.


As to your question of whether this file
/etc/init.d/postgresql.checkproc exists, i found that
it doesn't. Whilst i could navigate to the directory
'etc' using cd /etc, i could not do same for init.d
although it was one of the files listed under 'etc'
when you do an 'ls' command.


Kindly help please.


Newton Eyinagho




































__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Hi
'ps -a ' isn't worth much, it only gives the processes of the current
terminal you're working on.

It's 'ps -A' not 'PS -A'. This should give you _all_ processes
(depending a bit on your version of ps, but most of those shipped with
current distros are like that. Else have a look at 'man ps').

The process PostgreSQL runs under is called 'postmaster'. Have a look
for that. You could also try 'ps -A|grep postmaster' which filters out
only the lines with 'postmaster' in it.

Uhm, if you type 'cd /etc/init.d/' without the '.d' or anything missing,
this should definitely work.

As your problems are more related to linux than to PostgreSQL I'd
recommend you to subscribe to a linux mailing list fitting the
distribution you're using.

Arthur

P.S: Try to keep your messages free from superfluous empty lines.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Sat, Aug 21, 2004 at 10:38:26AM -0700, Eyinagho Newton wrote:
IIRC SuSE 8.0 requires you to use the command rcpostgresql as root when you
have just installed postgresql. It will do the initdb and other things
necessary to get postgresql running.

#which checkproc
/sbin/checkproc


You may have to log in as root to run /etc/init.d/postgresql start, or even configure
it in the SysV-Init Editor

HTH

- Martin -

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend