Re: BUG #7596: Problem with /etc/init.d/postgresql.9.x file - Mailing list pgsql-bugs

<meta content=3D"text/html;charset=3DUTF-8" http-equiv=3D"Content-Type"=
>


Hi,
with rpm.


Ashesh Vashi a =C3=A9crit=C2=A0:
<blockquote
 cite=3D"mid:CAG7mmowVVHR0hgo7+VPSLqjK1xMVhA657voMHcHDxEzM+dZgqg@mail.gma=
il.com"
 type=3D"cite">On Thu, Oct 11, 2012 at 2:59 PM, <<a
 moz-do-not-send=3D"true" href=3D"mailto:david.peyrieres@meteo.fr"
 target=3D"_blank">david.peyrieres@meteo.fr> wrote:

  <blockquote class=3D"gmail_quote"
 style=3D"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: =C2=A0 =C2=A0 =C2=A07596
Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0David PEYRIERES
Email address: =C2=A0 =C2=A0 =C2=A0<a moz-do-not-send=3D"true"
 href=3D"mailto:david.peyrieres@meteo.fr">david.peyrieres@meteo.fr<br=
>
PostgreSQL version: 9.1.4
Operating system: =C2=A0 Red Hat
Description:

  Hi David,


  How did you install postgresql?

  <span
 style=3D"font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-se=
rif;"><span
 style=3D"font-size: x-small;"><span
 style=3D"font-family: 'courier new',monospace;">--<span
 style=3D"font-style: italic; font-family: 'courier new',monospace;"><spa=
n
 style=3D"font-size: small;">
  <span
 style=3D"font-size: 13.3px; font-family: Verdana,Arial,Helvetica,sans-se=
rif;">

  <span
 style=3D"font-family: 'courier new',monospace;"><span
 style=3D"font-style: italic; font-family: 'courier new',monospace;"><spa=
n
 style=3D"font-size: small;">Thanks & Regards,<br
 style=3D"font-style: italic; font-family: 'courier new',monospace;">
  <span
 style=3D"font-style: italic; font-family: 'courier new',monospace; font-=
size: small;">Ashesh
Vashi


  <blockquote class=3D"gmail_quote"
 style=3D"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<=
br>
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=3D"/var/run/${NAME}.pid

2 - and case test :
....
case "$1" in
=C2=A0 ....
=C2=A0status)
=C2=A0 =C2=A0status -p /var/run/postmaster-9.1.pid
by
=C2=A0 =C2=A0status -p $pidfile



Thanks for all.






--
Sent via pgsql-bugs mailing list (<a moz-do-not-send=3D"true"
 href=3D"mailto:pgsql-bugs@postgresql.org">pgsql-bugs@postgresql.org)=

To make changes to your subscription:
    <a moz-do-not-send=3D"true"
 href=3D"http://www.postgresql.org/mailpref/pgsql-bugs" target=3D"_blank"=
>http://www.postgresql.org/mailpref/pgsql-bugs





--




<link rel=3D"File-List" href=3D"./signature_david_MF_fichiers/filelist.xm=
l">


  david.peyrieres
  david.peyrieres
  2
  1
  2011-12-01T08:34:00Z
  2011-12-01T08:35:00Z
  1
  48
  275
  Meteo France
  2
  1
  337
  9.6926



  21



<!--
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
    {mso-style-parent:"";
    margin:0cm;
    margin-bottom:.0001pt;
    mso-pagination:widow-orphan;
    font-size:12.0pt;
    font-family:"Times New Roman";
    mso-fareast-font-family:"Times New Roman";
    color:black;}
a:link, span.MsoHyperlink
    {color:blue;}
a:visited, span.MsoHyperlinkFollowed
    {color:blue;}
@page Section1
    {size:595.3pt 841.9pt;
    margin:70.85pt 70.85pt 70.85pt 70.85pt;
    mso-header-margin:35.4pt;
    mso-footer-margin:35.4pt;
    mso-paper-source:0;}
div.Section1
    {page:Section1;}
-->








<span
 style=3D"font-size: 10pt; font-family: Arial; color: rgb(0, 28, 77);">Da=
vid
PEYRIERES
<span
 style=3D"font-size: 7.5pt; font-family: Arial; color: rgb(0, 28, 77);">D=
irection
des Syt=C3=A8mes d'Information
Division Etudes et D=C3=A9veloppements

Tel : =C2=A0 +33 (0)5.61.07.83.36
Fax :=C2=A0 +33 (0)5.61.07.81.09
<span
 style=3D"font-size: 10pt; font-family: Arial; color: rgb(0, 28, 77);"><a
 href=3D"mailto:david.peyrieres@meteo.fr">david.peyrieres@meteo.fr<br=
>

METEO FRANCE<span
 style=3D"font-family: Arial; color: rgb(0, 28, 77);"> <span
 style=3D"font-size: 10pt; font-family: Arial; color: rgb(0, 28, 77);"><b=
r>
www.meteo.fr <span
 style=3D"font-size: 7.5pt; font-family: Arial; color: rgb(0, 28, 77);"><=
br>
42 avenue Gustave Coriolis
31057 TOULOUSE C=C3=A9dex