How to set postgres process in monit file?

Login or Register to Ask a Question and Join Our Community

How to set postgres process in monit file?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums UNIX for Advanced & Expert Users How to set postgres process in monit file?

02-21-2013

Registered User

25, 0

Join Date: Feb 2010

Last Activity: 22 February 2013, 8:07 AM EST

Posts: 25

Thanks Given: 0

Thanked 0 Times in 0 Posts

How to set postgres process in monit file?

Dear Friends,

I need to add the postgres process in monit file ( Debian machine ). How to add that process in monit?. If anyone know the solution for this, pls let me know.

---------- Post updated at 02:27 PM ---------- Previous update was at 12:21 PM ----------

I have found the way to add the postgres process in monit file.

Using the following steps we can add the postgres process in monit.

/etc/monit/monitrc ( Monit filename )
------------------------------
# vim /etc/monit/monitrc
set daemon 120
check process postgres
with pidfile /var/run/crond.pid1
start = "/etc/init.d/postgresql-8.3 start"
stop = "/etc/init.d/postgresql-8.3 stop"

- Whenever postgres process is down it will start the process automatically with the help of monit.

rekha_sri

View Public Profile for rekha_sri

Find all posts by rekha_sri

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Htop process viewer - set column width

I try to enlarge the htop column's width. I've found a solution, but it seems very specific and also too difficult. Is there any simpler way to make all the characters in a column visible?

2. Shell Programming and Scripting

Postgres in Linux

I have this 15 postgres sql queries similar to below to run in linux... Its taking a lot of time to run (3hours) . can any one plz guide me how can i reduce the time of execution execute 'insert into cc.rpt_cons_sub_ccdb_data(report_date, server_name, report_type, count) select...

3. Solaris

Child killing parent process and how to set up SMF

Hello, A little background on what we are doing first. We are running several applications from a CLI, and not all of them are fully functional. They do on occasion core dump, not a problem. We are running a service that takes a screen scrape of those apps and displays them in a more user...

4. Red Hat

process fails if setuid bit is set

Hi, OS : Linux I have an executable (P1) owned by user say "abcd" and the setuid bit is set. And there is another executable (P2) which brings up the process (P1). When the setuid bit is set, the process P1 is failing, if the setuid bit is not set there is no issue. I was wondering if...

5. Solaris

Set up TTL on process

Is there a way to setup the TTL (Time To Live) on a process. We have many ssh processes that seem to just stack up. These processes do not need a static connection all the time and it might cause problems on our servers. Does anybody know how to setup the TTL on a process?

6. AIX

monit similar in AIX

Hi Do you know if there is a similar tool like monit in AIX's packages? thanks Regards Israel.

7. Red Hat

cannot set user id: Resource temporarily unavailable (not open file/open process related)

First post, sorry to be a bother but this one has been dogging me. I have a process user (java application server) that trips a resource limit every couple weeks and need help finding what limit we're hitting. First, this is what's running: This is the error when jobs are run or the...

8. Shell Programming and Scripting

How to get and process mysql result set in shell script

Hi All, I am in a problem here is the description, Actually in my shell script i am firing a mysql query which returns multiple records and i have to process each record one by one. So could any one please suggest me how to solve my problem? Thanks in Advance Ashok Sharma

9. AIX

3004-505 Cannot set process environment

Guys I have an AIX 5.3 box.I am getting following messages if i try to switch to any non root user. bash-3.00# su - sys 3004-505 Cannot set process environment. bash-3.00# su - daemon 3004-505 Cannot set process environment. bash-3.00# su - adm 3004-505 Cannot set process environment....

10. UNIX for Advanced & Expert Users

login error(can not set process env.)

I have created user in AIX 4.3.3 which the member of staff group. but during login ( with su command) it gives the error "can not set process environment " but when it is member of another group -dba -which is the group for oracle database- it works properly. Pls let me know the solution. ...

Login or Register to Ask a Question

LEARN ABOUT DEBIAN

wiki-toolkit-setupdb

WIKI-TOOLKIT-SETUPDB(1p)				User Contributed Perl Documentation				  WIKI-TOOLKIT-SETUPDB(1p)

NAME

       wiki-toolkit-setupdb - Set up a database storage backend for Wiki::Toolkit.

SYNOPSIS

	 # Set up or update the storage backend, leaving any existing data
	 # intact. Useful for upgrading from old versions of Wiki::Toolkit to
	 # newer ones with more backend features.

	 wiki-toolkit-setupdb --type postgres
			      --name mywiki 
			      --user wiki  
			      --pass wiki 
			      --host 'db.example.com'

	 # Clear out any existing data and set up a fresh backend from scratch.

	 wiki-toolkit-setupdb --type postgres
			      --name mywiki 
			      --user wiki  
			      --pass wiki  
			      --force-preclear

DESCRIPTION

       Takes three mandatory arguments:

       type
	   The database type.  Should be one of 'postgres', 'mysql' and 'sqlite'.

       name
	   The database name.

       user
	   The user that connects to the database. It must have permission to create and drop tables in the database.

       two optional arguments:

       pass
	   The user's database password.

       host
	   The hostname of the machine the database server is running on (omit for local databases).

       and one optional flag:

       force-preclear
	   By default, this script will leave any existing data alone.	To force that to be cleared out first, pass the "--force-preclear" flag.

AUTHOR

       Kake Pugh (kake@earth.li).

COPYRIGHT

	    Copyright (C) 2002-2003 Kake Pugh.	All Rights Reserved.
	    Copyright (C) 2006 the Wiki::Toolkit team. All Rights Reserved.

       This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       Wiki::Toolkit

perl v5.14.2							    2011-09-25						  WIKI-TOOLKIT-SETUPDB(1p)