查看PostgreSQL的服务状态代码,Shell代码库,德仔网

代码语言
代码分类
【Shell】查看PostgreSQL的服务状态
作者:无鸯 / 发布于2011/11/29/ 1050
<div>sudo su postgres -c 'pg_ctl status -D /opt/local/var/db/postgresql84/defaultdb'
</div>
<div>可以使用下面的命令查看Postgresql的服务运行状态：
<div id="highlighter_817828" class="syntaxhighlighter  bash">
<div class="bar                           ">
<div class="toolbar"><a style="width: 16px; height: 16px" class="item viewSource" title="view source" href="http://www.oschina.net/code/snippet_209431_7392#viewSource">view source</a>
<div class="item copyToClipboard"><object id="highlighter_817828_clipboard" title="copy to clipboard" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="16" type="application/x-shockwave-flash" height="16">
<param name="_cx" value="423" />
<param name="_cy" value="423" />
<param name="FlashVars" value="highlighterId=highlighter_817828" />
<param name="Movie" value="/js/syntax-highlighter-2.1.382/scripts/clipboard.swf" />
<param name="Src" value="/js/syntax-highlighter-2.1.382/scripts/clipboard.swf" />
<param name="WMode" value="Transparent" />
<param name="Play" value="0" />
<param name="Loop" value="-1" />
<param name="Quality" value="High" />
<param name="SAlign" value="" />
<param name="Menu" value="0" />
<param name="Base" value="" />
<param name="AllowScriptAccess" value="always" />
<param name="Scale" value="ShowAll" />
<param name="DeviceFont" value="0" />
<param name="EmbedMovie" value="0" />
<param name="BGColor" value="" />
<param name="SWRemote" value="" />
<param name="MovieData" value="" />
<param name="SeamlessTabbing" value="1" />
<param name="Profile" value="0" />
<param name="ProfileAddress" value="" />
<param name="ProfilePort" value="0" />
<param name="AllowNetworking" value="all" />
<param name="AllowFullScreen" value="false" /></object></div>
<a style="width: 16px; height: 16px" class="item printSource" title="print" href="http://www.oschina.net/code/snippet_209431_7392#printSource">print</a><a style="width: 16px; height: 16px" class="item about" title="?" href="http://www.oschina.net/code/snippet_209431_7392#about">?</a></div>
</div>
<div class="lines">
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="number">1</td>
            <td class="content">"bash plain">% "bash functions">sudo "bash functions">su "bash plain">postgres -c "bash string">'pg_ctl status -D /opt/local/var/db/postgresql84/defaultdb'</td>
        </tr>
    </tbody>
</table>
</div>
</div>
</div>
结果如下：
<div id="highlighter_275365" class="syntaxhighlighter  bash">
<div class="bar                              show">
<div class="toolbar"><a style="width: 16px; height: 16px" class="item viewSource" title="view source" href="http://www.oschina.net/code/snippet_209431_7392#viewSource">view source</a>
<div class="item copyToClipboard"><object id="highlighter_275365_clipboard" title="copy to clipboard" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="16" type="application/x-shockwave-flash" height="16">
<param name="_cx" value="423" />
<param name="_cy" value="423" />
<param name="FlashVars" value="highlighterId=highlighter_275365" />
<param name="Movie" value="/js/syntax-highlighter-2.1.382/scripts/clipboard.swf" />
<param name="Src" value="/js/syntax-highlighter-2.1.382/scripts/clipboard.swf" />
<param name="WMode" value="Transparent" />
<param name="Play" value="0" />
<param name="Loop" value="-1" />
<param name="Quality" value="High" />
<param name="SAlign" value="" />
<param name="Menu" value="0" />
<param name="Base" value="" />
<param name="AllowScriptAccess" value="always" />
<param name="Scale" value="ShowAll" />
<param name="DeviceFont" value="0" />
<param name="EmbedMovie" value="0" />
<param name="BGColor" value="" />
<param name="SWRemote" value="" />
<param name="MovieData" value="" />
<param name="SeamlessTabbing" value="1" />
<param name="Profile" value="0" />
<param name="ProfileAddress" value="" />
<param name="ProfilePort" value="0" />
<param name="AllowNetworking" value="all" />
<param name="AllowFullScreen" value="false" /></object></div>
<a style="width: 16px; height: 16px" class="item printSource" title="print" href="http://www.oschina.net/code/snippet_209431_7392#printSource">print</a><a style="width: 16px; height: 16px" class="item about" title="?" href="http://www.oschina.net/code/snippet_209431_7392#about">?</a></div>
</div>
<div class="lines">
<div class="line alt1">
<table>
    <tbody>
        <tr>
            <td class="number">1</td>
            <td class="content">"bash plain">pg_ctl: server is running (PID: 54248)</td>
        </tr>
    </tbody>
</table>
</div>
<div class="line alt2">
<table>
    <tbody>
        <tr>
            <td class="number">2</td>
            <td class="content">"bash plain">/opt/"bash functions">local"bash plain">/lib/postgresql84/bin/postgres "bash string">"-D" "bash string">"/opt/local/var/db/postgresql84/defaultdb"</td>
        </tr>
    </tbody>
</table>
</div>
</div>
</div>
</div>
<div></div>
试试其它关键字
　服务状态　
同语言下
可能有用的
无鸯贡献的其它代码(2)