[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] shared_preload_libraries
From:       dx k9 <bitsandbytes88 () hotmail ! com>
Date:       2011-03-31 20:04:09
Message-ID: SNT113-W31033286AFFEA4DB8197AED1BF0 () phx ! gbl
[Download RAW message or body]

Hi all,

 

We are using 9.03

Having shared_preload_libraries = 'auto_explain, pg_stat_statements' set in the conf \
file causes some one starting up postgres to manually have to hit the enter key.  \
Suprresing this output with pg_ctl would be the best option,  but I don't it as an \
option(silent doesn't cut it).  We have a workaround rediriecting stdout to  '> \
/dev/null', but I was hoping for a better solution.  What about permanently loading \
these libraries with ld.so.conf ?

 

~DjK

 

 

 

 

Starting PostgreSQL:
ok
postgres@system1:~> <   2011-03-31 15:01:08 EDT> LOG:  loaded library "auto_explain"
<   2011-03-31 15:01:08 EDT> LOG:  loaded library "pg_stat_statements"

 		 	   		  


[Attachment #3 (text/html)]

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hi all,<BR>
&nbsp;<BR>
We are using 9.03<BR>
Having shared_preload_libraries = 'auto_explain, pg_stat_statements' set in the conf \
file causes some one starting up postgres to manually have to hit the enter \
key.&nbsp;&nbsp;Suprresing this output with pg_ctl would be the best option, \
&nbsp;but I don't it as an option(silent doesn't cut it).&nbsp; We have a workaround \
rediriecting&nbsp;stdout to&nbsp; '&gt; /dev/null', but I was hoping for a better \
solution.&nbsp; What about permanently loading these \
libraries&nbsp;with&nbsp;ld.so.conf ?<BR> &nbsp;<BR>
~DjK<BR>
&nbsp;<BR>
&nbsp;<BR>
&nbsp;<BR>
&nbsp;<BR>
Starting PostgreSQL:<BR>ok<BR><A \
href="mailto:postgres@system1">postgres@system1</A>:~&gt; &lt;&nbsp;&nbsp; 2011-03-31 \
15:01:08 EDT&gt; LOG:&nbsp; loaded library "auto_explain"<BR>&lt;&nbsp;&nbsp; \
2011-03-31 15:01:08 EDT&gt; LOG:&nbsp; loaded library "pg_stat_statements"<BR><BR> 		 \
</body> </html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic