System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

Stop postgreSQL Processes/Daemon

Stop postgreSQL Processes/Daemon

Hi ,

 

i just found that postgreSQL Processes/Daemons are running.

 

Can any one tell me a way to stop postgreSQL Processes/Daemon.

 

Regards

Abhishek J

 

 

5 REPLIES
Torsten.
Acclaimed Contributor

Re: Stop postgreSQL Processes/Daemon

You should first investigate what processes are using it, maybe some important internal processes?


Hope this helps!
Regards
Torsten.

__________________________________________________
There are only 10 types of people in the world -
those who understand binary, and those who don't.

__________________________________________________
No support by private messages. Please ask the forum!

If you feel this was helpful please click the KUDOS! thumb below!   

Re: Stop postgreSQL Processes/Daemon

Hi

 

I found this postgreSQL is running for SFM i.e system fault management.

I know i should not disable it but in case if i need to do how can I do so?

 

I found, It can be disabled using below command:

 

su <postgreSQL_User> -c "<pg_ctl location> -D <datfile_path>  stop -m immediate"

 

I got all he neccesasry parametres but could not get datfile_path.

 

Could you please tell whereto get this filepath and is tiis the correct procedure to stop postgreSQL ??

 

can i also kill the processes running??

 

 

Regards

AbhishekJ

 

Matti_Kurkela
Honored Contributor

Re: Stop postgreSQL Processes/Daemon

Killing a database process is never a good idea, unless you understand the database engine and know for sure that it will not be harmful.

 

If you know that this postgreSQL is running for SFM, then stopping SFM should stop the database too.

(Without the database, the rest of SFM will be seriously crippled, so there is no point of leaving the rest of SFM running if you stop its database.)

 

If you still want to do it, you should read the startup/shutdown script for SFM. It probably includes the commands to start/stop its database, or calls other scripts for that purpose. By reading the script(s), you should find the correct paths to use.

MK
Torsten.
Acclaimed Contributor

Re: Stop postgreSQL Processes/Daemon

SFM (system fault management) is kind of online diagnostic / monitoring software for your server - you should NOT disable it!


Hope this helps!
Regards
Torsten.

__________________________________________________
There are only 10 types of people in the world -
those who understand binary, and those who don't.

__________________________________________________
No support by private messages. Please ask the forum!

If you feel this was helpful please click the KUDOS! thumb below!   
Duncan Edmonstone
Honored Contributor

Re: Stop postgreSQL Processes/Daemon

I'm with Torsten on this - son't go fiddling with SFM unless you actually have a problem with it... but if you insist the start/stop rc script is /sbin/init.d/psbdb

 

Take a look at that and you should see the necesssary commands


HTH

Duncan