Subject: Re: Fwd: Log file
To: Igor Korot <ikorot01@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general <pgsql-general@postgresql.org>
References: 
 <CA+FnnTy4b=gSVw+dJwijoiFoeQNQMKZq65feupZgJh4-uuyKVQ@mail.gmail.com>
 <CA+FnnTw5Z=XoV=GyeC0-x85Q_MdJ0+hr6UD1Y5=NByG4SfzxyQ@mail.gmail.com>
 <18469.1540839366@sss.pgh.pa.us>
 <CA+FnnTwb4V++4WRQj1vCBQ0Pb_NPR3pxjJgyGpuCXHOhFuXpmQ@mail.gmail.com>
 <23733.1540847335@sss.pgh.pa.us>
 <CA+FnnTy3w426agu3pxk2Yx_Og_682UaqZg2bcyc8mZ0W1sfqNw@mail.gmail.com>
 <CA+FnnTzHHi4R2gM--iXteQDpGw4pDp9ci8nVnVUWNFG-CKazRw@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <c49a08fe-973e-d6fa-89a0-eaa2c4381280@aklaver.com>
Date: Wed, 31 Oct 2018 05:51:55 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.2.1
MIME-Version: 1.0
In-Reply-To: 
 <CA+FnnTzHHi4R2gM--iXteQDpGw4pDp9ci8nVnVUWNFG-CKazRw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

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 the log are DDL commands - CREATE/ALTER/DELETE ones.
> 
> 
> On Wed, Oct 31, 2018 at 12:32 AM Igor Korot <ikorot01@gmail.com> wrote:
>>
>> Hi, Tom,
>>
>> On Mon, Oct 29, 2018 at 5:08 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>>
>>> Igor Korot <ikorot01@gmail.com> writes:
>>>> On Mon, Oct 29, 2018 at 1:56 PM Tom Lane <tgl@sss.pgh.pa.us> 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 from under $PGDATA to make that work, since PG doesn't like
>>>>> world-readable data directories.
>>>
>>>> I'm trying to make the log file of PG readable of the user who logs in
>>>> to the current
>>>> OS session. I don't need a write permission, just read.
>>>> Because my program will not be started from the "postgres" account.
>>>
>>> Well, any such setup is a serious security hole in itself, because
>>> there is likely to be sensitive data in the postmaster log, eg
>>> passwords.  (Remember that the log file is global to the whole cluster,
>>> it will not contain just data relevant to the current session.)
>>> You should only grant access to people who you trust at more or less
>>> the level of trust you'd put in the installation DBA.
>>>
>>> It may be that these concerns are all irrelevant to you because it's
>>> a single-user installation anyway, but they're not irrelevant to
>>> people running multi-user installations.  So that's why you can't
>>> get Postgres to do it.  In a single-user installation, maybe you
>>> should just launch the postmaster as that user.
>>>
>>>                          regards, tom lane
>>
>> OK, I understand.
>>
>> Thank you.
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com