Search This Blog

Sunday, November 7, 2010

Simple script to monitor replication in PostgreSQL 9

Here is the simple script to monitor PostgreSQL replication on FreeBSD:

========= Cut here =========
#!/bin/sh

# Timeout in seconds
readonly timeout=600

last_chkp=`pg_controldata /var/db/pgsql/ | grep "Time of latest checkpoint" | sed "s/.*checkpoint: *//"`
last_chkp=`date -j -f "%a %b %d %T %Z %Y" "$last_chkp" "+%s"`

now=`date`
now=`date -j -f "%a %b %d %T %Z %Y" "$now" "+%s"`

if [ `expr $now - $last_chkp` -gt $timeout ]; then
echo Replication kaput!
fi

60 comments:

Anonymous said...

Good article. Thank you.
http://www.erispan.350.com/

Order Levitra said...

You have a very good blog that the main thing a lot of interesting and useful!

Anonymous said...

[url=http://directlenderloansonlinedirectly.com/#srhyg]payday loans online[/url] - payday loans online , http://directlenderloansonlinedirectly.com/#uoflk payday loans online

Anonymous said...

[url=http://cheapviagradirectly.com/#ymhjr]viagra without prescription[/url] - viagra online , http://cheapviagradirectly.com/#bqwcm viagra 130 mg

Anonymous said...

[url=http://viagranowdirectly.com/#cpzlq]viagra 50 mg[/url] - cheap viagra , http://viagranowdirectly.com/#qppew viagra without prescription

Anonymous said...

[url=http://buyclomiddirectly.com/#qopdq]clomid 100 mg[/url] - buy clomid online , http://buyclomiddirectly.com/#uwjhx clomid online without prescription

Anonymous said...

ambien reactions ambien kidneyambien 2.5 mg side effects

Anonymous said...

[url=http://buycialispremiumpharmacy.com/#paylc]cialis online[/url] - buy cialis , http://buycialispremiumpharmacy.com/#ykmlb buy cheap cialis

Anonymous said...

[url=http://buyviagrapremiumpharmacy.com/#grboo]buy cheap viagra[/url] - buy cheap viagra , http://buyviagrapremiumpharmacy.com/#vjbwu buy viagra online

Anonymous said...

[url=http://buycialispremiumpharmacy.com/#vynrx]buy cheap cialis[/url] - generic cialis , http://buycialispremiumpharmacy.com/#ghjsb buy cialis

Anonymous said...

[url=http://buyviagrapremiumpharmacy.com/#geeja]buy viagra[/url] - buy viagra , http://buyviagrapremiumpharmacy.com/#kcrog buy viagra online

Anonymous said...

[url=http://viagraboutiqueone.com/#zeing]cheap viagra online[/url] - viagra online , http://viagraboutiqueone.com/#thquy generic viagra

Anonymous said...

[url=http://buyonlineaccutaneone.com/#zqcvd]order accutane[/url] - buy accutane online , http://buyonlineaccutaneone.com/#upfrz accutane without prescription

Anonymous said...

The ECB would must accept this kind of scheme, needless to say. These layoffs are occurring as a result of bank settlement talks and falling stocks, which may have declined approximately 50% over the course of annually [url=http://onlinepaydayloans-4u.co.uk]UK Payday Loans[/url] and then last question, could you talk in regards to the combination of business in default services. After causeing this to be decision, then you definately have to come up with a choice around the form of loan you want under this unique category. He will officially join Milan on 28 December and will stay using the club until their season ends online payday loans use the following tips to pay your mortgage better. Which personal loan from the bank is better at floating or one-time fee. Borrower may offer every other collateral up against the loan like home, jewelries or any other valuable asset http://onlinepaydayloans-4u.co.uk/ some particular rules may vary for each and every with the types in in accordance with eligibility, investment limits and withdrawal procedures.

Anonymous said...

The activity sheets are liberated to print from PDF,
and coordinate with H.E.R. activities.
Get the youngsters outside for a dinosaur search to pretend they are paleontologists and look
for finds.

Feel free to surf to my webpage; cool math games

Anonymous said...

You really make it seem really easy with your presentation however I find this topic to be
actually something that I feel I might by no means understand.
It sort of feels too complicated and very extensive for me.
I'm taking a look ahead for your next put up, I
will attempt to get the hold of it!

Also visit my blog post: battlefield 4 Cheats pc God mode

Anonymous said...

Whats up are using Wordpress for your blog platform?
I'm new to the blog world but I'm trying to get started and
create my own. Do you require any coding expertise to make your own blog?

Any help would be greatly appreciated!

Feel free to visit my site :: goji berry - -

Anonymous said...


the the peak within the appear in online growth

Open markets: Got a number of material to trade like ebooks, videos videos, figurines, false (or possibly authentic) potted plants, perhaps attire [url=http://www.steelecanyon.net/Ping-G20-Irons-goods-179]Ping G20 Irons[/url] in good condition? Rent an important not work along at the nearest flea sector that [url=http://www.steelecanyon.net/TaylorMade-RocketBallz-RBZ-Irons-goods-76]TaylorMade Rocketballz RBZ Irons[/url] will generates [url=http://www.steelecanyon.net/Ping-K15-Driver-goods-169]Ping K15 Driver[/url] numerous customers. Generally basically $5 $15 leases space that has a dinner table. Have a look at to start with for you to breadth your most beneficial not work for one's greenbacks.

Wimzie is usually a Some yr old along with a new mother who has some sort of hen together with air travel head and a parent who will be a monster [url=http://www.steelecanyon.net/Mizuno-MP-59-Irons-goods-251]Mizuno MP-59 Irons[/url] and firefighter. Seeing that the girl's mom is commonly vacationing, your ex dads alter work schedule sometimes enables your man to enjoy moment with her each day; in any other case there is always the girl active together with wild mother Yaya to care for her own. For instance the woman's mom, Wimzie is definitely lively, fearless and tough; like her dad, she is willing to just take challenges and also really likes vests.



http://www.steelecanyon.net

Anonymous said...

gucci computers

Hello! I simply would like to offer you a huge thumbs up
for your excellent information you have right here on this post.
I will be coming back to your web site for more soon.

Anonymous said...

For most small businesses, money is tight these days and any extras can help cut operating
expenses and help the bottom line. Pop is short for point of presence, an access point to the Internet.

Having a top producing web host is vital to your success.


my web page To uncover further information relating to cheap web hosting type a line below.

Anonymous said...

I simply couldn't go away your web site prior to suggesting that I really enjoyed the standard
info an individual provide on your visitors? Is gonna be again steadily in order to check out new posts

Take a look at my blog: hearthstone

Anonymous said...

It's really a great and helpful piece of info. I'm glad that you just shared this useful info
with us. Please keep us up to date like this. Thank you for sharing.


Feel free to visit my blog - how to get laid in community college ()

Anonymous said...

Hello, I enjoy reading all of your article post. I wanted to write a little comment to support
you.

Here is my website; download dying light

Anonymous said...

I appreciate, lead to I found exactly what I used to be having a look
for. You have ended my 4 day long hunt! God Bless you man. Have a great day.
Bye

Look at my web page ... bmi calculator

Anonymous said...

Thanks to my father who informed me about this webpage, this website is really remarkable.


Feel free to visit my weblog hemorrhoid symptoms

Anonymous said...

I am sure this post has touched all the internet people, its really really
good post on building up new weblog.

Also visit my web site - top ten video games

Anonymous said...

Vraiment аttrayant, je pense que ce poste intéresѕerait un potе

My webƄ site; sexe exotique

Guo Guo said...

caihuanglin20150304
timberland boots
michael kors canada
tory burch shoes
louis vuitton outlet
abercrombie and fitch
ugg boots
canada goose outlet
ugg boots
canada goose outlet
cheap nfl jerseys
canada goose
coach outlet
coach factory
canada goose jackets
hollister outlet
toms promo code
coach outlet online
cheap jerseys wholesale
gucci outlet
michael kors outlet
fitflops outlet
tory burch handbags
michael kors handbags
coach factory outlet
burberry scarf
christian louboutin outlet
burberry sale
retro jordans
michael kors outlet online
ralph lauren outlet

chenlina said...

chenlina20150611
oakley sunglasses
hollister clothing
jordan 5
abercrombie and fitch
coach outlet store online
gucci bags
www.louisvuitton.com
michael kors handbags
mont blanc pens
louis vuitton handbags
louis vuitton handbags
hollister kids
michael kors
discount oakley sunglasses
ray ban sungalsses
louis vuitton
louis vuitton outlet
chanel handbags
timberlands
jordan 6 rings
ray ban sunglasses
ray ban outlet
michael kors
coach outlet online
hermes birkin
kevin durant basketball shoes
michael kors outlet online
oakley sunglasses sale
coach factory outlet
kate spade
ray ban outlet
louis vuitton outlet
replica rolex watches
michael kors
gucci handbags
insanity workout
chanel handbags
christian louboutin outlet
hogan outlet
abercrombie store

Da Shuai Guo said...

guowenhao0803
air jordan 4
swarovski crystal
ray ban sunglasses
air max 2014
oakley sunglasses
celine outlet
coach outlet online
barcelona jersey
ray ban sunglasses
new orleans saints jerseys
pandora
louis vuitton outlet
babyliss
cartier love bracelet
coach factory outlet
kobe shoes
coach outlet
vibram fivefingers
nike outlet store
lacoste polo shirts
insanity workout
links of london uk
converse all star
prada shoes
arizona cardinals jerseys
ray ban sunglasses
oakley sunglasses
louis vuitton handbags
instyler ionic styler
juicy couture outlet
cheap mlb jerseys
rolex watches
tory burch outlet
true religion jeans, http://www.truereligionoutletstore.us.com
stuart weitzman boots
cheap football shirts
miami heat jersey
burberry outlet online, http://www.burberryoutletonlinestore.com.co
hollister clothing
nike air max uk

风骚达哥 said...

20150922 junda
abercrombie
Hollister uk
Air Jordan 3 III Retro Free Shipping
louis vuitton
coach outlet
Cheap Jordans For Sale Wholesale
canada goose jackets
Christian Louis Vuitton Red Bottoms
New Louis Vuitton Handbags Outlet
Official Coach Factory Outlet Online Sale
Jordan 13 Shoes For Sale
canada goose outlet
Real Louis Vuitton Bags
nike trainers
Jordan 8 Bugs Bunny
Authentic Louis Vuitton Belts Outlet Store
burberry outlet
Louis Vuitton Bags On Sale
true religion jeans
canada goose outlet online
Lebron James Basketball Shoes Sale
Louis Vuitton Handbags Discount Off
nfl jerseys
Abercrombie T-Shirts
Discount Ray Ban Polarized Sunglasses
coach factory outlet online
Louis Vuitton Outlet USA
celine
Louis Vuitton Luxury Official Website
michael kors outlet

Minko Chen said...

michael kors uk
basketball shoes,basketball sneakers,lebron james shoes,sports shoes,kobe bryant shoes,kobe sneakers,nike basketball shoes,running shoes,mens sport shoes,nike shoes
ferragamo outlet
dallas cowboys
michael kors uk
louis vuitton outlet store
coach outlet online
nike free
hogan,hogan outlet,scarpe hogan,hogan sito ufficiale,hogan interactive
toms outlet
oakley sunglasses wholesale
celine outlet
tory burch outlet online
ugg boots clearance,ugg australia,uggs on sale,ugg slippers,uggs boots,uggs outlet,ugg boots,ugg,uggs
links of london jewellery
chicago bulls
hollister uk
nike outlet store
new york jets
oklahoma city thunder
the north face outlet
1026MINKO

John said...

louis vuitton handbags
louis vuitton
abercrombie & fitch
cheap jordans
cheap uggs for sale
canada goose jackets
christian louboutin outlet
ralph lauren polo
canada goose outlet
michael kors handbags
celine bags
nike roshe run
ugg boots
gucci handbags
michael kors outlet online
coach outlet
ugg outlet
louis vuitton
ugg boots
hollister clothing
toms outlet
coach outlet online
hollister jeans
louis vuitton
louis vuitton outlet online
ugg boots
cheap uggs
coach outlet
louis vuitton outlet stores
oakley sunglasses
gucci shoes
20151125yuanyuan

Chenzhen 20160303chenzhen said...

louis vuitton handbags
air jordan homme
michael kors outlet
true religion sale
lebron james shoes 13
louis vuitton handbags
cheap ray ban sunglasses
coach outlet
louis vuitton handbags
coach factory outlet
cheap oakleys
michael kors outlet
louis vuitton outlet
ralph lauren
louis vuitton outlet stores
tory burch flats
adidas running shoes
nfl jerseys wholesale
michael kors outlet
ugg outlet
copy watches
toms outlet
timberlands
hollister shirts
coach outlet online
oakley sunglasses
kevin durant shoes
oakley vault
nike roshe run
oakley canada
coach outlet
nfl jerseys
michael kors bags
ugg boots
louis vuitton outlet stores
ray ban sunglasses
michael kors handbags
celine bags
insanity workout
ray ban sunglasses outlet
20160321chenzhen

chenlili said...

2016-4-21 xiaobao
ghd hair straighteners
louis vuitton bags
louis vuitton
nike trainers
tory burch sale
michael kors handbags
nike sb shoes
oakley sunglasses wholesale
christian louboutin
celine handbags
mont blanc pens
hollister uk
hollister clothing
air jordans
michael kors outlet
north face outlet
nfl jerseys
cheap jordans
louis vuitton outlet stores
nike basketball shoes
louis vuitton outlet
kate spade handbags
coach outlet
kate spade handbags
nike sb
tory burch outlet
michael kors outlet
oakley sunglasses
adidas shoes
louis vuitton outlet
lebron james shoes
fitflops
michael kors outlet
oakley sunglasses
ralph lauren polo
louis vuitton outlet
replica watches
caoch outlet
michael kors outlet online
adidas superstar

chenlili said...

2016-4-21 xiaobao
longchamp handbags
christian louboutin outlet
cheap jordan shoes
louis vuitton handbags
coach outlet online
air jordan retro
polo ralph lauren
toms shoes
oakley outlet
adidas uk
michael kors outlet clearance
jordans
fitflop sandals
coach outlet
ray ban sunglasses
michael kors handbags
coach factorty outlet
nike outlet store
tory burch outlet
nike outlet store
ray ban
adidas originals
ugg boots
ray ban wayfarer
ray ban sunglasses
polo ralph lauren
oakley vault
coach factory outlet
christian louboutin outlet
louis vuitton handbags
michael kors outlet online
jordan 8s
michael kors outlet
coach factory outlet
adidas originals shoes
ray ban sunglasses
jordan 13
true religion outlet
air jordans
vans shoes

Qing Cai said...

cartier watches
air jordan shoes
ralph lauren polo shirts
ferragamo outlet
michael kors handbags wholesale
ray ban sunglasses
burberry outlet
true religion jeans outlet
nhl jerseys
michael kors online outlet
polo ralph lauren
true religion outlet
kate spade uk
cheap nhl jerseys
michael kors handbags clearance
louis vuitton handbags outlet
coach outlet store
fitflops sale clearance
michael kors handbags sale
coach outlet store
nike tn pas cher
cheap ray ban sunglasses
beats by dre
tory burch outlet online
louis vuitton outlet
lululemon outlet
nike roshe
louis vuitton pas cher
cheap soccer jerseys
beats by dre
cai20160516

Gaia1956 said...

slogans www.airportlimomiami.net www.westlamovers.net www.moversinseattlewa.net neworleansmovingcompany.net teeth implants cost fitness movers in moving companies

John said...

oakley vault sunglasses
omega watches
adidas nmd
ecco shoes
prada outlet
tiffany jewelry outlet
hollister clothing store
nike roshe run women
mont blanc pens outlet
kate spade bags
cheap ray ban sunglasses
coach outlet online
coach outlet online
gucci handbags outlet
rolex replica watches
omega seamaster
coach factory outlet
reebok uk
michael kors outlet clearance
armani jeans
nike air max
ray ban sunglasses
polo ralph lauren outlet
the north face outlet
yeezy boost 350 black
adidas gazelle
louis vuitton bags
cheap ray bans
bottega veneta handbags
north face outlet
adidas shoes uk
adidas trainers
coach factory outlet
201678yuanyuan

Gege Dai said...

ralph lauren outlet
louis vuitton bags
hollister
longchamp pliage
timberland boots
pandora jewelry
ralph lauren uk
coach outlet canada
michael kors outlet online
nike roshe run shoes
adidas trainers
michael kors handbags
new balance shoes
ugg sale
rolex uk
chaussure louboutin
vans shoes
longchamp pliage
tory burch outlet online
cheap michael kors handbags
asics
coach outlet
ghd hair straighteners
mizuno running shoes
cartier watches
michael kors outlet
cartier watches
bottega veneta outlet online
nike outlet store
tiffany jewellery
nike free running
beats headphones
kobe shoes
coach outlet
nike trainers uk
czq20160726

Gege Dai said...

ralph lauren outlet
louis vuitton bags
hollister
longchamp pliage
timberland boots
pandora jewelry
ralph lauren uk
coach outlet canada
michael kors outlet online
nike roshe run shoes
adidas trainers
michael kors handbags
new balance shoes
ugg sale
rolex uk
chaussure louboutin
vans shoes
longchamp pliage
tory burch outlet online
cheap michael kors handbags
asics
coach outlet
ghd hair straighteners
mizuno running shoes
cartier watches
michael kors outlet
cartier watches
bottega veneta outlet online
nike outlet store
tiffany jewellery
nike free running
beats headphones
kobe shoes
coach outlet
nike trainers uk
czq20160726

dong dong23 said...

timberland boots
michael kors outlet
louis vuitton handbags
toms shoes
nike roshe run
louis vuitton outlet
toms shoes
christian louboutin shoes
cheap jordan shoes
cheap nfl jerseys
cheap jordans
true religion outlet
michael kors outlet
adidas originals
kate spade
michael kors outlet online
gucci
jordan shoes
michael kors handbags
louis vuitton
polo ralph lauren outlet
jordan 3 infrared
ed hardy clothing
ghd hair straighteners
christian louboutin sale
oakley sunglasses
jordan 4 toro
toms shoes
adidas originals shoes
michael kors handbags
michael kors outlet clearance
coach factory outlet
ray ban wayfarer
coach outlet
longchamp handbags
true religion outlet
cheap oakley sunglasses
louis vuitton outlet
louis vuitton outlet
vans shoes outlet
20168.1wengdongdong

dong dong23 said...

ugg boots paris
coach canada
timberland outlet
tommy hilfiger outlet
christian louboutin outlet
gucci outlet
louis vuitton
cheap ray ban sunglasses
ghd flat iron
louis vuitton outlet
201610.17wengdongdong

chenmeinv0 said...

retro jordan 13
ray ban outlet
coach outlet store online clearances
seahawks jerseys
michael kors outlet clearance
air max 90
true religion outlet
cheap jordan shoes
ugg outlet
jordan shoes
20172.6chenjinyan

raybanoutlet001 said...

san diego chargers jerseys
nike trainers
cheap nike shoes
indianapolis colts jerseys
dolce and gabbana outlet
jaguars jersey
michael kors handbags
cheap ray bans
miami heat jersey
replica watches

raybanoutlet001 said...

coach outlet
cheap jordan shoes
coach outlet
packers jerseys
boston celtics jersey
replica rolex
gucci sito ufficiale
nike air huarache
nike air max 90
kate spade

shengda xu said...

pandora charms outlet
giants jerseys
oakley sunglasses outlet
red bottom
louis vuitton outlet online
mulberry bags
oakley sunglasses outlet
burberry outlet online
michael kors outlet online
purs jerseys
xushengda0528

shengda xu said...

kd shoes
tory burch outlet online
valentino outlet
yeezy shoes
birkenstock
coach factory outlet online
cheap jordan shoes
louis vuitton outlet online
louis vuitton handbags
ralph lauren sale
xushengda0528

kkk said...

ray ban sunglasses outlet
coach handbags outlet
adidas uk
fitflop
mulberry bags
yeezy boost
montblanc pens
kate spade bags
ray ban sunglasses outlet
nike sneakers
170627yueqin

kkk said...

mbt
ralph lauren sale
fitflops
polo ralph lauren
adidas yeezy boost
mont blanc pens
adidas yeezy boost
true religion
yeezy shoes
coach outlet store online
170626yueqin

aaa kitty20101122 said...

ultra boost
adidas ultra boost
adidas ultra boost uncaged
air jordan
air jordan shoes
michael kors outlet
michael kors
michael kors outlet store

LCc 03 said...

nike air zoom
kyrie 4
adidas eqt
michael kors outlet
nike free run
supreme hoodie

ninest123 said...

ralph lauren outlet
canada goose jackets
cheap oakley sunglasses
adidas shoes
air max 90
kate spade outlet
louis vuitton outlet
jordan shoes
cheap oakley sunglasses
ralph lauren outlet
mt0420

jeje said...

coach handbags
golden goose shoes
superdry uk
air jordan
ferragamo shoes
golden goose sneakers
oakley sunglasses wholesale
polo ralph lauren
mbt shoes
coach outlet online

Yaro Gabriel said...

www0605


ugg boots
christian louboutin outlet
champion clothing
armani exchange
coach outlet online
longchamp handbags
michael kors outlet
cheap football shirts
isabel marant shoes
reebok outlet store

fangyaoting said...

20180616 junda
canada goose outlet
pandora charms
freshjive clothing
alife clothing
ugg outlet
nfl jersey wholesale
ubiq shoes
chrome hearts outlet
pandora charms sale clearance
cheap jordans

fangyaoting said...

20180616 junda
bucks jerseys
pandora
adidas soccer shoes
oakley sunglasses
polo ralph lauren
celtics jerseys
coach outlet canada
dolce and gabbana
fendi handbags
saucony shoes

5689 said...

zzzzz2018.7.30
football soldes
pandora jewelry
ugg boots clearance
christian louboutin shoes
football pas cher
golden goose
ugg boots
hermes belt
mbt
nike factory store

jeje said...

Bottes conçus pour faire les difficultés new balance 999 aztec gold de travail sont conçus pour protéger le travailleur contre les dangers distincts qui pourraient être rencontrés dans différentes circonstances d'emploi. Il peut arrêter la vampire métamorphique qui a provoqué de la tache qui reste pour obtenir un temps prolongé. C'est certainement tout autant que la personne, une flamme particulière va acquérir plus de temps pour commencer le cigare, mais est efficace pour les basket nike air max thea print beige retouches fantastiques. Tout au long de l'année civile, la star a également reçu quatre-vingt-douze trois photos de l'année, en comparaison avec les soixante-huit trois conseils qu'il avait dans chacune des saisons qu'il a jouées ensemble. Cela garantit certainement quelque chose pour tout le monde. Ces cicatrices surélevées sont grandes et irrégulières, se développant souvent bien au-delà des Air Jordan 2 France limites initiales de la plaie et se résorbant rarement seules.

cara menggugurkan hamil said...

now present in your city