Stop postgreSQL Processes/Daemon

[abhishekjain_48]

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

[Torsten.]

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

[abhishekjain_48]

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]

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.

[Torsten.]

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

[Duncan Edmonstone]

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