Quick Links

Re: BUG #7596: Problem with /etc/init.d/postgresql.9.x file

From:	"david(dot)peyrieres" <david(dot)peyrieres(at)meteo(dot)fr>
To:	Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc:	pgsql-bugs(at)postgresql(dot)org
Subject:	Re: BUG #7596: Problem with /etc/init.d/postgresql.9.x file
Date:	2012-10-12 06:03:55
Message-ID:	5077B2CB.8090402@meteo.fr
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hi, 
with rpm. 
</tt> 
 
Ashesh Vashi a écrit :
<blockquote
cite="mid:CAG7mmowVVHR0hgo7+VPSLqjK1xMVhA657voMHcHDxEzM+dZgqg(at)mail(dot)gmail(dot)com"
type="cite">On Thu, Oct 11, 2012 at 2:59 PM, <<a
moz-do-not-send="true" href="mailto:david(dot)peyrieres(at)meteo(dot)fr"
target="_blank">david(dot)peyrieres(at)meteo(dot)fr</a>> wrote: 
<div class="gmail_quote">
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The
following bug has been logged on the website: 
 
Bug reference: 7596 
Logged by: David PEYRIERES 
Email address: <a moz-do-not-send="true"
href="mailto:david(dot)peyrieres(at)meteo(dot)fr">david(dot)peyrieres(at)meteo(dot)fr</a> 
PostgreSQL version: 9.1.4 
Operating system: Red Hat 
Description: 
</blockquote>
<div>Hi David,</div>
<div> 
</div>
<div>How did you install postgresql?</div>
 
-- 
<div>
<div style="margin: 0pt 0pt 8px;">
Thanks & Regards, 
Ashesh
Vashi
</div>
</div>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> 
Hello. 
I found a little bug in /etc/init.d/postgresql-9.x file (ok in 8.4 -
since 
9.x versions ?). 
In my case, I've 5 databases on same server. Each database is start/stop 
with this file 'service postgresql9.x start'. 
Unfortunately, it uses only same file for status "pidfile: 
/var/run/postmaster-9.2.pid". 
In my case and with this configuration, I have only one file for all 
databases. 
So, I've modified this file on all servers : 
 
1 - pidfile="/var/run/${NAME}.pid 
 
2 - and case test : 
.... 
case "$1" in 
.... 
status) 
status -p /var/run/postmaster-9.1.pid 
by 
status -p $pidfile 
 
 
 
Thanks for all. 
 
 
 
 
 
 
-- 
Sent via pgsql-bugs mailing list (<a moz-do-not-send="true"
href="mailto:pgsql-bugs(at)postgresql(dot)org">pgsql-bugs(at)postgresql(dot)org</a>) 
To make changes to your subscription: 
<a moz-do-not-send="true"
href="http://www.postgresql.org/mailpref/pgsql-bugs" target="_blank">http://www.postgresql.org/mailpref/pgsql-bugs</a> 
</blockquote>
</div>
 
</blockquote>
 
<div class="moz-signature">-- 
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 9">
<meta name="Originator" content="Microsoft Word 9">
<link rel="File-List" href="./signature_david_MF_fichiers/filelist.xml">

<style>

</style>
<div class="Section1">
 
David
PEYRIERES 
Direction
des Sytèmes d'Information 
Division Etudes et Développements 
 
Tel : +33 (0)5.61.07.83.36 
Fax : +33 (0)5.61.07.81.09 
<a
href="mailto:david(dot)peyrieres(at)meteo(dot)fr">david(dot)peyrieres(at)meteo(dot)fr</a> 
 
METEO FRANCE 
<a href="http://www.meteo.fr/">www.meteo.fr</a> 
42 avenue Gustave Coriolis 
31057 TOULOUSE Cédex 
</div>
</div>
</body>
</html>

Attachment	Content-Type	Size
unknown_filename	text/html	6.2 KB

In response to

Re: BUG #7596: Problem with /etc/init.d/postgresql.9.x file at 2012-10-11 09:32:43 from Ashesh Vashi

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	John R Pierce	2012-10-12 06:49:08	Re: BUG #7596: Problem with /etc/init.d/postgresql.9.x file
Previous Message	Tom Lane	2012-10-11 19:36:02	Re: Fwd: race in pg_ctl start -w