postgresql service failed to start or stop

purohit.mayur · 01-06-2010, 12:09 AM

HI I am using RHEL 5.0. I am having problem with postgresql service it is not starting, not stopping, not restarting.

Aquarius_Girl · 01-06-2010, 01:19 AM

Execute

Code:

ps -el

and try to locate postmaster in the resultant list.

If you don't find it there, then show the command with which u are trying to start postgresql.

Meanwhile look here : http://www.yolinux.com/TUTORIALS/Lin...ostgreSQL.html

purohit.mayur · 01-07-2010, 01:47 AM

Quote:

Originally Posted by purohit.mayur

HI I am using RHEL 5.0. I am having problem with postgresql service it is not starting, not stopping, not restarting.

Hiii
I didn't find the postmaster in that resultant list

i m using following command to restart postgresql
service postgresql restart
or chkconfig postgreql on

Aquarius_Girl · 01-07-2010, 02:01 AM

Execute the following commands in a sequential order and post their outputs:

initdb --pgdata=/var/lib/pgsql/data

/usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster -l logfile start &

And I guess u didn't read the link I pointed to !

purohit.mayur · 01-07-2010, 03:19 AM

Quote:

Originally Posted by anishakaul

Execute the following commands in a sequential order and post their outputs:

initdb --pgdata=/var/lib/pgsql/data

/usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster -l logfile start &

And I guess u didn't read the link I pointed to !

I got the following reply

initdb --pgdata=/var/lib/pgsql/data
reply- bash: initdb --pgdata=/var/lib/pgsql/data : no such file or directory
&

/usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster -l logfile start &
reply- [1] 3521
/usr/bin/pg_ctl -D : no such file or directory

Aquarius_Girl · 01-07-2010, 03:36 AM

The following link contains the solutions of the problems U are facing on RHEL,

STUDY IT LINE BY LINE

http://www.redhat.com/support/resour...s-install.html