Thread: Installing PostgreSQL in a Linux Environment

Installing PostgreSQL in a Linux Environment

From
Eyinagho Newton
Date:
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

Re: Installing PostgreSQL in a Linux Environment

From
Arthur van Dorp
Date:
Hi

> 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

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

Re: Installing PostgreSQL in a Linux Environment

From
Eyinagho Newton
Date:
























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

Re: Installing PostgreSQL in a Linux Environment

From
Arthur van Dorp
Date:
Hi
> 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

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

> 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

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').

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

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.

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

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.


Re: Installing PostgreSQL in a Linux Environment

From
Martin Atukunda
Date:
On Sat, Aug 21, 2004 at 10:38:26AM -0700, Eyinagho Newton wrote:
>
> 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

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 -