Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

Hi Kenan, Thanks for the quick response. Thanks Vijay On Tue, Apr 15, 2025 at 4:44 PM KENAN ÇİFTÇİ wrote: > Hi, > > You can use pgaudit and pgauditlogtofile extension ( > https://github.com/fmbiete/pgauditlogtofile) together to write audit logs > in a separate file. > > yours, > > Kenan Çiftçi

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 5:24 PM Adrian Klaver wrote: > > > > By creating the initial three databases the system is more usable due to > > having established conventions. They are conventional databases, not > > system ones. > > The bottom line is the Postgres project has built an infrastructure

Re: Fwd: Identify system databases

On 4/15/25 11:35, David G. Johnston wrote: On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: 1) Try connecting(not using single user mode) to a cluster without them. First I have had this discussion before and was not successful and I expect the

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 3:11 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver < > adrian.kla...@aklaver.com> > > wrote: > >> If what you say is true why does initdb lack an option to not create > >> them on creating a cluster? > > > By creating

Re: Fwd: Identify system databases

"David G. Johnston" writes: > On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver > wrote: >> If what you say is true why does initdb lack an option to not create >> them on creating a cluster? > By creating the initial three databases the system is more usable due to > having established conventions

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 11:20 AM Adrian Klaver wrote: > On 4/15/25 09:48, David G. Johnston wrote: > > On Tue, Apr 15, 2025 at 9:31 AM Adrian Klaver > > wrote: > > > > > > > Agreed. > > > > The fact that initdb creates the template0, template1 and postgr

Re: Fwd: Identify system databases

On 4/15/25 09:48, David G. Johnston wrote: On Tue, Apr 15, 2025 at 9:31 AM Adrian Klaver > wrote: Agreed. The fact that initdb creates the template0, template1 and postgres databases and you can't change that makes them system not user datab

Re: Fwd: Identify system databases

On Tue, Apr 15, 2025 at 9:31 AM Adrian Klaver wrote: > On 4/15/25 09:21, Igor Korot wrote: > > > > > > > Hi, David, > > > > On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston > > mailto:david.g.johns...@gmail.com>> wrote: > > > > On Tuesday, April 15, 2025, Igor Korot >

Re: Fwd: Identify system databases

On 4/15/25 09:21, Igor Korot wrote: Hi, David, On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Tuesday, April 15, 2025, Igor Korot mailto:ikoro...@gmail.com>> wrote: Hi, ALL, Is there a field in the pg_databases table w

Re: Identify system databases

Adrian Klaver writes: > On 4/15/25 07:48, Igor Korot wrote: >> Is there a field in the pg_databases table which indicates that >> particular DB is a system one? > No there is not. As a practical matter they are no different then any > user created database, other then template0 is created with

Fwd: Identify system databases

-- Forwarded message - From: Igor Korot Date: Tue, Apr 15, 2025 at 11:16 AM Subject: Re: Identify system databases To: Adrian Klaver Hi, Adrian, On Tue, Apr 15, 2025 at 10:07 AM Adrian Klaver wrote: > On 4/15/25 07:48, Igor Korot wrote: > > Hi, ALL, > > Is there a field in th

Fwd: Identify system databases

-- Forwarded message - From: Igor Korot Date: Tue, Apr 15, 2025 at 11:15 AM Subject: Re: Identify system databases To: David G. Johnston Hi, David, On Tue, Apr 15, 2025 at 9:56 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, April 15, 2025, Igor Korot

Re: ICU Collations and Collation Updates

Hi Laurenz, > On 14 Apr 2025, at 19:36, Laurenz Albe wrote: > > You cannot "bake in into" PostgreSQL, but you can grab the ICU source, > install it in /usr/local or similar and build PostgreSQL against that. > You will have to fiddle with CFLAGS and LDFLAGS so that the build process > uses the C

Re: Help with PhD Dissertation

I'm not collecting emails in the survey El mar, 15 abr 2025 a la(s) 11:25 a.m., Karsten Hilbert ( karsten.hilb...@gmx.net) escribió: > > > > The survey [...] is completely anonymous. > > > > > > Nope. > > > > > > > Can you elaborate on this, please, for my sake and others? > > I was, certainly so

Re: Help with PhD Dissertation

> > > The survey [...] is completely anonymous. > > > > Nope. > > > > Can you elaborate on this, please, for my sake and others? I was, certainly somewhat tersely, trying to point out that using Google Forms nearly precludes anonymity unless one accesses them via Tor or some such. Best regards,

Re: Help with PhD Dissertation

Am Tue, Apr 15, 2025 at 11:26:35AM -0400 schrieb Osmel Brito-Bigott: > I'm not collecting emails in the survey Don't get me wrong, I am not questioning your good faith or intent. Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Identify system databases

On 4/15/25 07:48, Igor Korot wrote: Hi, ALL, Is there a field in the pg_databases table which indicates that particular DB is a system one? No there is not. As a practical matter they are no different then any user created database, other then template0 is created with datallowconn set to f

Re: Identify system databases

On Tuesday, April 15, 2025, Igor Korot wrote: > Hi, ALL, > Is there a field in the pg_databases table which indicates that particular > DB is a system one? > What is a system database? David J.

Identify system databases

Hi, ALL, Is there a field in the pg_databases table which indicates that particular DB is a system one? Or it can be determined ony by name? Thank you.

Re: Help with PhD Dissertation

On Tue, Apr 15, 2025 at 7:20 AM Karsten Hilbert wrote: > > The survey [...] is completely anonymous. > > Nope. > Can you elaborate on this, please, for my sake and others?

Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

Hi All, We are exploring auditing solutions for our PostgreSQL database and are considering using pgaudit for this purpose. However, we have a few questions: 1. *What is the best tool for auditing PostgreSQL databases?* - We are specifically looking for a solution that offers det

Re: Help with PhD Dissertation

Am Mon, Apr 14, 2025 at 09:27:30PM -0400 schrieb Osmel Brito-Bigott: > forms.gle > > The survey [...] is completely anonymous. Nope. Karsten Hilbert -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

Hi, You can use pgaudit and pgauditlogtofile extension ( https://github.com/fmbiete/pgauditlogtofile) together to write audit logs in a separate file. yours, Kenan Çiftçi On Tue, Apr 15, 2025 at 1:44 PM vijay patil wrote: > Hi All, > > We are exploring auditing solutions for our PostgreSQL da