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

pgagent

pgagent(1)						      General Commands Manual							pgagent(1)

NAME

       pgAgent - a job scheduler for PostgreSQL.

SYNOPSIS

       pgagent [-f | -t seconds | -r seconds | -l number] {<connect string>}

DESCRIPTION

       Introduced  in  pgAdmin III v1.4, pgAgent is a job scheduling agent for PostgreSQL, capable of running multi-step batch/shell and SQL tasks
       on complex schedules.

       Full documentation of pgAgent is available in pgAdmin III's online help. Launch pgAdmin III (simply type pgadmin3 at  command  prompt)  and
       select  "Help..." from the "Help" menu. Browse through the pgAdmin III documentation until you find "pgAgent". Both database setup and sys-
       tem part of the installation are detailed. You will also find instructions to create jobs and schedules.

OPTIONS

       -f     run in the foreground (do not detach from the terminal)

       -t seconds
	      poll time interval in seconds (default 10)

       -r seconds
	      retry period after connection abort in seconds (>=10, default 30)

       -l verbosity
	      logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default 0)

       <connect string>
	      The connect string required is a standard PostgreSQL libpq connection string (see the PostgreSQL documentation for further details).
	      For example, the following command line will run pgAgent against a server listening on the localhost, using a database called 'pgad-
	      min', connecting as the user 'postgres': /usr/bin/pgagent hostaddr=127.0.0.1 dbname=pgadmin user=postgres

SEE ALSO

       pgadmin3(1)

AUTHORS

       The content of this manual page was mostly ripped from documentation written by the pgAdmin development	team.  It  was	built  by  Raphael
       Enrici <blacknoz@club-internet.fr> for the Debian project (but may be used by others).

								 December 26, 2005							pgagent(1)