topic Re: Stop postgreSQL Processes/Daemon in Operating System - HP-UX

Stop postgreSQL Processes/Daemon

abhishekjain_48 — Tue, 26 Feb 2013 12:00:53 GMT

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

Re: Stop postgreSQL Processes/Daemon

Torsten. — Tue, 26 Feb 2013 15:47:05 GMT

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

Re: Stop postgreSQL Processes/Daemon

abhishekjain_48 — Wed, 27 Feb 2013 09:08:28 GMT

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

Re: Stop postgreSQL Processes/Daemon

Matti_Kurkela — Wed, 27 Feb 2013 10:17:54 GMT

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.

Re: Stop postgreSQL Processes/Daemon

Torsten. — Wed, 27 Feb 2013 12:15:33 GMT

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

Re: Stop postgreSQL Processes/Daemon

Duncan Edmonstone — Wed, 27 Feb 2013 16:49:59 GMT

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