On 2018-10-29 14:56:06 -0400, Tom Lane wrote:
> Igor Korot writes:
> > Or I will have to change the owner/group manuall every time I will
> > access the file?
>
> You can set up the log files as readable by the OS group of the server
> (see log_file_mode), and then grant membership in that group
On 11/06/2018 12:06 PM, Igor Korot wrote:
[snip]
Ok.
I guess I will have to write such function.
Cron and the relevant log_* config variables should solve your problems.
--
Angular momentum makes the world go 'round.
Hi, guys,
For some reason this reply was in my "Spam" folder (gmail service).
I guess moving to the new mailer service is not completely safe for "Spam".
So replying now - apologies to be late.
On Wed, Oct 31, 2018 at 2:00 AM Laurenz Albe wrote:
>
> Igor Korot wrote:
> > Now is there a command t
On 10/30/18 9:20 AM, Igor Korot wrote:
Now is there a command to flush the log - delete the content of it?
The only thing I know of is:
https://www.postgresql.org/docs/10/static/functions-admin.html
pg_rotate_logfile() boolean Rotate server's log file
All I'm looking for in th
Igor Korot wrote:
> Now is there a command to flush the log - delete the content of it?
No, managing the logs is outside of PostgreSQL's responsibility.
But it shouldn't be a problem to do this outside the database.
Of course you could write a funtion in PostgreSQL that uses one
of the "untrusted
Now is there a command to flush the log - delete the content of it?
All I'm looking for in the log are DDL commands - CREATE/ALTER/DELETE ones.
On Wed, Oct 31, 2018 at 12:32 AM Igor Korot wrote:
>
> Hi, Tom,
>
> On Mon, Oct 29, 2018 at 5:08 PM Tom Lane wrote:
> >
> > Igor Korot writes:
> > >
Hi, Tom,
On Mon, Oct 29, 2018 at 5:08 PM Tom Lane wrote:
>
> Igor Korot writes:
> > On Mon, Oct 29, 2018 at 1:56 PM Tom Lane wrote:
> >> You can set up the log files as readable by the OS group of the server
> >> (see log_file_mode), and then grant membership in that group to whichever
> >> OS
Igor Korot writes:
> On Mon, Oct 29, 2018 at 1:56 PM Tom Lane wrote:
>> You can set up the log files as readable by the OS group of the server
>> (see log_file_mode), and then grant membership in that group to whichever
>> OS accounts you trust. You may also need to move the log directory
>> out
Hi, Tom,
On Mon, Oct 29, 2018 at 1:56 PM Tom Lane wrote:
>
> Igor Korot writes:
> > I'm trying to test the functionality of logging on my older Mac with
> > PostgreSQL 9.1.
> > I see that the logile is created with the owner of postgres and the
> > group of wheel.
>
> Well, more specifically, it
Igor Korot writes:
> I'm trying to test the functionality of logging on my older Mac with
> PostgreSQL 9.1.
> I see that the logile is created with the owner of postgres and the
> group of wheel.
Well, more specifically, it's created under the OS user & group that
the server is running under.
>
I initially sent this to the ODBC list.'
Thank you for any suggestions.
-- Forwarded message -
From: Igor Korot
Date: Sun, Oct 28, 2018 at 11:03 PM
Subject: Log file
To: PostgreSQL ODBC list
Hi, ALL,
I'm trying to test the functionality of logging on my older Mac with
PostgreS
11 matches
Mail list logo
