Re: [Ext:] Configuration of pgaudit settings in postgreSQL.conf causes postgreSQL to fail to start

From: Troy Hardin <t_hardin69(at)hotmail(dot)com>
To: Allie Crawford <CrawfordMA(at)ChurchofJesusChrist(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [Ext:] Configuration of pgaudit settings in postgreSQL.conf causes postgreSQL to fail to start
Date: 2021-10-06 16:43:48
Message-ID: DM6PR05MB65215AC4F0BC047750CE4974F3B09@DM6PR05MB6521.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><div dir="auto">The engineers rebuilt the pgaudit extension and the issue went away on our end.&nbsp; Note that pgaudit is version specific and would need to be built for each version.&nbsp; I'd suggest if you're having a similar issue to ours that you rebuild pgaudit from source and try again.&nbsp;&nbsp;</div><div class="gmail_extra"><br><div class="gmail_quote">On Oct 6, 2021 10:06, Allie Crawford &lt;CrawfordMA(at)ChurchofJesusChrist(dot)org&gt; wrote:<br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">
<div>
<p>Troy,</p>
<p>I am running into the same problem where I am not able to deploy the pgaudit parameter setting into the postgresql.conf file because every time I do that and restart the postgresql cluster, it &nbsp;is just fail, I cannot get the pgaudit setting
on the postgresql.conf file. Have you find a solution to this problem? Would you be kind enough to share with me the implementation of the solution to allow the postgresql.conf file to have the pgaudit parameter settings so that they can be applied to all
the databases in the cluster?</p>
<p>&nbsp;</p>
<p>Thank you in advance for your help on this.</p>
<p>&nbsp;</p>
<p>Regards,</p>
<p>Allie Crawford</p>
<p>&nbsp;</p>
<div style="border:none;border-top:solid #b5c4df 1pt;padding:3pt 0in 0in 0in">
<p style="margin-bottom:12pt"><b><span style="font-size:12pt;color:black">From:
</span></b><span style="font-size:12pt;color:black">pgsql-general-owner(at)postgresql(dot)org &lt;pgsql-general-owner(at)postgresql(dot)org&gt; on behalf of Troy Hardin &lt;t_hardin69(at)hotmail(dot)com&gt;<br>
<b>Date: </b>Wednesday, October 6, 2021 at 8:57 AM<br>
<b>To: </b>pgsql-general(at)postgresql(dot)org &lt;pgsql-general(at)postgresql(dot)org&gt;<br>
<b>Subject: </b>[Ext:] Configuration of pgaudit settings in postgreSQL.conf causes postgreSQL to fail to start</span></p>
</div>
<h3><span style="color:red">[External Email]</span></h3>
<div>
<div>
<p><span style="font-size:12pt;color:black">I support an existing product that utilizes postgreSQL in a Windows environment.&nbsp; Recently we've been asked to make a series of security/auditing changes to the product that require pgaudit.&nbsp; We built pgaudit.dll
and have made the majority of the configuration changes and those seem to be working as designed.&nbsp; The pgaudit extension does what it is being required to do, but we are running into issues with configuring some settings globally in the postgresql.conf.</span></p>
<p><span style="font-size:12pt;color:black">&nbsp;</span></p>
<p><span style="font-size:12pt;color:black">The two lines we need to run in the .conf file that are causing postgresql to fail to start are, for example:</span></p>
<p><span style="font-size:12pt;color:black">&nbsp;</span></p>
<p><span style="font-size:12pt;color:black">pgaudit.log = 'read, write, ddl, role'</span></p>
<p><span style="font-size:12pt;color:black">pgaudit.log_level = 'log'</span></p>
<p><span style="font-size:12pt;color:black">&nbsp;</span></p>
<p><span style="font-size:12pt;color:black">Putting either of these two lines in the .conf file cause it to fail to start.&nbsp; However, after starting postgreSQL, I can go to command line and run the SQL to set these and they run fine.&nbsp; After running them, pgaudit
performs as designed and configured so I believe we've compiled pgaudit.dll correctly.&nbsp; At any rate, I'm at wits end right now and need to either fix the above or find someone with more db experience to assist in creating triggers that would run the SQL SET
commands after startup.</span></p>
<p><span style="font-size:12pt;color:black">&nbsp;</span></p>
<p><span style="font-size:12pt;color:black">Are there known reasons why I might be having this issue?&nbsp; Anyone have experience getting past something similar?</span></p>
<p><span style="font-size:12pt;color:black">&nbsp;</span></p>
<p><span style="font-size:12pt;color:black">v/r</span></p>
<p><span style="font-size:12pt;color:black"><br>
Troy R. Hardin</span></p>
</div>
</div>
</div>
</div>
</blockquote></div><br></div>

Attachment Content-Type Size
unknown_filename text/html 4.1 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2021-10-06 21:59:28 Using make_timestamp() to create a BC value
Previous Message Marc Millas 2021-10-06 15:50:09 Re: streaming replication different versions